ANY METHOD TO KNOW FIELD THAT HAS ERROR ?

Business Central/NAV User Forum
1

HI ALL

I TRY TO BACKUP DATABASE BUT SOME TABLES HAVE ERROR SO I CAN NOT BACKUP

I TRY TO DELETE DATA INSIDE TABLES CONTAINING ERROR BUT SOME TABLES CAN NOT DELETED

I NEED HELP TO HOW I CAN DELETE ALL DATA INSIDE ANY TABLES OR DATABASE

2

Please stop using all caps, it looks like you are screaming at us.

3

Instead of looping through records, try to use command reYourTable.DETETEALL(FALSE); with this NAV deletes all data (within filters, if applied) in one operation.
You may also try to delete data via table Object, field ObjectType = ObjectType::TableData.

But mind: when theese commands are fired, there is no way back! No un-delete is avaliable at all!!

Except your backups, of course!