Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>I had not read the entire exchange after your post me, but I now see that you tried THROW. So it's possibly my answers aren't needed.
I now have a ??sqlexec prg which checks if the connection has failed, and attempts to reconnect, then waits for the connection to not be busy. The only thing that works consistently is for me to record and enable manual transactions over the connection, sqlexec the command, check for any error - which I can report via aerror and then attempt a sqlcommit. If that fails use aerror again and roll back, then reset the transactions.
I am guessing sql is handling the error and vfp 6 does not seem to like the throw or raiserror so much.
Previous
Next
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