General information
Category:
Coding, syntax & commands
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only