Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View not updating data
Message
From
09/08/2006 23:29:34
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01143996
Message ID:
01144402
Views:
17
"You probably have double buffering then. Where and how do you set buffering and how do you do tableupdate? Also it may help to do flush. Did you try to commit your changes, exit the form, wait a bit, then re-try?"

Hi Naomi,

Here is my code in the afterrowcolchange of the form.Could you tell me how to do a flush? I have tried everything, Naomi, not just what you asked me above..Don't know where and when something's gone wrong, but it certainly does not seem simple...at least in my case!
SELECT vuepkg
TABLEUPDATE(.T.)
SELECT pkg
TABLEUPDATE(.t.)
<pre>

And the code from the view:
<pre>
DBSetProp(ThisView,"View","SendUpdates",.F.)
DBSetProp(ThisView,"View","BatchUpdateCount",1)
DBSetProp(ThisView,"View","CompareMemo",.T.)
DBSetProp(ThisView,"View","FetchAsNeeded",.T.)
DBSetProp(ThisView,"View","FetchMemo",.T.)
DBSetProp(ThisView,"View","FetchSize",100)
DBSetProp(ThisView,"View","MaxRecords",-1)
DBSetProp(ThisView,"View","Prepared",.F.)
DBSetProp(ThisView,"View","UpdateType",1)
DBSetProp(ThisView,"View","UseMemoSize",255)
DBSetProp(ThisView,"View","WhereType",3)
However, this behavior is now on a standalone view also, not just in the form.In fact, I cannot exit VFP, because of the error "Update Conflict" !!!!

With best regards,

Steve
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform