bwc3068 wrote:

> ...
> what is it: random errors returned and they are usually Access

Violation errors OR "dynamic SQL error -206 unknown column".

>
> the column named in the error is never a column in the table (for

example "K-000") AND my SQL to fetch the query is always "select *
from atable". the source level query is persistent and has all the
fields in it at the source code level (ie. they're created in source
and in the query ie. persistent).

> ...

You could try to use the onError event for the query (or queries) and
log whatever information it provides. It will be something like:

procedure TDM1.qrYOURQUERYError( Sender : TObject;
const ERRCODE : integer;
ErrorMessage,
ErrorCodes : TStringList;
const SQLCODE : integer;
SQLMessage,
SQL : TStringList;
var RaiseException : boolean);

... ...
Write all values to a log file and have the customers send it to you
- maybe you'll find something of interest.
If a customer van provoke the error, you could provide him with some
facility to turn on a trace (IBO feature).
I haven't used D6 + Fb/2.1 + IBO/4.8.7 myself, you could try asking
the the IBO list (egroups.ibobjects)


--
Aage J.
ps
I don't think "speed issue" is the issue here ...