>Hi.
>I have in my DBC set up a parameterised view with a variable as follows:
> ?lnMyVar = Myfield_PK (in the filter section)
>
>I then want to requery the view on a form and I do the following:
> Select MyView
> lnMyVar= MyAlias.MYPK
> Requery()
> Thisform.refresh()
>
>Now this all works fine , but the only way I can get it to work is if I declare lnMyVar as a Public Variable. (Otherwise the minute the form is run, it comes up with a message asking me for a value to put into lnMyVar)
>
>Is there a better way of handling this, without haviong to declare the variable as public ?
>
>Regards,
>
>Gerard

You want to set the cursor to USE the view with NODATAONLOAD. If you are using the DE and Cursor class set the NODATAONLOAD property of the cursor to .t.. This way the view parameter won't need to exist until you do your requery code above.

BOb