Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tableupdate not sticking?
Message
From
18/06/2003 15:51:22
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Tableupdate not sticking?
Miscellaneous
Thread ID:
00801414
Message ID:
00801414
Views:
39
I have a form that occasionally looses appended records (after the tableupdate). This is a multi-user app. The table is in 'table buffering mode' and I've created a big error log that seems to show events running like this:

1. Record is appended; record # is -1
2. Record is saved successfully to the util_rev table with:
TABLEUPDATE(1,.F.,'util_rev')
The above command return .T.
record # is 60467
3. This happens 4 or 5 times (4/5 records added successfully with RECNO() being increased to 60472)
4. Go to EOF
5. The last record is 60467!!! what happened to the other new records?
6. Record is appended; record # is -1
7. Record is saved successfully to the util_rev table with:
TABLEUPDATE(1,.F.,'util_rev')
The above command returns .T.
record # is 60467 AGAIN!!!

Any ideas??

thanks

bonnie
Next
Reply
Map
View

Click here to load this message in the networking platform