Hello

If you don't have to actually do some work on the data for
your calculated field you may be able to use a singleton
select to get your field,

select a.bd_id, a.bd_part, a.bd_qty,
(select b.BM_Descr from BatchM b
where (a.bd_bm_id = b.BM_ID)) as BM_Descr
from BatchD a
where a.bd_bm_id = 8791

Or you might be able to get it with a "Left Join"

Good Luck
Michael L. Horne

> -----Original Message-----
> From:
> sentto-402930-4153-982861498-guardian=pobox.com@...
> [mailto:sentto-402930-4153-982861498-guardian=pobox.com@....
> com]On Behalf Of Christian Mautendorfer
> Sent: Thursday, February 22, 2001 12:05 PM
> To: ibObjects@yahoogroups.com
> Subject: [IBO] Prepare Question
>
>
> Hi,
>
> I have a Query Component with a calculated Field. It fills this field by
> calling a DSQL component, passing a parameter which creates a
> select with 1 result.
> Now since OnCalcfields can be called at any time what are the adverse
> effects of calling prepare when my datamodule is create (at
> program start)
> and unpreparing when it is closed (at program end).
> I would guess it ties up the OAT and a bit of server resources.
>
> If this is rather bad practice is there a way to find out which
> is the last
> OnCalcfields of a bunch being called?
> (First is rather easy)
>
> If not I'll find a workaround but otherwise if anyone already has a
> solution for this I'd be grateful to hear about it.
>
> Regards and TIA,
>
> --
> --Chris
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>