Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Theory of lost data
Message
From
19/08/1999 05:55:50
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00254303
Message ID:
00255171
Views:
25
>>One thing to try is to open the table Again (in a different session, maybe), replace, update, replace back (maybe just toggle one logical somewhere) and close it in this other alias. That should refresh its disk image, right?
>
>That's an idea. Right after a Tableupdate, maybe just code something like this could send a server update:


I thought of something more brutal - replacing field with itself may not do, so if what you propose doesn't flush it, I'd suggest harder measures:

>=CURSORSETPROP('Buffering',1,'real_one')
>USE real_one AGAIN IN 0 ALIAS temp EXCL
REPLACE numericfield1 with -numericfield1 IN temp
Flush
REPLACE numericfield1 with -numericfield1 IN temp
>USE IN temp
>=CURSORSETPROP('Buffering',5,'real_one')

Or even with buffering of Temp, and forcing a TableUpdate() after each replace...
So, what were the results of testing this (short of extending the mercy of euthanasy to the server)?

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform