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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only