Article View: borland.public.vdbase.data.sql
Article #179Re: rowset.FinKey() in a multicolumnar SQL Index
From: Bowen Moursund (TeamB)
Date: Tue, 09 Mar 1999 00:00
Date: Tue, 09 Mar 1999 00:00
25 lines
1481 bytes
1481 bytes
>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?
Yes. If you're using variables, you'd do it like this:
oRowset.filter:=[CG_TLTJ = ']+cStr1+[' and CL_AMBT =']+cStr2 +[']
oRowser.first()
An alternative might be to use a parameterized query - change the parms and
requery().
__
Bowen Moursund (TeamB)
bowen at nerds dot com
http://lonestar.texas.net/~moursund/
Try these help resources:
http://www.dejanews.com/home_ps.shtml
http://forumsearch.inprise.com:88/
Technical Details
Message-ID:
<7c3ihi$gu516@forums.borland.com>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> <VA.0000010a.0068fba7@jpddb>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,165fa53f4266efc9 X-Google-Attributes: gidff5a1,public From: "Bowen Moursund (TeamB)" <bowenSEND_ME_NO_SPICED_HAM@nerds.com> Subject: Re: rowset.FinKey() in a multicolumnar SQL Index Date: 1999/03/09 Message-ID: <7c3ihi$gu516@forums.borland.com> X-Deja-AN: 453024024 References: <VA.00000107.052589a8@jpddb><MPG.114a002865160aeb989fb4@forums.inprise.com><VA.00000108.00e39ae2@jpddb><7c0thu$e9h13@forums.borland.com> <VA.0000010a.0068fba7@jpddb> X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Organization: DataTech Newsgroups: borland.public.vdbase.data.sql