Sorry, the correct source is :

with IB_Query_Currency do
begin
IB_Connection:=DataBaseName;
KeySource :=IB_DsCustomer;
KeyLinks.clear;
KeyLinks.Add('CURRENY.ID = CUSTOMER.CURRENCY_ID');

FieldsDisplayWidth.clear;
FieldsDisplayWidth.Add('CURRENCY=30');

FieldsVisible.Clear;
FieldsVisible.add('ID=NO');

SQL.clear;
SQL.add('select ID,CURRENCY from CURRENCY order by ID');

open;
end;

Ulrich




<ulrich.groffy@...> schrieb im Newsbeitrag
news:005601c263b0$63f304e0$0a00a8c0@p3w2k...

> When is the best moment to set the required properties?
>
> I tried this :
>
> with IB_Query_Currency do
> begin
> IB_Connection:=DataBaseName;
> KeySource :=IB_DsCustomer;
> KeyLinks.clear;
> KeyLinks.Add('CURRENY.ID = CUSTOMER.CURRENCY_ID');
>
> FieldsDisplayWidth.clear;
> FieldsDisplayWidth.Add('CURRENCY=30');
>
> FieldsVisible.Clear;
> FieldsVisible.add('PRAXIS_ID=NO');
>
> SQL.clear;
> SQL.add('select ID,CURRENCY from CURRENCY order by ID');
>
> open;
> end;
>
> but the FieldDisplay settings didn't have any effects! For example, the ID
> field is still visible in a LookUpCombo
>
> Where is my mistake?
>
> Best regards - Ulrich
>
>
>
>
>
>

___________________________________________________________________________

> IB Objects - direct, complete, custom connectivity to Firebird or

InterBase

> without the need for BDE, ODBC or any other layer.
>

___________________________________________________________________________

> http://www.ibobjects.com - your IBO community resource for Tech Info

papers,

> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>