General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Totaling Records without adding in deleted records?
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only