Article View: borland.public.vdbase.data.sql
Article #985Re: Predicate IN in WHERE clause don't work well
From: Steve Koterski
Date: Wed, 10 Jun 1998 00:00
Date: Wed, 10 Jun 1998 00:00
23 lines
1432 bytes
1432 bytes
On Wed, 10 Jun 1998 17:28:28 +0200, Paolo Bombaci <mlsys@mlsys.it> wrote: >Why when I use IN predicate the SQL don't work well ? > >I do this SQL : > >SELECT * FROM "GRUPPI.DBF" GRUPPI WHERE NUMERO_GRUPPO IN (1,2) > >The result is that are no record that are IN (1,2) [...] What version of the BDE are you using? Some significant rework of the query engine and specifically the IN predicate was done in the 4.x version of the BDE. Unless dBASE is doing some hokey-pokey in between, your statement is syntactically correct and should work well. ////////////////////////////////////////////////////////////////////////// Steve Koterski "Knowledge comes, but wisdom lingers." Technical Publications -- Alfred, Lord Tennyson (1809-1914) INPRISE Corporation http://www.inprise.com/delphi
Technical Details
Message-ID:
<3586bdbd.5838435@forums.inprise.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<357EA61C.6FC3@mlsys.it>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,6f1d0cffec597717 X-Google-Attributes: gidff5a1,public From: koterski@borland.com (Steve Koterski) Subject: Re: Predicate IN in WHERE clause don't work well Date: 1998/06/10 Message-ID: <3586bdbd.5838435@forums.inprise.com> X-Deja-AN: 361420725 Content-Transfer-Encoding: 7bit References: <357EA61C.6FC3@mlsys.it> Content-Type: text/plain; charset=us-ascii Organization: INPRISE Corporation, Technical Publications Mime-Version: 1.0 Reply-To: koterski@borland.com Newsgroups: borland.public.vdbase.data.sql