General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I opened the view as no data on load and in the DE BeforeOpenTables I set THISFORM.Enddate = date(). It still does it!!!!!! What gives??????
Sandi
>Either way. (BTW, for the second option I'd always use ?m.TheDate to avoid possible conflicts with a field name in the current work area.)
>
>If I were using the ThisForm option, I'd open the view NODATA in the load (or the DE), set the date in the init with thisform.TheDate = date() and then do a requery(), again in the init
>
>If I were using the memory variable option, I'd open the view NODATA in the load (or the DE), set the date in the init with local TheDate, TheDate = date() and then do a requery(), again in the init
>
>Cheers,
>
>Andrew
>
>>
>>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
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