Board index » delphi » Record count excluding deleted records

John Donaldson

Delphi Developer
Sun, 12 Sep 2004 02:47:40 GMT

Record count excluding deleted records

How can I get a record count excluding deleted records without packing the
table Using Delphi 4 and dBase tables?

Thanks for any assistance,
John Donaldson
Florida Department of Revenue

 
Bill

Delphi Developer
Sun, 12 Sep 2004 03:29:08 GMT

Re:Record count excluding deleted records


Quote
"John Donaldson" <johnb...@nettally.com> wrote in message

news:3ca0c1b6_1@dnews...
Quote
> How can I get a record count excluding deleted records without packing the
> table Using Delphi 4 and dBase tables?

SELECT
    COUNT(*)
FROM
    Your_table_Name.DBf

Other Threads

1. Delphi 4 + Native Ms Access 97 driver + Filtered dataset + record count/record number

2. How to get Record Count of a Detail Record in DBGrid

3. adding/deleting records from array of records in .dat file

4. Delete a record in a TDBGrid with the Delete Key (and not Ctrl-Delete)

5. Deleting Records from a record set.

6. can't delete a master record and its details records

7. Query and Duplicate Records Exclude

8. Query and Duplicate Record Exclude

9. Query and Duplicate Record Exclude

10. DBASE: permanently deleting deleted records