Subject Re: [Firebird-Architect] REPLACE, again
Author Adriano dos Santos Fernandes
Dmitry Yemanov wrote:
> "Nando Dessena" <nando@...> wrote:
>
>> I'm not sure I understand you. Is your point that the standard syntax
>> makes it difficult/cumbersome/impossible to implement with a
>> parameterized statement?
>>
Yes, and not *only* for parametized statement.
>
> For me, the standard syntax is too heavy/complex in 80% of cases (single
> table and matching via equality). Writing complete form of update and insert
> statements plus search condition looks quite redundant. But this is just a
> personal opinion.
>
Not only heavy/complex, but it has nothing to do with REPLACE.
One could use MERGE as REPLACE, but the using clause will need to use
RDB$DATABASE.


Adriano