>>anyway another way is to use parameterized views - they don't close when u requery (as I said all this can be found in the VFUG tips)
>
>One excellent improvement in VFP 5 (vs 3.0... at least I think that 3.0 didn't have it) is the ability to include expressions in what is selected for the view within the View Designer. This substantially increases the usefulness of parameterized views. It used to be that you could only use expressions by programmatically issuing the Create View command.

Mark,
what I usually do is start with the designer and then move to code anyway (this way I always have more power and I can optimize my SQL
better) this is true for views and regular SELECTs

Arnon