>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.
Hi Jeff
First of all check out for the Automatic Transaction Property of connection. If this property is set to .F. i.e. Does not COMMIT the transaction. This keeps the connection handle busy. so whenever you try to excute next SQL , it fails.
Try with Automatic Transaction Property = .T.
- Jayesh