Re: Modifying INSERT
From: Paul Vernon <paul.vernon_at_ukk.ibmm.comm>
Date: Wed, 7 Apr 2004 17:02:23 +0100
Message-ID: <c518rk$1ire$1_at_gazette.almaden.ibm.com>
Date: Wed, 7 Apr 2004 17:02:23 +0100
Message-ID: <c518rk$1ire$1_at_gazette.almaden.ibm.com>
"Laconic2" <laconic2_at_comcast.net> wrote in message
news:ruOdnQfgdNaraO7dRVn-hw_at_comcast.com...
> You are right. There should be courteous warning.
>
> It could be done with an insert count. The DELETE statement tells you how
> many rows were deleted, and "zero rows deleted" is a courteous warning
> that no rows statisfied your cirteria.
>
> Likewise, "zero rows inserted" would be sufficient courteous warning,
IMO,
> that the row was already there.
>
And this warning is a relation right?
Regards
Paul Vernon
Business Intelligence, IBM Global Services
Received on Wed Apr 07 2004 - 18:02:23 CEST