Re: Question about firebird!

db.geek, 05.05.2008 16:26:
> CREATE TABLE XX ( ID_ INTEGER NOT NULL,
>                   XXN_ VARCHAR(20),
>                   XXK_ VARCHAR(30) );
> 
> I want to insert data into table XX, if has ID_ then update XXN_ and
> XXK_ else insert a new row.
> 
> 
> How to do this?
> Thanks!
> 
Firebird 2.1 has a MERGE statement which is what you want.
I think 2.0 already had an UPDATE OR INSERT statement.

Thomas