Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update conflict, is THIS how to handle it????
Message
From
04/10/2004 12:19:28
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
04/10/2004 12:10:44
Joel Hokanson
Services Integration Group
Bellaire, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00948029
Message ID:
00948502
Views:
18
>Yes, that works [ =CursorSetProp('Buffering',5,'ap_wires_work_orders') ]
>and after the replace all is complete, I do a Tableupdate()
>
>but when I try to close the file or do a requery() to look at the changed data, it says Table Buffere for alias "MyView" contains uncommited changes
>
>The when I close and reopen MyView, teh data is back to the original state.

Joel,
Maybe you're doing tableupdate wrong. Be sure you do that at table level, supply alias to be sure you're updating correct table/view, check conflicts and either handle them by one one or tablerevert before requery. ie: You might do a tableupdate(), check aerror() if result is .f., use GetNextModified() for uncomitted records.. etc.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform