Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can I evaluate if a database is empty
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00107610
Message ID:
00109049
Views:
71
>>>When filtering, reccount() will always return the true record count while ignoring the filter. Might I suggest an sql into a cursor and then an _tally to verify that you have one record.
>>
>>Why not just use COUNT? Set the filter and COUNT. A rushmore optimized count is FAST.
>
>How's this for speed...
>
>LOCATE FOR .T.
>IF EOF()
>*...table is empty
>ENDIF

Would it be all that much faster than a count? I am not too sure.
Menachem Bazian, CPA
President
BC Consulting Services, Inc.
973-773-7276
Menachem@BazianCentral.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform