Search:

Type: Posts; User: Wim Schimmel

Page 1 of 9 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: sql insert into and update a numeric field with value of Function

    My develop computer and SQL server have both a , for decimal and . as seperator at region settings of windows. In the opties settings of DR also the same. The field on my report have also a , for...
  2. Re: sql insert into and update a numeric field with value of Function

    if I use cint({@Total}) the insert works

    in all other cases I get an error converting data type varchar to numeric
  3. Re: sql insert into and update a numeric field with value of Function

    TotalAmount is a Numeric
    I try
    let Update = SQL("Insert into [dbo].[Facturen] ([FactuurNr], [Date], [TotalAmount]) Values ('" + CStr(iFactnr) + "' , '" + CStr({?dsFactDate}) + "' , '" + 120.25 +...
  4. sql insert into and update a numeric field with value of Function

    sql insert into and update a numeric field (TotalAmount) in the dBase with value of Function (@Total)

    There is an error on field {@Total}
    Is there a conversion needed ?



    dim iFactnr as...
  5. Replies
    6
    Views
    285

    Re: SQL statement

    Vincent,

    My report has a subreport on SQL statement , i want to use asql statement to update my database
    I get this error -42
    If using the same function in a report on normal dbase connection...
  6. Thread: sql()

    by Wim Schimmel
    Replies
    7
    Views
    476

    Re: sql()

    strange Special Field Page Number is 1 after option reset pagenumber after this section on screen, but in the sql function this parameter is has the value 2 or higher
    If Page N of M used then &Page...
  7. Thread: sql()

    by Wim Schimmel
    Replies
    7
    Views
    476

    Re: sql()

    strange Special Field Page Number is 1 after option reset pagenumber after this section on screen, but in the sql function this parameter is has the value 2 or higher
    If Page N of M used then &Page...
  8. Thread: sql()

    by Wim Schimmel
    Replies
    7
    Views
    476

    Re: sql()

    the problem is special field PAGE N OF M, if remove this field from my report no problems
    PS the sql script add 1 to my system factnr it rans twice id PAGE N of M is on the report
  9. Thread: sql()

    by Wim Schimmel
    Replies
    7
    Views
    476

    Re: sql()

    Vincent,

    in the header section and a another fuction in the total section

    Wim
  10. Replies
    3
    Views
    205

    Re: DR7.0 SQL statement subreport

    Thanks Rol ,

    The filter function is clear
    But that's not my question, I want add that filter on my sql script for that subreport.
    I know about option of sql ? parameter but how to change that to...
  11. Replies
    3
    Views
    205

    DR7.0 SQL statement subreport

    I have a report with a subreport based on sql statement. (Header and subreport on OrderLines)
    How to add filter that only the orderlines records from that actieve header select
    My Header.Id is...
  12. Replies
    1
    Views
    160

    SQL() statement to Date field

    How to get a date field in my report from sql statement on my dbase tabel with a date field
    It retuns always a string and not a date field
  13. Thread: sql()

    by Wim Schimmel
    Replies
    7
    Views
    476

    sql()

    Report refresh or start execute all sql() two times, why.
    How to stop this, workaround ?

    Wim
  14. Replies
    6
    Views
    285

    SQL statement

    Report on table of managed connection , I can add a SQL statement in a function this is ok
    On report create on sql statement and add the same sql statement in a function i get an error
    error -42...
  15. DR 7 managed connection 2 database and SQL()

    Missing the option of a second sql statement to database in DR7
    My webapplication has a managed connection with more than one database.
    I will use sql statement on both databases

    How to get this...
  16. Replies
    1
    Views
    343

    VDF 19.1 and SecurityMatters

    Hi,

    Installed 19.1 version 58.

    Create new project passcode storage parameter estimation project.

    2 Compiler errors

    Which pkg or inc file is where missing
  17. Replies
    1
    Views
    180

    Re: SPLF license on which server

    I found , SLF on webserver and user license on the slaves (not the same)
  18. Replies
    1
    Views
    180

    SPLF license on which server

    Hi,

    1 master and 2 slaves which license should I install on which server. I have a web client license and 2 splf licenses.

    Wim
  19. Replies
    14
    Views
    996

    Re: Get_File_Mod_Time too slow!

    I had a slow performance with opening a file on network share (more then 10 second to open and read the file) (Created by other communication program (biztalk))
    Change some registry keys at...
  20. Replies
    1
    Views
    750

    Re: Dr 7.0.1.9626

    Ulbe send me update , it was not a sql driver problem
    Using now sql odbc driver 17 17.3.1.1

    remove 17 add version 13 datetime field are dates datetime2 fields are strings
  21. Replies
    1
    Views
    750

    Dr 7.0.1.9626 dates are strings

    update 6.2 reports to 7.01 sql managed connection after connect to new sql server check database all datetime fields are string fields



    I also had the same problem with a previous version in...
  22. Replies
    0
    Views
    548

    SPLF and Firewall

    Install my master webserver at the first Router and portforwarding port 80 and 443 to this computer 192.168.1.61 (Router 192.168.1.1)
    Add my first node Server (192.168.3.62) on the second...
  23. Replies
    19
    Views
    1,310

    Re: testing SPLF

    Harm ,

    Thanks for your explanation, i drop the file in the webordermobile workspace and add it to the webapp.src.
    Running the URL works

    What to do , so users can run this from a view

    Wim
  24. Replies
    19
    Views
    1,310

    Re: testing SPLF

    My reports in the test are simple and generate by the report wizard.
    So SPLF and reports are not working without create a new handler.

    Somebody share this handler code as a sample.

    Wim
  25. Replies
    19
    Views
    1,310

    Re: testing SPLF

    Peter,

    Thanks, my pdf document are created on slave node (19.1).

    I hope DAW can Explain how to work with this
Results 1 to 25 of 209
Page 1 of 9 1 2 3 4