🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

rowset.FinKey() in a multicolumnar SQL Index

#155
From: Jose Luis Perez Diez
Date: Fri, 05 Mar 1999 00:00
13 lines
962 bytes
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')



Jos� Luis P�rez Diez
Technical Details
Message-ID: <VA.00000107.052589a8@jpddb>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: ff5a1,165fa53f4266efc9,start
X-Google-Attributes: gidff5a1,public
From: Jose Luis Perez Diez <NOMAIL@Jluis.es>
Subject: rowset.FinKey() in a multicolumnar SQL Index
Date: 1999/03/05
Message-ID: <VA.00000107.052589a8@jpddb>
X-Deja-AN: 451466682
Content-Transfer-Encoding: 8bit
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