Subject | Re: [Firebird-Architect] REPLACE, again |
---|---|
Author | Adriano dos Santos Fernandes |
Post date | 2006-08-26T14:55:59Z |
Dmitry Yemanov wrote:
One could use MERGE as REPLACE, but the using clause will need to use
RDB$DATABASE.
Adriano
> "Nando Dessena" <nando@...> wrote:Yes, and not *only* for parametized statement.
>
>> 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?
>>
>Not only heavy/complex, but it has nothing to do with REPLACE.
> 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.
>
One could use MERGE as REPLACE, but the using clause will need to use
RDB$DATABASE.
Adriano