View's update Problem

[Nro]

Hi!
I have some problem to update data with Views and multiple tables opened.

1 - I have one view based on the customer Address (custAdd.DBF).
The view is updatable (cursorsetprop(...)). We assume that the file custAdd and the view (custAddView) are opened in the same datasession (1). If I append one rec. into the view and issue a tableupdate, the record appear in the table also.I Works fine.

2 - Now, I open an other form with custAdd.dbf with a different alias (custAddSf) in a different datasession (2).

If I go back to my first form (datasession 1) and try to append the new Rec. in the View, issue a tableupdate, the record does not appear in the table custAdd of datasession 1 and 2. I have to close everything and go back to see it.

I'm using VFP 7.0 with Win 2000 server.

Thanks

Nro

 

[gogita]

Hi

I think when you go back to the first form you should requery view "custAddView". You should write this code in
the method "Activate" of the form.

requery("custAddView&quot