Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Totaling Records without adding in deleted records?
Message
From
08/06/1999 11:14:13
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Totaling Records without adding in deleted records?
Miscellaneous
Thread ID:
00227450
Message ID:
00227450
Views:
95
Does any one know what the best way is to finding the total number of records in a table without adding in the records marked for deletion?
I have set deleted on.
The way I am currently doing it is by doing a select statment on the table and then doing a _tally command. It works but it seems like there should be a easier way.

example: Select * from Table1 into cursor Test
lnTally = _tally

Thanks,
Next
Reply
Map
View

Click here to load this message in the networking platform