Your right, this is from the DBFIND (intrinsic #404), and the error -52 means
that the FOPEN failed to find the file.  Make sure that your not missing any
datasets (an easy way is to go into QUERY and do a 'FO SETS' for that
database.  If your missing any sets, you'll see the error 52 again there.  If that
works ok, are you utilizing Omnidex or SuperDex?  If so, then something is
probably not setup correctly there (I've not played with either from Image/SQL,
so I'm not sure what to look for there).

Regards,
Michael L Gueterman
Easy Does It Technologies
email: [log in to unmask] (temporarily)
http://www.editcorp.com (coming soon!)
voice: (509) 946-6179
fax:    (509) 946-1170
--


----------
From:  Greg Rice[SMTP:[log in to unmask]]
Sent:  Wednesday, October 09, 1996 9:11 AM
To:  [log in to unmask]
Subject:  Image/Sql Error 111

I have a select statement that is generating the following error in
imagesql.

IMAGE/SQL error 111; TurboIMAGE error -52; TurboIMAGE intrinsic 404, &
Auxiliary error 0.  (DBERR 13552)
Can not continue with SELECT. (DBERR 97)

I am assuming that this is generating a DBFIND and my where cause is not
a key based on the return codes. However how do I get it to not do a
DBFIND.

The following is my select statement.

SELECT DATABASE.TABLE.COLUMN
FROM DATABASE.TABLE
WHERE DATABASE.TABLE.COLUMN = 'QT';

When I change the where clause to be
WHERE DATABASE.TABLE.COLUMN >= 'QT';

Everything works fine. Unfortunately the results are not what I want.

Any help?

Greg Rice
Software Engineer
Prevue Networks, Inc.
Tulsa, OK