General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Problem with buffering / tablerevert() / getfldstate()
i have some odd problem using tablerevert(), here is what's happening...
my app has a view
i have table buffering on
i edit the view through a grid on a form
the form is closed by a button on a toolbar
when the form is closed, i detect changes and prompt to save
i detect changes using the interactivechange event on the control in the grid cell rather than than getfldstate()
based on the response, i use tableupdate() or tablerevert()
the case giving problems is not saving changes, which issues the tablerevert()
the next time i want to use the same view, i get an error saying the view has uncommitted changes
i have narrowed it down to this......
if i make the change to the grid cell and then give some other grid cell or form object the focus, i detect the change because the interactivechange event fired and getfldstate() detects the change
when i leave the cursor in the grid cell after making the changes and close the form, i detect the change because the interactivechange event fired, prompt to save and use tablerevert(). getfldstate() does not detect the changes right away. after i hide the form and the toolbar, getfldstate() will detect the changes.
the odd thing is that i put in 5 consecutive calls to getfldstate() and the changes are detected on calls 2 thru 5.
thank you for any assistance,
pbd
Next
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