General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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,
another method:
Select count(*) from Table1 into array laCount
or
Select count(*) from Table1 where !deleted() into array laCount
Previous
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