How can I return the count of affected records from insert/update/delete?

Article View: borland.public.interbase.sql

Article #709

Back to borland.public.interbase.sql Previous Next

#709

From: Fredrik Larsson
Date: Fri, 27 Jul 2007 21:21

6 lines
1294 bytes

Hi,

I want to do inserts/updates/deletes. How can I return how many records 
has been affected? Is there any easy way using SQL?

Regards, Fredrik.

Technical Details

Message-ID: <mn.dd797d771dfc56da.26430@none.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,ee95d44f8fa31383,start
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Subject: How can I return the count of affected records from insert/update/delete?
From: Fredrik Larsson <none@none.com>
Newsgroups: borland.public.interbase.sql
Message-ID: <mn.dd797d771dfc56da.26430@none.com>
X-Newsreader: MesNews/1.06.00.00-sw
Date: Fri, 27 Jul 2007 23:21:22 +0200
MIME-Version: 1.0
X-Face: #0?irvdFiM!(Tpl}/tO%_kuSW_^9G5aeIEnY1uNPcd@N_U.B30\*[%N-cnqSC,rEfeq\m:b oR({RM{x03]Iv}^2xc7\J][^MkbL3DYdLevZ$&h0WbH!i:>O1i#FLy/mO2G~xMF<YSj^@q9sRC~iP> *uQnfN4xre8v9%0fqg;i.!ymm~6w2nEx);Q~Q*8&dUO(fn
Reply-To: none@none.com
Content-Type: text/plain; charset="iso-8859-15"; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 81.225.24.53
X-Trace: newsgroups.borland.com 1185571273 81.225.24.53 (27 Jul 2007 14:21:13 -0700)
Lines: 8
Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
X-Original-Bytes: 1135