Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!usc!wuarchive!sdd.hp.com!hplabs!well!kms
From: kms@well.sf.ca.us (Kelly Stanonik)
Newsgroups: comp.databases
Subject: Re: So does Clipper do it ?
Message-ID: <24910@well.sf.ca.us>
Date: 21 May 91 04:29:40 GMT
References: <77135@eerie.acsu.Buffalo.EDU>
Lines: 25

v442wwjl@ubvmsb.cc.buffalo.edu (Atif S Mir) writes:

>1-	Is there anyway to get an index bar that shows the amount of database
>	indexed at a particular instance (w/o geting into memory resident 
>	programs). I tried using a function that replicates itself but it does
>	not work (i.e. INDEX ON function(field) to NTX ).

Well, first of all, what version of Clipper are you trying to use?  Second
of all you can index on a function to display the update bar.  I personally
shy away from this approach since it places garbage in your index key, but
it will work.  In my systems I typically display a bar for all indexes in
the system when full-reindexing is taking place and update it after each
index.  Of course for large indexes you can be in for a wait.

>2-	Before a READ, how can we find out the position of the cursor (i.e.
>	which GET field it is in).

Well, technically the cursor isn't in a get until after a read (well I 
guess you'd say DURING a read).  row() and col() will return the row and
column of the cursor from a valid function.
-- 
* "My God, it's full of stars" -- overheard in a hamburger hamlet in west la.
* kms@well.sf.ca.us,  or bix: kms, or prodigy (yuck!) cgpd47a
* 2zip/arip              cis: 74730,77  
* free software        snail: 4469 ventura cyn #e107, sherman oaks, ca 91423