Article View: borland.public.vdbase.data.sql
Article #173Re: rowset.FinKey() in a multicolumnar SQL Index
From: Jose Luis Perez Diez
Date: Tue, 09 Mar 1999 00:00
Date: Tue, 09 Mar 1999 00:00
18 lines
1562 bytes
1562 bytes
In article <7c0thu$e9h13@forums.borland.com>, Bowen Moursund (TeamB) wrote:
> The OLH doesn't indicate to me that the two-field findKey() syntax is valid.
> It may be valid, but as far as I know it isn't documented. At any rate,
> since it isn't working for you I suggest that you try a different technique.
> You might ensure that the there are indexes on the fields individually and
> use the rowset.filter property, or try select...where.
>
The Index TAG: AUT_SERIES Key: CG_TLTJ,CL_AMBT
CG_TLTJ is VARCHAR(5)
CL_AMBT is VARCHAR(1)
I use finkey with code like this one:
orowset.indexName := 'AUT_SERIE'
orowset.Filter :="CG_TLTJ = 'MDL' AND CL_AMBT '1'"/*substitute for: */
orowset.ClearFilter() /*orowset.FindKey('MDL','1')*/
Are you suggesting some code like the pervious one?
Jos� Luis P�rez Diez
Technical Details
Message-ID:
<VA.0000010a.0068fba7@jpddb>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<VA.00000107.052589a8@jpddb><MPG.114a002865160aeb989fb4@forums.inprise.com> <VA.00000108.00e39ae2@jpddb> <7c0thu$e9h13@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: ff5a1,165fa53f4266efc9 X-Google-Attributes: gidff5a1,public From: Jose Luis Perez Diez <NOMAIL@Jluis.es> Subject: Re: rowset.FinKey() in a multicolumnar SQL Index Date: 1999/03/09 Message-ID: <VA.0000010a.0068fba7@jpddb> X-Deja-AN: 452913682 Content-Transfer-Encoding: 8bit References: <VA.00000107.052589a8@jpddb><MPG.114a002865160aeb989fb4@forums.inprise.com> <VA.00000108.00e39ae2@jpddb> <7c0thu$e9h13@forums.borland.com> Content-Type: text/plain; charset=iso-8859-1 Organization: My Company Mime-Version: 1.0 Reply-To: NOMAIL@Jluis.es Newsgroups: borland.public.vdbase.data.sql