Subject | Re: [IBO] ISC Error in html Page |
---|---|
Author | Helen Borrie |
Post date | 2003-08-04T05:55:16Z |
At 12:45 AM 4/08/2003 -0400, you wrote:
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
>Greetings,All that's happening here is that an untrapped bad SQL statement error is
>
>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.
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