Subject Re: intermittent errors with what seems to be server speed issues?
Author bwc3068
would not having KeyLinks defined (all i have is a primary key defined in the tables) cause the problem on only some computers?

the troubling issue is, if i run my application on my PC with my customer's database, i do not get any error messages. i've never seen the errors I'm talking about on my local install with a local database (ie. running it all on my C:). it's only on server installs of the executable and users running the app across a LAN that the errors have ever occured (when they do).

if they run it on theirs, they get the messages one time in 10 executions of the exact same function with the exact same SQL with the exact same record set being returned.

it's that inability of the problem to be repeatable that has me stumped and thinking it's not in my source code directly like a "syntax error" or a simple logic error.

thanks!
kelly

>
> sounds like 'your error' to me.
> IBO wants to know the primary key. You are using select * and probably using
> 'keylinks auto define' and not declaring a specific key which forces IBO to
> use the DBKEY to retrieve specific rows when it needs to refresh its query
> buffer. Are these queries all from normal tables? This happens most from a
> join. Anyway I think this is an IBO list issue. Swallow and report the
> exception for the moment until you find out why, so your users aren't
> annoyed by it.
> Alan
>