Problem in SQL Condition

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

Article #2501

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

#2501

From: Andreas Weichert
Date: Tue, 03 Jun 2003 10:39

28 lines
1605 bytes

Hello !

In the ADOTable I set the filter to an combination of  "and" and "or"
Conditions with brackets:

Cond1 and (Cond2 or Cond3)

I get the Error like:
Arguments of wrog type or out of range.

The Sql-String in MS-Access direct works fine.

What happens ?  Are Brackets with  and/or not possible ?


Andreas Weichert



--

--------------------------------------------------
Product Management Software
TriOS Optical Sensors
Werftweg 15              fon: +49 (0) 441 48598-12
D-26135 Oldenburg        fax: +49 (0) 441 48598-20
Germany                  web: www.trios.de

Technical Details

Message-ID: <3edc7abe$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news-out.visi.com!petbe.visi.com!newsfeed.media.kyoto-u.ac.jp!newsfeed.icl.net!newsfeed.fjserv.net!skynet.be!skynet.be!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,9ab018654d5d299,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-06-03 03:39:51 PST
From: "Andreas Weichert" <weichert@trios.de>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Problem in SQL Condition
Date: Tue, 3 Jun 2003 12:39:09 +0200
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 217.82.99.185
Message-ID: <3edc7abe$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1054636734 217.82.99.185 (3 Jun 2003 03:38:54 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news-out.visi.com!petbe.visi.com!newsfeed.media.kyoto-u.ac.jp!newsfeed.icl.net!newsfeed.fjserv.net!skynet.be!skynet.be!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail