Hello George,

Great answer!
Thanks
Jim

>>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.