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