Thanks. I think I read somewhere in the docs of version 6 NOT to save data in anything other than your primary data access object, but I have been cheating :-).
>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" )
Chris McCandless
Red Sky Software