Subject | Prepare Question |
---|---|
Author | Christian Mautendorfer |
Post date | 2001-02-22T17:04:31Z |
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
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