|Subject||Re: REPLACE command URL|
|Author||A6-CMO Philippe Makowski|
>but you can use a procedure
>>But I think that would be a very helpful feature, isn't it? Are there any
> plans to integrate that? Is there a way to post that idea?
> Plans for this? Not that I know off.
> Useful? I don't know - I've never had a situation where I would like to use
> a REPLACE - then again, I haven't heard of it before.
>>>Have a look at
>>>I mean such a function. Is that avaible?
CREATE PROCEDURE MYTABLE_REPLACE (
FIELD2 Char(4) ) AS
INSERT INTO MYTABLE (
WHEN SQLCODE -803 DO
UPDATE MYTABLE SET
FIELD2 = :FIELD2
FIELD1 = :FIELD1;
Firebird serveur SQL open-source en français
PGP : http://makowski.eu.org/pgpkey.html