General information
Category:
Coding, syntax & commands
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