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:
Reply To:
Date:
Thu, 10 Oct 1996 09:36:30 -0400
Content-Type:
text/plain
Parts/Attachments:
Sql (34 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
>

As a workaround you could try
WHERE DATABASE.TABLE.COLUMN >= 'QT' AND DATABASE.TABLE.COLUMN <= 'QT';

ATOM RSS1 RSS2