Thanks for the help Dmitry

I tried IB_Query.FieldsVisible.Add('DB_KEY=FALSE');

but omitted to do

> IB_Query.FieldsVisible.Add('RDB$DB_KEY=FALSE');

Setting Key links auto define to False also seems to solve the problem

Regards Cao

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Dmitry Beloshistov
> Sent: 26 October 2005 06:30
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] DB Key and exporting
>
>
> Hello, Cao!
> You wrote to <IBObjects@yahoogroups.com> on Wed, 26 Oct 2005
> 16:00:44 +0200:
>
>
> CA> When a query is written the result sometimes shows a db_key column
> CA> in
> CA> IB_Grid
>
> CA> The queries are dynamic and are written by the users to allow them
> CA> to do quick reporting and exporting of data
>
> CA> How do I prevent this column from showing as IB_Export falls over
> CA> whenever this column is shown
>
> IB_Query.FieldsVisible.Add('RDB$DB_KEY=FALSE');
> IB_Query.FieldsVisible.Add('DB_KEY=FALSE');
>
>
> WBR,Dmitry Beloshistov AKA [-=BDS=-]
>
>
>
>
> __________________________________________________________________
> _________
> 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 !
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>