>Will the view use the A that is already opened to do its query and thus move the pointer on A causing my unsaved data to be save (as moving off the record in row buffering does a tableupdate automatically) or will the view not disturb my already opened A?
Your answer is no. Internally, VFP uses the select statement that defines the view to build your cursor, and SQL SELECT does
not move the cursor in the tables it selects from.
Erik Moore
Clientelligence