Subject | Re: [IBO] Re: IB_ComboBox as parameters |
---|---|
Author | Helen Borrie |
Post date | 2006-05-11T08:17:17Z |
At 05:57 PM 11/05/2006, you wrote:
get the IB_Combobox/ParamName thing cleared up.
IB_ComboBox is a data-aware component that is bound to a field in a
dataset. Like several IBO controls, this control can be bound to a
parameter of that dataset, instead of a field.
Just as a field has to exist in the datasource dataset, in order to
have a data-aware control bound to it, so a *parameter* has to exist
in the datasource dataset, in order to have a data-aware control bound to it.
But, because *this* control is designed to allow a value to be
selected for (in this case) the parameter it is bound to, the dataset
must be in a Prepared state, with the named parameter available, to
be ready to accept a value for the parameter.
So - the two things you need here are
1) The datasource query's statement, with a WHERE clause that
contains the named parameter, e.g. ...'WHERE ID_CLASSE = :ID_CLASSE
2) The statement to be in a Prepared state
Does that help?
Helen
>Sorry I didn't express myself properly.OK. We are going around and around a number of aspects here. Let's
>
>I'm still talking about doing filtering with IB_Combos.
>What happens is that the combo that should be working as a parameter
>holder (since it has no DataField set, and has ParamName set) are
>behaving like a simple data aware component.
get the IB_Combobox/ParamName thing cleared up.
IB_ComboBox is a data-aware component that is bound to a field in a
dataset. Like several IBO controls, this control can be bound to a
parameter of that dataset, instead of a field.
Just as a field has to exist in the datasource dataset, in order to
have a data-aware control bound to it, so a *parameter* has to exist
in the datasource dataset, in order to have a data-aware control bound to it.
But, because *this* control is designed to allow a value to be
selected for (in this case) the parameter it is bound to, the dataset
must be in a Prepared state, with the named parameter available, to
be ready to accept a value for the parameter.
So - the two things you need here are
1) The datasource query's statement, with a WHERE clause that
contains the named parameter, e.g. ...'WHERE ID_CLASSE = :ID_CLASSE
2) The statement to be in a Prepared state
Does that help?
Helen