Hi.

I need to update a record if it exist, or if it does not exist then it must be inserted.

How does such a query look like?

Hi John,

No built-in feature, but a workaround in Delphi is:

UpdateQuery.ExecSQL;
if UpdateQuery.RowsAffected = 0 then InsertQuery.ExecSQL;

~Jason Lee


John wrote:
> Hi.
>
> I need to update a record if it exist, or if it does not exist then it must be inserted.
>
> How does such a query look like?
>

"John" <eydunl@post.olivant.fo> wrote in message
news:A4F6261D-07B5-4790-81EF-16C7719A55B1@news.elevatesoft.com...
> I need to update a record if it exist, or if it does not exist then it
> must be inserted.

I posted an interest in something like this a while back in .suggestions,
and I believe Tim hinted it might be an addition in the future.

Thread was "INSERTORUPDATE?" posted 2006-06-02

-Johnnie

Hi John,

I would also vote for this extension to be included.

MySQL has this, and I have found it to be a great timesaver.
--
Best regards

Steve

"John" <eydunl@post.olivant.fo> wrote in message
news:A4F6261D-07B5-4790-81EF-16C7719A55B1@news.elevatesoft.com...
> Hi.
>
> I need to update a record if it exist, or if it does not exist then it
> must be inserted.
>
> How does such a query look like?
>

Johnnie,

<< I posted an interest in something like this a while back in .suggestions,
and I believe Tim hinted it might be an addition in the future. >>

Yes, it's on the list.

--
Tim Young
Elevate Software
www.elevatesoft.com