Article View: borland.public.vdbase.data.sql
Article #158Re: rowset.FinKey() in a multicolumnar SQL Index
From: Romain Strieff [TeamB]
Date: Fri, 05 Mar 1999 00:00
Date: Fri, 05 Mar 1999 00:00
19 lines
1211 bytes
1211 bytes
In article <VA.00000107.052589a8@jpddb>, Jose Luis Perez Diez politely
paraphrased ...
> I'm connected to an oracle database via OBDC and findkey() works for simple
> indexes but when I try to it with a multicolumnar index I don't get a response
> for a long time.
> 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.FindKey('MDL','1')
>
Oracle and ODBC _are_ the slowest possible combination.
--
Romain Strieff [TeamB]
Please read this newsgroup guide below before
posting on the private Inprise newsgroups.
http://www.inprise.com/newsgroups/guide.html
--
Technical Details
Message-ID:
<MPG.114a002865160aeb989fb4@forums.inprise.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<VA.00000107.052589a8@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: teamb@opto-pps.com (Romain Strieff [TeamB]) Subject: Re: rowset.FinKey() in a multicolumnar SQL Index Date: 1999/03/05 Message-ID: <MPG.114a002865160aeb989fb4@forums.inprise.com> X-Deja-AN: 451584577 References: <VA.00000107.052589a8@jpddb> Organization: TeamB Newsgroups: borland.public.vdbase.data.sql