Opening DBF file - deleted records included, field formats ignored

Post Reply
nicholassmall
Posts: 36
Joined: Fri Dec 02, 2016 12:14 am

Opening DBF file - deleted records included, field formats ignored

Post by nicholassmall »

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.
Attachments
TestDBF.dbf
(317 Bytes) Downloaded 94 times
miguel-c
SoftMaker Team
SoftMaker Team
Posts: 1233
Joined: Wed Jun 05, 2019 12:02 pm

Re: Opening DBF file - deleted records included, field formats ignored

Post by miguel-c »

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.
nicholassmall
Posts: 36
Joined: Fri Dec 02, 2016 12:14 am

Re: Opening DBF file - deleted records included, field formats ignored

Post by nicholassmall »

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.
miguel-c
SoftMaker Team
SoftMaker Team
Posts: 1233
Joined: Wed Jun 05, 2019 12:02 pm

Re: Opening DBF file - deleted records included, field formats ignored

Post by miguel-c »

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’
miguel-c
SoftMaker Team
SoftMaker Team
Posts: 1233
Joined: Wed Jun 05, 2019 12:02 pm

Re: Opening DBF file - deleted records included, field formats ignored

Post by miguel-c »

The DBF file deleted records will no longer be shown in PlanMaker in the next service pack.
Post Reply

Return to “PlanMaker NX and 2024 for Windows”