Bob,

First, I notice that you're missing a ) at the end of the second ALLTRIM(). If that's just a typo in your message you may want to use AERROR() after the SQLEXEC() fails to see what error message the ODBC driver is returning.

>I have two sqlexec() statements the second one works fine the first one fails. Any ideas as to the reason would be appreciated.
>
>FAILS:
>d=sqlexec(m.novasql,"update necxbox set status ='G' where alltrim(necxbox.track_num) =?m.trknum and alltrim(necxbox.boxnum =?m.boxnum")
>WORKS:
>d=sqlexec(m.novasql,"update necxbox set status ='S' where alltrim(necxbox.track_num) =?m.trknum")
>
>Thanks,
>
>Bob Mclintock
>r_mclintock@excite.com