HP3000-L Archives

October 1996, Week 2

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Greg Rice <[log in to unmask]>
Reply To:
Greg Rice <[log in to unmask]>
Date:
Wed, 9 Oct 1996 11:10:43 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (29 lines)
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

ATOM RSS1 RSS2