Subject Re: [IBO] IBOQuery - any way to get calculated fields here as well?
Author Hans
I meant , instead of
select A,B from T and than have a calculated field C=A+B,
rather use
select A,B as C from T
and no need for calculated fields.

Of C= A+B is very simplistic, almost anything can be calculated in FB

----- Original Message -----
From: "Kevin Stanton" <Kevin.Stanton@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, October 04, 2005 5:09 PM
Subject: RE: [IBO] IBOQuery - any way to get calculated fields here as well?


> No, I don't believe you are correct.
> To add calculated fields, you need to work the TDataset way:
> Double-click the TIBOQuery component to bring up the fields editor.
> Ctrl+N will add a new field.
> Then use the oncalcfields event to set the values.
> I have many calculated fields in my app that uses a lot of TIBOQuery.
> Cheers,
> Kevin
>
>
>> -----Original Message-----
>> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On
>> Behalf Of G. Nau
>> Sent: Tuesday, October 04, 2005 3:30 PM
>> To: iBObjects@yahoogroups.com
>> Subject: [IBO] IBOQuery - any way to get calculated fields here as well?
>>
>> I building a bunch of reports using D7 and Reportbuilder 7 (RB7) . RB7 is
>> only supporting TDataset compatible queries. And I need two calculated
>> fields on the reports.
>> Am I right, that IBOQuery does NOT support calculated fields (at least I
>> couldn't find the properties related to them as in IB_query).
>> I also fiddled around a little bit with a number of datapipeline wrapper
>> components to glue native IB_Query and RB together, but got stuck in
>> several compiler errors, including the mysterious "internal compiler
>> error
>> U783", so I'm not sure this is helping me ..
>>
>> Regards
>> Gunther
>>
>>
>> ___________________________________________________________
>> Was denken Sie |ber E-Mail? Wir hvren auf Ihre Meinung:
>> http://surveylink.yahoo.com/wix/p0379378.aspx
>>
>>
>>
>> __________________________________________________________________________
>> _
>> 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
>>
>>
>>
>>
>>
>
>
>
>
>
> ___________________________________________________________________________
> 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
>
>
>
>
>
>