For some reason InterBase changes the name to DB_KEY and strips off the RDB$
prefix.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "stewartbourke" <stewartbourke@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, July 10, 2002 4:05 PM
Subject: [IBO] rdb$db_key in a select


> I have an iboquery, and I am trying to do something like:
>
> select rdb$db_key from products;
>
> If I put this sql into the query and execute it, if I try
>
> fieldbyname('rdb$db_key').AsString I get an exception saying the
> fieldname does nto exist
>
> Can I reference the rdb$db_key field in the IBOquery components? If
> so, could anybody give me an example of how I can do this?
>
> Thanks,
>
> Stewart Bourke