Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
REQUERY bringing back pre TABLEUPDATE values??
Message
From
18/09/1997 18:39:49
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00050576
Message ID:
00050626
Views:
19
Joe,

There is *another* caveat with TABLEUPDATE(2... according to the Help. I don't know if this plays here or not, but it is that the process will *NOT* stop with an error. You should, just for your own satisfaction here, specify an array as #3 param (I think it was) and see if there is any rec# recorded there after completion.

Is this ReQuery being done in the *SAME* execution of VFP, or in some other one?

Have fun,
Jim N

>Here's the scenario..
>
>I've got a view on a table...
>
>I do a CURSORSETPROP("Buffering", 3) on it...
>
>I change some values in the view
>
>I do a TABLEUPDATE(2, .T.)
>
>2 means write all records if table buffering or just the current if record buffering (says the manual)
>.T. means force the changes even if the data in the record has changed
>
>Now I can look at the view AND at the source table and BOTH are the same and reflect the NEW values.
>
>Now here's the tricky part...I am using this view to populate a grid so whenever the grid is refreshed I make sure to do a REQUERY.
>
>Now the instant I do the REQUERY I notice that my values in my view GO BACK to what they were originally!!!
>And my actual table on disk STILL has the correct, new values!
>
>
>HELP!!!!!!
>
>I've been doing this for hours, and I've finally narrowed it down to this..
>
>But this seems...impossible...
>
>Thanx
Previous
Reply
Map
View

Click here to load this message in the networking platform