Need help with views, updating underlying tables and lateral views 1

[foxrainer]

Using two tables, 'patient' and 'visits' I created views, two examples:
'view_return1' using PATIENT only, and
'view_patient_visit' using PATIENT and VISITS

PATIENT and VISITS are in the DataEnvironment of a form with NO buffer. Both views are addid with Optimistic Row buffering.

view_return1 is used to populate a grid (using ALIAS as sourceType).

When I make changes to the ReturnDAte in the grid, how do I update the undelying table and other views without changing the record ointer?

I tried Tableupdate, refresh and requery but seem to be lacking the basic principle in theory. None of the texts appear to make it easy to understand.

Any help would be appreciated,

Thank you

Rainer

 

[Mike Gagnon]

I tried Tableupdate, refresh and requery but seem to be lacking the basic principle in theory.

[ul square]
[li] Is your view set with the update criteria?[/li]
[li] You can use Tableupdate to save the changes to the current record only:
TABLEUPDATE([nRows [, lForce]] [, cTableAlias | nWorkArea]
[, cErrorArray])
Specifies which changes made to the table or cursor are committed. If nRows is 0 (or .F.) and row or table buffering is enabled, only changes made to the current record in the table or cursor are committed. [/li][/ul]

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.