Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is the VFP File System Stable
Message
From
19/10/2001 18:39:02
Calvin Smith
Wayne Reaves Computer Systems
Macon, Georgia, United States
 
 
To
19/10/2001 15:44:06
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00571072
Message ID:
00571193
Views:
23
Craig,
I will be glad to post my PK code if you will (forgive my ignorance) tell me what you mean by PK. I think you mean the transaction code I use to post with. It is in the form:( I do not have the code at hand but I believe this is accurate)
begin transaction
select table
lsuccess=tableupdate(.t.,.t.)
if lsuccess
select table
lsuccess=tableupdate(.t.,.t.)
...
if lsuccess
endtrans
else
rollback
tell user something bad happened.
endif
I am almost certain that this succeeds, but that at some point the record count in one or more tables is corrupt so that the next time through some previous records get overwritten.

As far as the primary key problem is concerned I have no idea what is happening. When I examine users error logs I do not see anything that would cause this. I remember that when I first started working with VFP I was able form time to time to screw up a primary key but it was always after a long series of errors usually terminated by several CtrlAltdeletes.
Any suggestions would be most helpful.

Thanks.
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform