Here is a sample of using a parametized view
create sql view myview as select * from cities where country=?parCountry
parCountry = "Netherlands"
ReQuery('myview')
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
Why do programs stop working correctly as soon as you leave the Fox?