>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
>
As a workaround you could try
WHERE DATABASE.TABLE.COLUMN >= 'QT' AND DATABASE.TABLE.COLUMN <= 'QT';