>hello group,
>
>I am using the
>lcScript = "DRIVER=SQL Server;SERVER=myserver;UID=sa;PWD=mypassword;APP=Microsoft® Visual FoxPro®;WSID=AUDAT;DATABASE=mydatabase"
>
>lnHandle= SQLSTRINGCONNECT(lcScript)
>
>
>Which I guess is an ODBC connection.
>
>If I try to insert a row and violate a table constrait like a PK restraint, is there any way to pick up this error in the foxpro program?
>
>Thanks
Jim,
Use AERROR(). The third column will contain the error message.
George
Ubi caritas et amor, deus ibi est