Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting records
Message
From
06/04/2000 13:37:15
 
 
To
06/04/2000 13:23:09
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00356388
Message ID:
00356394
Views:
15
>I use buffered (optimistic table buffering). When a record is deleted, need I issue the following?
>
>begin trans
>tableupdate(.t.)
>end transaction.
>
>I sometimes get "Someone else is using the record...." error message when I know I'm the only user. Other times the record is not deleted at all.
>

You need a TableUpdate(), but you shouldn't need to wrap a transaction around it. If you have RI rules that force other records to be deleted with it, the RI code should include the necessary transactions. So try it with just TableUpdate(.t.).

Tamar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform