Woody,

Thanks for your reply.

> The having clause is only used for aggregate queries which contain,
> among other things, counts, sums, etc. Change your query to include

the

> count(*) and also change the group by to include all non-aggregate

fields:

>
> select noteid, folderid, subject, count(*)
> from dbnotes
> group by noteid, folderid, subject
> having count(*) > 1

The above script prepares ok, but returns the following error:

ISC ERROR CODE:335544374

ISC ERROR MESSAGE:
attempt to fetch past the last record in a record stream