"If Eof THEN ShowMessage('There were no records selected for
this criteria.')"

should be better - not primarily for those cases where the RecordCount is
0, but if there's plenty of matches IB could take quite some time counting
them all.

I think Eof works better if you do a first than if you do an open on your
query/cursor (just some vague memories).

Set

At 14:24 29.11.2000 -0000, you wrote:

>Hi all,
>
>After reading all the posts about the badness of "RecordCount" I
>checked my code and found that I also am using it numerous times. I
>am not using it in a loop though. Basically what my code does is "If
>RecordCount = 0 THEN ShowMessage('There were no records selected for
>this criteria.'), whatever the Query criteria was.
>
>Does anyone know of a better way to accomplish this? Or am I still
>safe in using this methodology?
>
>TIA,
>
>Gerald S. Brown
>
>
>
>
>
>