Re: Delete

Article View: borland.public.interbase.sql

Article #1003

Back to borland.public.interbase.sql Previous Next

#1003

From: Serra
Date: Mon, 26 Feb 2007 17:37

9 lines
1214 bytes

Thank you Wayne.

SELECT ID FROM MYTABLE WHERE PCODE=123
with above code the result could be 1 or 2 rows (record(s))
( never null, never 3 rows, 1 or 2 )
i need to delete if exists both of them with below code
i dont know the result=1 row or 2 rows.

DELETE FROM MYTABLE WHERE PCODE=........

Technical Details

Message-ID: <45e31abb@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news1.google.com!news.germany.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <45e2e183@newsgroups.borland.com> <45e2fa4c$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,b4ac827e8c995f1f
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Serra" <nomail@nomail.com>
Newsgroups: borland.public.interbase.sql
References: <45e2e183@newsgroups.borland.com> <45e2fa4c$1@newsgroups.borland.com>
Subject: Re: Delete
Date: Mon, 26 Feb 2007 19:37:57 +0200
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 88.240.15.205
Message-ID: <45e31abb@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1172511419 88.240.15.205 (26 Feb 2007 09:36:59 -0800)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news1.google.com!news.germany.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message