🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.multi-tier
Article #550

MIDAS/BCB Indexes Q? urgent :-(

#550
From: Rob Golding
Date: Mon, 16 Jul 2001 15:43
29 lines
1994 bytes
Am having problems understanding ...

Have a CDS linked throught DCOM to MIDAS server to TTABLE
TTABLE has 3 "keys" - Indexes defined in the DataBase, they show in
the mIDAS server table->Indexdefs[] array.

looking through the indexdefs properties in the CDS shows only
"default_order" and "changeindex".
getindexnames() method returns same
indexdefs->Items[0]->fields shows the field in thedefault index - all
fine so far
indexname is NULL ?

q1? is it posssible in the CDS to "see" the indexes as seen by the
ttable in the midas server & how

q2? addindex appears to only work before a new CDS how do you add a
new index to my CDS ?

q3? setting indexname = fieldname gives acces violation "no such
index" but I dont want to add the list of fields using indexfieldnames
for maintenance purposes as the structure can/will change

q4? am i looking at this completely wrong ? should I pass a message to
the midas server to change the default index somehow ? Time
delay/performance issues on this - can't sort locally as only
require/need/have 1 record/result at a time.

builder examples please only as i dont read "delphi" :-)
Technical Details
Message-ID: <62aba7a6.0107160743.18b3f491@posting.google.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!postnews1.google.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,50d3a1b9fbd08c66,start
X-Google-Attributes: gidfcd2b,public
X-Google-ArrivalTime: 2001-07-16 08:43:03 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!postnews1.google.com!not-for-mail
From: rob.golding@othellotech.co.uk (Rob Golding)
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: MIDAS/BCB Indexes Q? urgent :-(
Date: 16 Jul 2001 08:43:02 -0700
Organization: http://groups.google.com/
Lines: 29
Message-ID: <62aba7a6.0107160743.18b3f491@posting.google.com>
NNTP-Posting-Host: 62.49.148.78
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 995298182 23375 127.0.0.1 (16 Jul 2001 15:43:02 GMT)
X-Complaints-To: groups-support@google.com
NNTP-Posting-Date: 16 Jul 2001 15:43:02 GMT