--- In firebird-support@yahoogroups.com, "majstoru" <majstoru@y...> wrote:

>
> Hi,
>
> I have Firebird like bakcend dabatabse in my n-tier application which
> is have a 10-15 thin clients connected to server (this is scenario). I
> have some thinks in application that is defined in table (fex:
> sysoperate) in the database! This thinks are set of few SQL statments!
> I would lie to import all of theese SQL statments in to the
> StoredProcedure and execute it like SP! It mean when I change SQL
> statment, SP fetch new statments and execute then on new call of SP by
> client.
>
> Thanks for ALL!
>

thinks = query?

You have a table containing SQL statements. You have a stored
procedure that you want to get these statements and run them?

Apart from the security problems this might introduce, it can be done
using the "execute statement" command.

....

FOR SELECT QRY FROM SPQRY INTO :STMT DO
BEGIN
EXECUTE STATEMENT :STMT;
END

....

Although I imagine you may have problems in the long run because
dependencies will not be obvious and something might break.

Adam