General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only