> > 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)

I'm running them (pasting exactly, and they prepare ok) in the IBO_SQL
"Execute Statement in Database" - DSQL dialog, which I have used on
occasion for what seem to be simple ;) tasks outside of something I
need in an app. Perhaps I should post this in the IBO group.