Help! Paradox Database records LOST when PC reset

M. Sebares

Delphi Developer

Tue, 26 Jun 2001 03:00:00 GMT

Help! Paradox Database records LOST when PC reset

Hi all

I have found a very big problem with a D4 application using Paradox tables.
The program runs 24 hours every day, and the client seldom closes it.
Last Week the computer restarted suddenly, due to a brief power
interruption, and after Win98 Startup and after executing the program, the
client found they have lost several days of data!!!

I have reproduced the sequence, introducing several records and I have
pressed the PC reset button while the program was idle (to avoid file
corruption). Know what? The records recently introduced were lost. I checked
if the records were in the paradox table with DbExplorer (without closing
the program), and they were ok.

Could someone give me some hint on who is deleting this records from the
table? As you can imagine, my client is slightly upset, so am I.

Thanks in advance for any help given.
M.Sebares

I.S

Delphi Developer

Tue, 26 Jun 2001 03:00:00 GMT

Re:Help! Paradox Database records LOST when PC reset

The Data wasn't written to the Database, that's why you lost all the data, even
though you posted the info, it wasn't written. This happnes, if you closed the
program beforem it would have been written to the database the reason being, I
forgot where, but there's a switch in the BDE that baiscly means that when you
post the Data it automatically get's written to the Database, instead of it
being stored in MEM.....

I hope that helped, i'll try to find out which option, try to set local share
to true.

I.S

Quote

M. Sebares wrote:
> Hi all

> I have found a very big problem with a D4 application using Paradox tables.
> The program runs 24 hours every day, and the client seldom closes it.
> Last Week the computer restarted suddenly, due to a brief power
> interruption, and after Win98 Startup and after executing the program, the
> client found they have lost several days of data!!!

> I have reproduced the sequence, introducing several records and I have
> pressed the PC reset button while the program was idle (to avoid file
> corruption). Know what? The records recently introduced were lost. I checked
> if the records were in the paradox table with DbExplorer (without closing
> the program), and they were ok.

> Could someone give me some hint on who is deleting this records from the
> table? As you can imagine, my client is slightly upset, so am I.

> Thanks in advance for any help given.
> M.Sebares

Andrew Shin

Delphi Developer

Tue, 26 Jun 2001 03:00:00 GMT

Re:Help! Paradox Database records LOST when PC reset

You can avoid this problem by setting LocalShare=True in the BDE Admin
program. This can also be done by code.

Quote

M. Sebares wrote in message <775rgb$ht...@forums.borland.com>...
>Hi all

>I have found a very big problem with a D4 application using Paradox tables.
>The program runs 24 hours every day, and the client seldom closes it.
>Last Week the computer restarted suddenly, due to a brief power
>interruption, and after Win98 Startup and after executing the program, the
>client found they have lost several days of data!!!

>I have reproduced the sequence, introducing several records and I have
>pressed the PC reset button while the program was idle (to avoid file
>corruption). Know what? The records recently introduced were lost. I
checked
>if the records were in the paradox table with DbExplorer (without closing
>the program), and they were ok.

>Could someone give me some hint on who is deleting this records from the
>table? As you can imagine, my client is slightly upset, so am I.

>Thanks in advance for any help given.
>M.Sebares

Markku Nevalaine

Delphi Developer

Tue, 26 Jun 2001 03:00:00 GMT

Re:Help! Paradox Database records LOST when PC reset

Quote

M. Sebares wrote:

> Hi all

> I have reproduced the sequence, introducing several records and I have
> pressed the PC reset button while the program was idle (to avoid file
> corruption). Know what? The records recently introduced were lost. I checked
> if the records were in the paradox table with DbExplorer (without closing
> the program), and they were ok.

You didn't mention, but I quess this was not a multiuser network app?

If it _is_ network app, and you can see the new data also from the other
workstations, and it still vanishes after power down, then there really
is a big problem. That would mean BDE some way tampers the good data
that was already written on the server's hard disk.

To empty your caches to disk, first try turning LocalShare=True, so it
will flush the BDE buffer to disk as soon as possible. And if it was
a multi user app, check very carefully the NetFileDir -settings.

Markku Nevalainen

Ed Gille

Delphi Developer

Tue, 26 Jun 2001 03:00:00 GMT

Re:Help! Paradox Database records LOST when PC reset

I believe you need to call DbiSavechanges after each record is added and
saved by the program.

There are other posts listed in this newsgroup that detail the full story.

Team

Delphi Developer

Tue, 26 Jun 2001 03:00:00 GMT

Re:Help! Paradox Database records LOST when PC reset

Set Local Share to True in the BDE Administrator to prevent the BDE from
caching writes.

Bill

--
Bill Todd
(Sorry but TeamB cannot answer questions received via email)
(Remove nospam from my email address to contact me for any other reason)

M. Sebare

Delphi Developer

Wed, 27 Jun 2001 03:00:00 GMT

Re:Help! Paradox Database records LOST when PC reset

Hi Bill, could you tell me how to set Local Share to True by code? I do not
find any clue in Delphi Help system.

Thanks.

Bill Todd (TeamB) escribi en mensaje <776fe4$ic...@forums.borland.com>...

Quote

>Set Local Share to True in the BDE Administrator to prevent the BDE from
>caching writes.

>Bill

Team

Delphi Developer

Wed, 27 Jun 2001 03:00:00 GMT

Re:Help! Paradox Database records LOST when PC reset

See the examples for DbiOpenCfgInfoList at
www.inprise.com/devsupport/bde/bdeapiex.

Bill

--
Bill Todd
(Sorry but TeamB cannot answer questions received via email)
(Remove nospam from my email address to contact me for any other reason)

Jeannine Menge

Delphi Developer

Mon, 02 Jul 2001 03:00:00 GMT

Re:Help! Paradox Database records LOST when PC reset

I may have missed something? Why don't you go to the BDE administrator,
Configuration tab, System INIT then set False to True for Local Share.
What reason do you have for doing this in code? (pardon my ignorance
here)

Jeannine Menger
PC Synergy

Quote

M. Sebares wrote:

> Hi Bill, could you tell me how to set Local Share to True by code? I do not
> find any clue in Delphi Help system.

> Thanks.

> Bill Todd (TeamB) escribi en mensaje <776fe4$ic...@forums.borland.com>...
> >Set Local Share to True in the BDE Administrator to prevent the BDE from
> >caching writes.

> >Bill

Other Threads

1. Paradox Database records LOST when PC reset

2. Help Database: Lost records in Paradox table with no reason

3. Reset record counter on Paradox tables?

4. Help! - Blocking records in local network Paradox databases

5. Lost records with Delphi and Paradox!

6. Database PC-Anywhere and Paradox

7. Losing blocks of records from linked Paradox table??!

8. Lost records (BDE/Paradox)

9. Paradox application : losing records.

10. Mixing and losing records in Paradox Tables on a Client/server application