ifitsx wrote:

> Ann, I don't know what I could be doing that I'm not telling you.
>
> Here is the source for my table:
>
> CREATE TABLE DBNOTES (
> NOTEID INTEGER NOT NULL
> , FOLDERID INTEGER NOT NULL
> , SUBJECT VARCHAR( 120 )
> , AUTHOR VARCHAR( 120 )
> , KEYWORDS VARCHAR( 80 )
> , NOTES BLOB( 65535, 1 )
> , CREATEDATESTMP DATE
> , CREATETIMESTMP TIME
> , EDITDATESTMP DATE
> , EDITTIMESTMP TIME
> , CONSTRAINT INTEG_2
> PRIMARY KEY ( NOTEID )
> )
>
> I'm simply trying to see if there are any duplicates for the field
> <subject>
>

The error you are seeing is due to something else, as Ann says. Are you
perhaps running this query inside a procedure of the database without
using the FOR SELECT syntax? Show your code that you are actually using
to run this query.

Woody (TMW)