Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A nightmare with table buffering
Message
From
09/10/2003 12:38:43
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00836796
Message ID:
00837001
Views:
27
>Zoran,
>
>Sorry to be so slow in getting this but I've used optimistic table buffering on a cursor in a database to allow users to edit a grid control and commit the changes using an edit off button which then does a tableupdate.
>
>If two people change the same records then that's not very likely so not an issue. I thought that Foxpro would allow me to commit the buffered records only automatically by issueing the command TABLEUPDATE(1,.T.,.table_main)?
>
>Are you saying I have to tell foxpro which updates to peform one by one by specifying the unique key value?

No, but you have to specify the correct field.

Actually, I was assuming you were working with views, since this is a potential problem with views.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform