Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ComboBox ControlSource Question
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00355021
Message ID:
00355144
Views:
18
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.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform