On Tue, 28 Sep 2004, Vladimir Vukicevic wrote:
>On Tue, 28 Sep 2004 12:09:45 +0100 (BST), Christian Smith
><[EMAIL PROTECTED]> wrote:
>> Why?
>>
>> Functions are static, you set them up at initialisation time. So why
>> register functions after preparing a statement for execution.
>
>A single database handle is getting shared among multiple components;
>they each want to do creation of their own functions and prepared
>statements. New components that may want to add their own functions
>can also show up at any time, so there's no way to enforce any
>ordering of function creation.
You have two options:
- Ensure you create any functions outside of any prepare/step/finalize
statement execution. Assuming you're locking access to the database
handle, this shouldn't be difficult.
- Give each component their own database handle.
Basically, just register functions before preparing statements, or after
you've finalized your statements.
>
> - Vlad
>
Christian
--
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \
