Greg Rice wrote:

> I am doing a select on an Image/Sql database and getting the message
>
> Select Error SQLSTATE = S1000
> Image/Sql Error 111, Turbo Image Error -52, Turbo Image Intrinsic 404 &
> Auxilary Error 0. (DBERR 13552)
>
> I know the Image error means that I was using a bad list or more than
> likely trying to do a DBFIND on an item that is not a search item. However
> how do I force it to not do a DBFIND.
>
> My select statement looks like this,
>
>   SELECT ...
>
>     FROM DATASET
>    WHERE DATABASE.DATASET.COLUMN = 'QT'  ;

If DATASET is a detail, a DBFIND is done to retrieve the chain information
and subsequent DBGETs are done to retrieve the data. To force a DBGET
(without a DBFIND), the following SQL statement can be used:
  Setopt general serialscan
(Note: This may affect performance)

>
> When I change it to
>
>
>   SELECT ...
>
>     FROM DATASET
>    WHERE DATABASE.DATASET.COLUMN >= 'QT'  ;
>
> Everything works fine, however the results aren't what I need. I was
> assuming this is forcing it to not do a DBFIND.

This will do a DBGET (mode 2) directly assuming no indexes exist.

Hope this helps.

Regards,

Kumar
CSY, Bangalore