>>how is an efficient way to tell if a table has no active records.
>>
>>thanks, brenda
>
>You have gotten so good answers, but I think I would just
>Select mytable
>locate
>if eof()
> Records here
>else
> empty or all deleted
>endif
>
>
>HTH
>Jeff
OH NO I messed up !!
Should be
if !eof()
Records here
else
empty or all deleted
endif
Sorry
Jeff
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com