Hi Chris,

we had this discussen I believe on UT a few weeks ago and you are right with your solution. When you only do a requery I believe that Jasons way is the faster one, but when you want to work e.g. save data ... with the other view you should go the way you mentioned.

Marcus

>What I am currently doing is adding a method (ex. LoadAllCompanies) with code like this:
>
>LOCAL lcCurrentAlias
>
>lcCurrentAlias = THIS.GetAlias()
>
>THIS.SetAlias( "v_Companies" )
>THIS.Requery()
>THIS.SetAlias( lcCurrentAlias )
>
>RETURN RECCOUNT( "v_Companies" )