>I have a VFP to MSSQLServer app. The server is running jobs all the time that currently involve SELECT with order by and update statements. A VFP app attempts to do an insert via SQLexec() and gets a result of "SQL Conflict retry later"
>
>This text string is not referenced in the VFP hepl anywhere.
>
>How can I avoid or capture this error? It does not appear to have an error number.
Jeff,
If you're using SQLEXEC(), it will return a negative number on an error. When it does, use AERROR() to capture the error information.
I search the SQL Books Online and didn't find anything matching the error that you mentioned. It would be helpful if you could get an error number and whether it was coming from ODBC or SQL Server.
-Mike