At 01:31 PM 26/11/2003 +1100, you wrote:

>Thanks for the info... we're waiting on fb 1.5 to be officially released
>before we start playing with it, so we'll have to look at another solution
>for now. However, just to clarify, in fb 1.5, the [declare 'x' statement]
>syntax is supported within triggers and/or procedures?

declare variable x varchar(whatever_size_you_need);
Grab the release notes from the ibphoenix site and read up on EXECUTE
STATEMENT.

>Just curious, why do you think that it isn't very robust - possibility of
>errors in table names coming from our g_topics table?

No, only that there is no way for this approach to validate anything in the
executable string your PSQL code constructs. It's up to you to provide
your own bombproofing and protect dependencies.

Helen