Subject | Re: [IBO] Cursor unknown error in TIB_Script |
---|---|
Author | Helen Borrie |
Post date | 2005-08-11T00:21:02Z |
At 07:26 PM 10/08/2005 +0000, you wrote:
cursor (a pointer to a set that is output by a SELECT statement or is
defined by an update or delete statement) and the handle becomes
invalid. The handle will be invalid once the cursor has reached EOF; or
it may be invalid because code is referring to a cursor that never existed
because an exception occurred when the application first tried to get the
handle.
sure that user has the correct interbase.msg file? Even if the server has
the correct file, does the client have a wrong version of the file in its
application path?
Can't suggest anything as a cure. It appears to be a total "non sequitur".
Helen
>I run my script in a loop (I have 20 tables) where I substitute TABLEThis exception occurs when the application has a handle on a database
>with various names. One customer complains that he always gets the
>error with 12. table. The error is: SQL Error -504, "Cursor unknown".
cursor (a pointer to a set that is output by a SELECT statement or is
defined by an update or delete statement) and the handle becomes
invalid. The handle will be invalid once the cursor has reached EOF; or
it may be invalid because code is referring to a cursor that never existed
because an exception occurred when the application first tried to get the
handle.
>Nobody else has complined, it works perfectly in my computer (alsoThe statements here appear to have nothing to do with cursors. Are you
>with customers database). We both use FB 1.03 installed into local
>computer.
>
>TIB_Script (IBO 4.2Hc):
>---
>drop trigger LOG_<<TABLE>>_AD;
>drop trigger LOG_<<TABLE>>_AI;
>drop trigger LOG_<<TABLE>>_AU;
>commit;
>---
sure that user has the correct interbase.msg file? Even if the server has
the correct file, does the client have a wrong version of the file in its
application path?
Can't suggest anything as a cure. It appears to be a total "non sequitur".
Helen