Subject | Re: In a Firebird UDF, can you establish a connection back to the database? |
---|---|
Author | tomsee7 |
Post date | 2010-12-31T11:56:11Z |
--- In firebird-support@yahoogroups.com, "Steve" <steve_goa@...>
snip...
Given you have both ends of the problem (i.e. database ddl & UDF) can you not simply return and interrogate values from the UDF that would then decide whether to invoke the stored procedure.
Tom
snip...
> I understand this, and am doing this in fact. However, I have a special requirement that the UDF further calls a stored procedure to retrieve some data from the database (it is an expression evaluator and calculator, whose input includes regular arithmetic expressions, and functions that depend on data from the database ).It seems to me, naively perhaps, that all you want to do should be possible without resorting to this ill-advised technique.
>
>
>
> Yours sincerely,
> Steve Faleiro
Given you have both ends of the problem (i.e. database ddl & UDF) can you not simply return and interrogate values from the UDF that would then decide whether to invoke the stored procedure.
Tom