Does this code work on ADO?

Article View: borland.public.cppbuilder.database.ado

Article #3689

Back to borland.public.cppbuilder.database.ado Previous Next

#3689

From: Baris YURTCU
Date: Sat, 06 Jul 2002 23:50

21 lines
1548 bytes

Hi,

My record set object is dataset1. DB is MS-SQL server.

dataset1.Filter = "Age <= 18 AND (Age = NULL OR Age >= 30)" // First Code

This code doesn't work. But these codes work:

dataset1.Filter = "(Age = NULL OR Age >= 30)" // Second Code

dataset1.Filter = "Age <= 18 AND (Age = NULL AND Age >= 30)" // Third Code

Change is only OR on third code according to first code. I have changed OR
to AND. (Condition is nonsensical, but that's not important) Second code
works fine.

What this does mean? Can not ADO analyze "(<Condition1> AND <Condition2>
(<Condition3> OR <Condition4>)" style Filter?

Thanks,
Baris

Technical Details

Message-ID: <3d278297_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-01!supernews.com!feed.textport.net!diablo.netcom.net.uk!netcom.net.uk!newsfeed.icl.net!newsfeed.fjserv.net!logbridge.uoregon.edu!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,22e3398c1868196,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-07-06 16:58:50 PST
From: "Baris YURTCU" <badidi@hotmail.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Does this code work on ADO?
Date: Sun, 7 Jul 2002 02:50:10 +0300
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 195.175.164.149
Message-ID: <3d278297_2@dnews>
X-Trace: dnews 1025999511 195.175.164.149 (6 Jul 2002 16:51:51 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-01!supernews.com!feed.textport.net!diablo.netcom.net.uk!netcom.net.uk!newsfeed.icl.net!newsfeed.fjserv.net!logbridge.uoregon.edu!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews