Subject Re: [IBO] IBOQuery - any way to get calculated fields here as well?
Author Helen Borrie
At 12:29 AM 5/10/2005 +0200, you wrote:
>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).

No, you're not right. TIBOQuery is a TDataset descendant so you just
create calc fields for it the same as you do with TQuery. If you don't
know how to do that, look up the Delphi VCL help. (The same rule applies
to all class members inherited from the VCL components, that are not
overridden. This is Delphi!!)

As Hans has pointed out, if these are not complex calculations, it is far
simpler (and uses fewer resources) if you retrieve the calculated values as
derived fields, also sometimes called "expression fields".

>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 ..

I can't help with that, as I've never used RB. But I assume that you know
about the AssignSQLWithSearch method of TIB_Dataset, which is also
available to the TIBODataset?