Re: Locate method of TADOQuery

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

Article #4195

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

#4195

From: Formentz
Date: Mon, 18 Mar 2002 11:39

19 lines
1634 bytes

Yes,
I know how to use SQL to find what I need, but in this case I have a DataSet
already opened, and I need to search in it without closing it, and the
locate method doesn't permit to use something like the like SQL keyword.

Thanks anyway
Ciao
Formentz

"BM" <m02x7z00@cwcom.net> ha scritto nel messaggio news:3c95ce7c_2@dnews...
> Presumably at the end of the day its performing some SQL in the background
> similar to...
> i.e WHERE MYFIELD LIKE 'ADO%'
> the % after the "ADO" means it will match anything starting with "ADO"
>
> Use the following SQL instead - of the form
> WHERE MYFIELD LIKE '%ADO%'
> then it will match anything with "ADO" anywhere in the text.
>

Technical Details

Message-ID: <3c95d1bc_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!peer1-sjc1.usenetserver.com!usenetserver.com!hub1.nntpserver.com!news.maxwell.syr.edu!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews

References: <3c95c71a$1_1@dnews> <3c95ce7c_2@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,73110aeff53c8dd7
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-03-18 03:39:13 PST
From: "Formentz" <francesco@leotron.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3c95c71a$1_1@dnews> <3c95ce7c_2@dnews>
Subject: Re: Locate method of TADOQuery
Date: Mon, 18 Mar 2002 12:39:09 +0100
Lines: 22
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: 80.16.99.17
Message-ID: <3c95d1bc_1@dnews>
X-Trace: dnews 1016451516 80.16.99.17 (18 Mar 2002 03:38:36 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!peer1-sjc1.usenetserver.com!usenetserver.com!hub1.nntpserver.com!news.maxwell.syr.edu!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews

Reply to Parent Message