strange error

[qwertyjjj]

We get the following erro in an application after about 60 seconds (attached).
Just says Invalid SQL statement.

Sometimes it does not occur, sometime you have to click in a box and then click out of it.
Some of the forms are bound to a table so could this be an ODBC timeout issue?
If so, how do we get around this?

 

[FoFa]

I would disable any error trapping, and see if you can isolate it to the actual statement.
just as a starter

 

[qwertyjjj]

I'm not sure but I don't think an actual statement is running.
Maybe the error message is unrelated somehow.
There are no timers on the form or any statement that would cause this to run when just clicking about between boxes.

 

[boblarson]

I've had this problem before when my database was linked to a backend which it couldn't find the table. But, I would do as FoFa has suggested and disable error handling so you might get a debug button to go find the problem.

To do so you can use the replace (EDIT > REPLACE)

1. select entire project as the option to search and replace

2. replace On Error GoTo with ' On Error GoTo

then you can reverse it the same way by getting rid of the single quote:

replace ' On Error GoTo with On Error GoTo

 

[qwertyjjj]

when error tracking is turned off the error never appears.
However, when I put back on error goto, it happens again.
!
Anyway to check for a database connection in the error handling and then reconnect somehow?