Re: Delete

Article View: borland.public.interbase.sql

Article #1002

Back to borland.public.interbase.sql Previous Next

#1002

From: Wayne Niddery [TeamB]
Date: Mon, 26 Feb 2007 15:19

16 lines
1317 bytes

Serra wrote:
> IB  6,02
>
> SELECT ID FROM MYTABLE WHERE PCODE=123
>
> After getting ID(s) then i need to delete it / them
> DELETE FROM MY TABLE WHERE ID=

Why not just delete using the first condition?

    DELETE FROM MYTABLE WHERE PCODE=123

-- 
Wayne Niddery - Winwright, Inc (www.winwright.ca)
"Light is faster than sound, which is why some folks appear bright
before they speak."

Technical Details

Message-ID: <45e2fa4c$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.germany.com!news.belwue.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <45e2e183@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
Reply-To: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca>
From: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca>
Newsgroups: borland.public.interbase.sql
References: <45e2e183@newsgroups.borland.com>
Subject: Re: Delete
Date: Mon, 26 Feb 2007 10:19:31 -0500
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 69.17.170.228
Message-ID: <45e2fa4c$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1172503116 69.17.170.228 (26 Feb 2007 07:18:36 -0800)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.germany.com!news.belwue.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message