You can use AERROR() function to get ODBC error message. Meanwhile, you can try to build whole update SQL string.
lcUpdateString = [UPDATE BEST SET ] + lprFieldName + [ = '] + [lprFieldValue] + ['] + ;
[ WHERE BESTNR=] + Transform(nBestnr)
>Sergey,
>
>I can not get it work as you proposed, maybe because I do not understand how to include the last part of my update command: "WHERE BESTNR=?nBestnr". "BESTNR" is the name of one SQL table field (number) and "nBestnr" is my number parameter. I tried this:
>
>lcUpdateString = [UPDATE BEST SET ] + lprFieldName + [ = '] + [lprFieldValue] + [']+ ' WHERE BESTNR=?nBestnr'
>
>When I look at the value of lcUpdateString in the debugger WATCH window it looks OK, but nUpdate=SQLEXEC(nCon,lcUpdateString) returns -1
--sb--