Subject | Re: [firebird-support] FB 1.5 stored procedure question |
---|---|
Author | Alex Taylor |
Post date | 2003-12-20T09:09:13Z |
Hi Svilen!
See the release notes. FB 1.5 has a new PL-SQL statement called EXECUTE
STATEMENT. This statement provides the way of executing SQL statements
stored in character-type variable. This way You can dinamically generate
your sql statement based on any condition you want. After generating the
appropriate SQL string, You can execute it with the above statement. I
think this will help.
Regards: Alex
See the release notes. FB 1.5 has a new PL-SQL statement called EXECUTE
STATEMENT. This statement provides the way of executing SQL statements
stored in character-type variable. This way You can dinamically generate
your sql statement based on any condition you want. After generating the
appropriate SQL string, You can execute it with the above statement. I
think this will help.
Regards: Alex