ChrisBerry
asked on
Lost Records in Paradox 7
Hi there,
What is going on? I am using Delphi 3.02 and Paradox 7 tables.
I append a record to a table and post it, it seems OK. I can append records to my hearts content, filter them, look at them and all seems OK.
I then exit the program and go back in and all the records I have added have gone. I have a table with fields I use to get values for calculating primary keys and all these values have been reset to their original value.
It looks as though I am using a set of temporary tables that vanish when I exit the program.
I am not using cashed updates nor am I using transactions ( that I know of), so what is going on?
Thanks
Chris
What is going on? I am using Delphi 3.02 and Paradox 7 tables.
I append a record to a table and post it, it seems OK. I can append records to my hearts content, filter them, look at them and all seems OK.
I then exit the program and go back in and all the records I have added have gone. I have a table with fields I use to get values for calculating primary keys and all these values have been reset to their original value.
It looks as though I am using a set of temporary tables that vanish when I exit the program.
I am not using cashed updates nor am I using transactions ( that I know of), so what is going on?
Thanks
Chris
ASKER
I have experienced just what you say but I would like an answer if possible. I would like to reopen the question for now to see if I can get a full answer to the problem, if I don't I will credit you later.
Thanks for the reply.
Thanks for the reply.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks, now I know too ...
ASKER
Thanks, this has really been bugging me and others I know. Seem s sort of fundamental and should be documented somewhere.
Chris
Chris
When I started working with Delphi I experienced the same problem. I found that sometimes that happens when I execute my program from within Delphi (For debugging purposes or for a test run). Some of my update and inserts just got lost.
When you run the program you have written from the EXE without having Delphi open it doesn't do that. I suppose it is a bug somewhere in Delphi.
Try that and let me know. If it still doesn't work feel free to discard this answer and we can look at the problem some more.