You can recreate the view with CREATE SQL VIEW. I put all the paraemters into the view definition to begin with then supply default values when the user doesn't fill them in.
>Is there a way to dynamically change the number of parameters passed to a view in VFP at the time of requery?
>(like building the where clause at run time)
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer