Subject | Dinamic SQL in Firebird ! |
---|---|
Author | grndeveloper |
Post date | 2005-04-18T08:39:10Z |
First of all, sorry about my indian english! (- i am a developer of grn)
Nobody knows a way to insert a dynamic SQL in a procedure?
We want to change the number of restrictions in a query, in function
of an input parameter.
The solutions that we done is change the query contraints with delphi
or duplicate the code in firebird's procedure, but this is a ugly
solution and its more difficult to maintain the code...
Has firebird resources to solve this problem by himself?
Lots of thanks !
-- Armand!
Nobody knows a way to insert a dynamic SQL in a procedure?
We want to change the number of restrictions in a query, in function
of an input parameter.
The solutions that we done is change the query contraints with delphi
or duplicate the code in firebird's procedure, but this is a ugly
solution and its more difficult to maintain the code...
Has firebird resources to solve this problem by himself?
Lots of thanks !
-- Armand!