--- In firebird-support@yahoogroups.com, "ariel.sakin" <asakin@...> wrote:

>
> Hi,
> I am using Firebird 1.5 and I want to create a query that updates a
> row, or creates a new one if the row does not exist.
> I found that in 2.1 there will be a REPLACE/MERGE command for doing
> this, but I was not able to find a solution for 1.5 (Other than
> checking if a row exists in a separate query).
>
> Is there any way of doing this in a more efficient way?

You could use a stored procedure to achieve a similar thing in 1.5,
but merge is definately a better solution when 2.1 is finished.

Adam