Here is a sample of using a parametized view

create sql view myview as select * from cities where country=?parCountry
**** then drop this view in the dataenvironment of your form
**** and set it's NoDataOnLoad property to TRUE
**** then, every time you want to fill in the data for some country ,
*** you can do:
parCountry = "Netherlands"
ReQuery('myview')
*** here refresh your grid or controls for the view

HTH
Jaime

>I new that one :-)
>
>I guess there is some truth in an old dutch expression:
>"Waar je mee omgaat wordt je mee besmet"
>
>Loosly translated:
>"You get infected with what you come into contact"
>
>In my case; bad programming habbits.
>I'm fairly new in foxpro, as you might have guessed, but my collegue who is fairly old in foxpro, regretably is still stuck in some very old habits and ideas about programmning.
>
>So you'll problably find me here a lot, trying to find the do's and don'ts about foxpro
>
>I also have a question views and workspaces
>I run into problems with that when i want to use parameterized views.
>It is my understanding that I can only use a parameterized view like this:
>cMyparam = 'name'
>use myview in o
>
>Can I select myview and force it use a new parameter???
>
>Otherwise I have to use a "use myview in 0 again" wich gives an error
>
>Many thanks.
>Victor