Information générale
Catégorie:
Codage, syntaxe et commandes
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.
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