🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: TADOTable and findFirst

#2698
From: Viatcheslav V. Vassiliev
Date: Wed, 09 Apr 2003 09:49
35 lines
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-mail
References: <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