>Well, what I have is a form with pageframes (about 10 pages). Most of the fields are linked to a view called lv_vw_tbl. I also have some grids linked to lv_sp_tbl and lv_rp_tbl views. Then I also have two listboxes. One displays information from lv_aka_tbl view and the other one is lv_ccn_tbl view that we have been talking about. What my problem is that when I do requery(), I can see the updated value in listbox (for lv_ccn_tbl) immediately. If I do
>requery('lv_ccn_tbl') then I don't see the updated value unless I exit the form and come back in. As you said (since I have other listboxes and grids that are linked to other view) when I issue requery() will it look at the current alias (such as lv_ccn_tbl since I issued tableupdate on it prior to requerying) or will it try to requery all of my views?
>
>Thanks
>Nick Patel
Nick,
It requeries the current alias() only. However issuing tableupdate() to lv_ccn_tbl prior to it doesn't make lv_ccn_tbl the current alias. IOW in your code there was no clue what the current alias() is. Put a 'wait window alias()' there to check.
Cetin