When a DBF file is opened, deleted records are loaded as if they are ordinary records, which should not happen.
It would also be helpful if the field formats stored in the DBF file were taken more into consideration, so that integers are loaded as integers.
Opening DBF file - deleted records included, field formats ignored
-
- Posts: 37
- Joined: Fri Dec 02, 2016 12:14 am
Opening DBF file - deleted records included, field formats ignored
- Attachments
-
- TestDBF.dbf
- (317 Bytes) Downloaded 413 times
Re: Opening DBF file - deleted records included, field formats ignored
When you delete a record in TextMaker, it doesn't delete it. It just hides it, so you can restore it later.
If you really want to delete it, go to TextMaker | Mailings | Edit database | Delete | Purge Database
Regarding the integers, I'll report it to the developers.
If you really want to delete it, go to TextMaker | Mailings | Edit database | Delete | Purge Database
Regarding the integers, I'll report it to the developers.
-
- Posts: 37
- Joined: Fri Dec 02, 2016 12:14 am
Re: Opening DBF file - deleted records included, field formats ignored
What you say is true, but misses the point. There is no indication in PlanMaker that they are deleted records.
If the file is opened in Libre Office or Excel then the deleted records are excluded.
If the file is opened in Libre Office or Excel then the deleted records are excluded.
Re: Opening DBF file - deleted records included, field formats ignored
1. I'll mention the info you just told me about excel and libre
2. Workaround for integers until we fix it: right-click on column A in the preview and choose ‘Standard’
2. Workaround for integers until we fix it: right-click on column A in the preview and choose ‘Standard’
Re: Opening DBF file - deleted records included, field formats ignored
The DBF file deleted records will no longer be shown in PlanMaker in the next service pack.