Hello fellow colleagues!
I have the following problem. I'm testing around with SQL and have the following code:
0100 ! ^100
0110 LET DATABASE$="[ODB]lansweeper;"
0120 LET OPT$="USER=lansweeperuser;PSWD=***********"
0130 LET DB1=HFN
0140 OPEN (DB1,OPT=OPT$)DATABASE$
0150 GOSUB READ_IT
1000 READ_IT:! ^1000
1010 LET ASSETID=34393
1015 LET SEL_STRG$="select assetname from tblassets where ASSETID="+STR(ASSETID)
1016 READ (DB1,KEY=SEL_STRG$)
1017 LET SEL_STRG$="update tblassetcustom set custom1='400_neu' where ASSETID="+STR(ASSETID)
1020 ! READ RECORD (DB1,KEY=SEL_STRG$)SATZ$
1025 READ (DB1,KEY=SEL_STRG$)
1030 READ (DB1)A$,B$,C$
9900 ENDE:! 9900
9910 ESCAPE
Unfortunately I get an error message during the command to update.
->run
1025 READ (DB1,KEY=SEL_STRG$)
Error #15: Operating system command failed
Last IO to [ODB]lansweeper;, channel 63
Current program is C:\PVX\SQLTEST1, line 1025
HY010: [Microsoft][ODBC Driver Manager] Fehler in der Funktionsreihenfolge
1>
However, the value was still correctly written to the SQL database...
What am I doing wrong?
Maybe you can help me?
Many thanks!
Thomas