Anand wrote:

> I am writing a stored procedure in a FireBird 1.0 database,
> where I am trying to accept values for all the fields in a
> table, and then either insert a new record or update the
> existing record based on the primary key field value. In this
> regard, I need to maintain a string variable in which I shall
> maintain an SQL string, and at the end of a few checks, I need
> to execute this string. Is there any way I can do this in the
> Stored Procedure?

With the new EXECUTE functionnality introduced in Firebird 1.5, yes.

--
Olivier Mascia