🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.vdbase.data.sql
Article #158

Re: rowset.FinKey() in a multicolumnar SQL Index

#158
From: Romain Strieff [TeamB]
Date: Fri, 05 Mar 1999 00:00
19 lines
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-mail
References: <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