Subject Re: [IBO] ISC Error in html Page
Author Helen Borrie
At 12:45 AM 4/08/2003 -0400, you wrote:
>Greetings,
>
>The page in question consists of an html form that, on submission, applies a
>sql update using the Execute method of tIboQuery.
>
>When attempting to exit from the page with the browser's "Back" button, my
>sql error trapper recovers the following message:
>
>ISC ERROR CODE:335544569 ISC ERROR MESSAGE: Dynamic SQL Error SQL error code
>= -104 Token unknown - line 1
>
>First thought was that "Go Back" is somehow being interpreted as "submit"
>with a blank or malformed sql command, but tracing the source shows this is
>not the case.
>
>When running in the Delphi-6 IDE, the debugger stops at line 7366 of
>IBODataset.pas, procedure TIBOInternalDataset.DoHandleError().
>
>Running under Win2k SP-4 with localhost (IIS web server) and WebHub as the
>host application, connected to a Firebird dataset.
>
>Would like to be able to see what sql command, if any, the above-mentioned
>procedure is trying to handle. My code tests for sql command length < 10;
>that condition is not met, and my sql execute command is not being called;
>therefore, I cannot see any sql command by tracing within my code.

All that's happening here is that an untrapped bad SQL statement error is
getting raised to the default error handler. You have an "=" sign in a
statement where it shouldn't be, e.g. somehow your code has constructed an
update statement perhaps similar to
"update mytable set = "

If you can get your app into a form where you can read the statement
immediately before it is prepared, and log it somewhere, you should be able
to find out what's going wrong.

Helen