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

>
> --- 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
>

Hi Adam,

Let me explain some details! I have application where some rules of
application can modify end user! The table which contain rules, which
will be executed by SP are defined by SQL statment and Parameters, it
mean that I must have a solution that implement these parameters in to
the SP. It is a little complicated but this solution is very useful
for my end users and my development work is less with coding app and
more creative for end users requests!

Thanks for help.