As a matter of fact, there is. I can't remember exactly what it is called
but it is there. Something like SysFieldNames or something like that. I use
it for dssSearch mode. For example, if you take the dataset into search mode
you will notice that it will use your in-line select will get used instead
of the FIELD1 identifier.

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

----- Original Message -----
From: "Andreas Pohl" <apohl@...>
To: <IBObjects@egroups.com>
Sent: Tuesday, January 16, 2001 2:50 PM
Subject: [IBO] sql expression for inline selected fields


> Is there a quick'n'easy way to acces to the sql expression of an inline
> selected field?
>
> Example:
>
> select
> (select f1 from table1 t1 where t1.no=t2.no) as Field1,
> t2.*
> from table2 t2
>
> I need "(select f1 from table1 t1 where t1.no=t2.no)" to add my own sql
> where clause. "Field1" will not help at all.
>
> BTW, in real program there are user defined parameters within select
clause.
> So it is much more difficult :(
>
> Mit freundlichem Gruss & Best Regards
>
> Andreas Pohl
> apohl@...
> http://www.ibp-consult.com
>
>
>
>
>