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
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
COUNT FOR DELETED()
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Carl for your help.
You're welcome.