Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement