Link to home
Start Free TrialLog in
Avatar of Gladys522
Gladys522

asked on

dBase record count

Hi,

I've copied some tables from dbase to oracle and I am trying to validate the tables.  There are some deleted rows in dbase that show up so I "set deleted on".  This shows all the non-deleted rows in the table, however the record count doesn't change.  Is there a command that counts the non-deleted rows in dbase?  I've tried ? reccount() and ? recno(), but it includes all records.

Regards,
Gladys
Avatar of CarlWarner
CarlWarner
Flag of United States of America image

COUNT FOR DELETED()
ASKER CERTIFIED SOLUTION
Avatar of CarlWarner
CarlWarner
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Gladys522
Gladys522

ASKER

Thanks Carl for your help.
You're welcome.