Delete 5000 Records in Database with 80000 Records

Forum for DBF Commander discussing.

Delete 5000 Records in Database with 80000 Records

Postby Roy » Tue Oct 06, 2015 11:13 am

Hello,

i will delete 5000 Records in a Database with ober 80000 Records with DBF Commander Professional.
I can selelct the Records for deleting with two filters and DBF-C will show me only these Records. My
Problem is, i cannot select all 5000 Records for deleting in one time.

Can you tell me what i must doing?

Regards
Roy
Roy
 
Posts: 1
Joined: Tue Oct 06, 2015 11:06 am

Re: Delete 5000 Records in Database with 80000 Records

Postby Admin » Tue Oct 06, 2015 11:21 am

Hello Roy,
the best way is to use DELETE SQL statement. E.g.:
Code: Select all
DELETE FROM table1 WHERE RECNO()<=5000

would mark as deleted first 5000 records.

Do not forget to execute PACK command after deleting to remove marked records completely.
Best regards,
Oleg Zhechkov
User avatar
Admin
Site Admin
 
Posts: 113
Joined: Wed Apr 21, 2010 7:27 pm


Return to DBF Commander Professional

Who is online

Users browsing this forum: No registered users and 1 guest

cron