Paradox: Lost Data?

Paradox: Lost Data?

We’re concluding development of a Delphi 1.0 to 2.0 app and have found during user testing that after an app except, when the app terminates, all data entered has been lost.

The app consists of a main form with a number of db comps on, and each form’s tables are linked to these db comps.

When a table is opened, is the data kept in memory until closing, despite posts? Where are posts written to? If they are written to the inmem table, can we periodically ‘commit’ data to the ‘real’ db? Is there anything else thatcould cause this problem?

Little known is the fact that buffering is going on in the BDE when a table is being edited. So yeah, you’ll lose data if the records haven’tbeen committed. To ensure minimal data loss (i.e. only the record currentlybeing worked on), you should follow each post with the following BDE call:

DBISaveChanges(Table1.Handle); //or whatever your table is named.
This will force the BDE to write the data in memory to disk.

Share the Post:
Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular

XDR solutions

The Benefits of Using XDR Solutions

Cybercriminals constantly adapt their strategies, developing newer, more powerful, and intelligent ways to attack your network. Since security professionals must innovate as well, more conventional endpoint detection solutions have evolved

AI is revolutionizing fraud detection

How AI is Revolutionizing Fraud Detection

Artificial intelligence – commonly known as AI – means a form of technology with multiple uses. As a result, it has become extremely valuable to a number of businesses across

AI innovation

Companies Leading AI Innovation in 2023

Artificial intelligence (AI) has been transforming industries and revolutionizing business operations. AI’s potential to enhance efficiency and productivity has become crucial to many businesses. As we move into 2023, several