Article View: borland.public.cppbuilder.database.ado
Article #2698Re: TADOTable and findFirst
From: Viatcheslav V. Vassiliev
Date: Wed, 09 Apr 2003 09:49
Date: Wed, 09 Apr 2003 09:49
35 lines
2253 bytes
2253 bytes
Try [name] like 'wi*' ---------------------------------------------------------------- Regards, Viatcheslav V. Vassiliev http://www.oledbdirect.com The fastest way to access MS SQL Server, MS Jet (MS Access) and Interbase (through OLEDB) databases. "William d'foe" <wdf@tele.spam.dk> �������/�������� � �������� ���������: news:3e93d0cf@newsgroups.borland.com... > I am trying setting a TADOTables fileter to [name="wi*"] and expect a > folowing call to FindFirst to find the first entry with a name matching the > mask Wi... will or wilma or whatever is there and comes first. It doesnt > move to any entry though. If i set the mask to "Will" then it will go to an > entry with name Will. > The help says that wildcards can be used, but for some reason it doesnt work > for me. > > > I thought it could have something to do with the cursor type which is > ctStatic. I cant change it though. If i change it to ctDynamic and then set > the table active, it goes right back at ctStatic. I dont know if that has > anything to do with it though. > > Can someone explain to me how i find the first record with name matching > "something*"? > >
Technical Details
Message-ID:
<3e93ed42@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-08!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!c03.atl99!news.webusenet.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<3e93d0cf@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,beca434ec02f5d43 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-04-09 03:02:19 PST From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com> Newsgroups: borland.public.cppbuilder.database.ado References: <3e93d0cf@newsgroups.borland.com> Subject: Re: TADOTable and findFirst Date: Wed, 9 Apr 2003 13:49:35 +0400 Lines: 37 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 NNTP-Posting-Host: 213.247.201.57 Message-ID: <3e93ed42@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1049881922 213.247.201.57 (9 Apr 2003 02:52:02 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-08!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!c03.atl99!news.webusenet.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail