General information
Category:
Coding, syntax & commands
Hi Nick,
So I am not going to use the ControlSource in this case right ?
Thanks
Veronica
>So, assuming that you are positioned on the right record in your target view
>the combo.Valid should look like:
>
>REPLACE mytargetview.mydatefield WITH CTOD(this.value) IN mytargetview
>
>
>>Hi All,
>>
>>In this case it is a local view(the combo list), and I would like to bind
>>it into a different view.
>>
>>Thanks
>>
>>Veronica
>>
>>>>>How do you ControlSource a date field. I am getting
>>>>>data type is mismatch.
>>>>>
>>>>>Thanks
>>>>>
>>>>>Veronica
>>>>
>>>>Veronica, combo and listbox support only character or numeric data types as controlsource. But you may not use the contolsource property, say you have combo.RowSourceType 3 -SQL Statement and RowSource is:
>>>>
>>>>select dtoc(birth_date) from employee into cursor cdate
>>>>
>>>>Then in combo.Valid you have:
>>>>
>>>>REPLACE sometable.somedate WITH CTOD(this.value)
>>>>
>>>
>>>You may also fill the combobox with DATE data type, but combo.value will be character anyways.
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