General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How to Trap and recover from ODBC errors.
I am writing an application that will be updating a Sybase data base bia ODBC. I have successfully created a connection and have a remote view on the table that I wish to update. I have a test program that is presently filling the above table with test data.
Now, I have been reading the aerror documentation and this is how the error detail is handled.
In the form that I am using to update the view, I have code in the error method.
The code fires on an ODBC error, however, I do not know how to recover from it.
The error states that the connection has been lost.
I can manually restart the program if I do this:
1. Select the view.
2. Do a tablerevert... I am using row buffering, so this would ony remove the last tranasaction.
3. Close the table. This generates another ODBC error, about the connection being lost, however the table is closed.
4. Close the form.
5. Restart the form.
However, I need this to happen automatically...
Any ideas?
TIA,
Mike
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