Board index » delphi » Help, I'm loosing Paradox-records after a computer-crash

j...@pi.net (Silvia Janssen)

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Help, I'm loosing Paradox-records after a computer-crash

I'm currently writing a database-application in Delphi 3 for Windows 95.
I'm using Paradox-tables.

When the computer crashes, I loose all the records that have been added
since the computer was started, even if the tables were properly closed.

This is bad enough, but since this application logs machine-data, which
can never be recovered, and since the computer might be on for weeks on
end, I would really like to know how to prevent this.

Thank you very much inadvance for any reply,

Silvia Janssen
j...@wxs.nl

 
Earl F. Glyn

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Help, I'm loosing Paradox-records after a computer-crash


Quote
Silvia Janssen wrote in message <34c9c497.7653...@news.pi.net>...
>I'm currently writing a database-application in Delphi 3 for Windows 95.
>I'm using Paradox-tables.

>When the computer crashes, I loose all the records that have been added
>since the computer was started, even if the tables were properly closed.

>This is bad enough, but since this application logs machine-data, which
>can never be recovered, and since the computer might be on for weeks on
>end, I would really like to know how to prevent this.

Silvia:

Take a look at Borland's TI 2953, "BDE: Writing Buffer to Disk."
You can use an Application.OnIdle event to call DbiUseIdleTime
to allow the database engine to save "dirty buffers" to disk.

efg
_________________________________________________

Earl F. Glynn          EarlGl...@WorldNet.att.net
MedTech Research Corporation
Lenexa, KS  66219  USA

Andrew Gab

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Help, I'm loosing Paradox-records after a computer-crash


Quote
Silvia Janssen wrote:
> I'm currently writing a database-application in Delphi 3 for Windows 95.
> I'm using Paradox-tables.

> When the computer crashes, I loose all the records that have been added
> since the computer was started, even if the tables were properly closed.

I don't believe this.  If the table was closed, it was committed.
Otherwise the records have not been added prior to closing.  Have you
checked that they've been added?  Have you looked at committing your
changes using DbiSaveChanges?

Andrew
--
Andrew Gabb
 email: ag...@tpgi.com.au
 phone: +61 8 8342-1021
   fax: +61 8 8269-3280
Technology Australasia's website is at http://www.taa.com.au
-----

Sundial Servic

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Help, I'm loosing Paradox-records after a computer-crash


Quote
In article <34CA76F2.C53B...@tpgi.com.au> Andrew Gabb <ag...@tpgi.com.au> writes:
>> I'm currently writing a database-application in Delphi 3 for Windows 95.
>> I'm using Paradox-tables.

>> When the computer crashes, I loose all the records that have been added
>> since the computer was started, even if the tables were properly closed.
>I don't believe this.  If the table was closed, it was committed.
>Otherwise the records have not been added prior to closing.  Have you
>checked that they've been added?  Have you looked at committing your
>changes using DbiSaveChanges?

DbiUseIdleTime?

Other Threads

1. D5-Loss of posted records if computer reset/crashes

2. BDE erases all the records when the computer crashes

3. Packing a Paradox Table looses records

4. Loosing records (D6/Paradox) :-(

5. Alpha procedure loosing records...HELP

6. Delphi 3.0 crashes on my new computer ... help :(((

7. Computer crashing on reporting (need immediate help)

8. DBE 4.0,5.01,5.1 w/ Dbase 3 .dbfs, Loosing Records or fields going empty, Help

9. Access crashes - Paradox doesn't!

10. Strange Paradox table problems: NAN's, Invalid Floating Point Operations, system crashes