Re: [SQL] Q: insert/update in same statement

2003-09-13 Thread Bruno Wolff III
On Fri, Sep 12, 2003 at 10:55:17 -0700, "G. Ralph Kuntz, MD" <[EMAIL PROTECTED]> wrote: > Is it possible to make a single SQL statement that will insert a row > if it does not already exist, otherwise it will just update the > fields? No. > Actually, just a statement that will not give an error

[SQL] Q: insert/update in same statement

2003-09-13 Thread G. Ralph Kuntz, MD
Is it possible to make a single SQL statement that will insert a row if it does not already exist, otherwise it will just update the fields? Actually, just a statement that will not give an error about duplicate keys would be enough for my application. Something like INSERT INTO SOME_TABLE (FIEL