Re: Using IN with query in a RDM

Article View: borland.public.cppbuilder.database.multi-tier

Article #1619

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#1619

From: Jim
Date: Thu, 01 Jul 1999 00:00

10 lines
884 bytes

I used the statement before,but it worked.
My SQL statement look like
  "select id from table1 where id  in (select id from table2)"  or
 "select id from table1 where id  not in ('01','02','03')"
All worked in paradox table.

maybe you should show your entire sql statement or
try your statement in Database Destop first.

Jim

Technical Details

Message-ID: <7leenl$str3@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <3779301D.8A5A1581@artisansoftware.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,b3e9f1c7b851a475
X-Google-Attributes: gidfcd2b,public
From: "Jim" <jim@www.cdsf.com>
Subject: Re: Using IN with query in a RDM
Date: 1999/07/01
Message-ID: <7leenl$str3@forums.borland.com>
X-Deja-AN: 495835023
References: <3779301D.8A5A1581@artisansoftware.com>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Organization: Another Netscape Collabra Server User
X-MSMail-Priority: Normal
Newsgroups: borland.public.cppbuilder.database.multi-tier

Reply to Parent Message