Subject | RE: [IBO] Cursor unknown error -504 |
---|---|
Author | Alan McDonald |
Post date | 2004-08-08T09:20:01Z |
> Thanks Helen.Hmm, and make sure that all queries which have a PK which is truly a PK in
>
> The problem seems to happen when you return to the application after
> switching to another task or if the application has been idle for a
> period of time. The error message is sitting there when the screen
> appears. And it happens on stand alone machines as well as when
> using a server. I have never seen it happen when actively using the
> application.
>
> The app has a timer that refreshes the data displayed in a grid
> every minute in case someone adds a new record but this doesn't seem
> to be the cause. I put a try - except around the refresh but it
> doesn't trap the error.
>
> If I knew what the error message means it might point me in the
> right direction.
>
> Regards
>
> Bob
the KeyLinks, also has the KeyLinksAutoDefine check box/Property set to OFF.
This prevents IBO generating a PK of it's own.
And Helen - just a thought but if you programtically manipulate a query e.g.
change the SQL or clear the update SQL property or something like that..
Does this have any effect on the KeyLinks property? Does it clear it when
you prepare the query again?
Just thinking..
Alan