Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Hi Sandi, I do this all the time so it must be something else.
>
>Cheers,
>
>Andrew
>
>>I did that and it doesnt help. Has anyone ever built a parameterized view where the parameter is a date, and got it to work?? Maybe that is where my original problem lies.
>>
>>Sandi
I was afraid of that! WHen you set up the parameter in the view, do you
SELECT actdate from blahblah WHERE actdate <=?Thisform.TheDate or
SELECT actdate from blahblah WHERE actdate <=?TheDate
When you set the date in the form do you, set it in the Form.Init like
TheDate=date() or
THISFORM.TheDate = date()
or somewhere or somehow else?
Thanks for your help
Sandi
Précédent
Suivant
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