General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Bob,
Thanks for your reply and I've tried it and it works fine !!
Regards,
Gerard
>>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
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