Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!usc!apple!agate!dog.ee.lbl.gov!nosc!humu!pegasus!tleylan
From: tleylan@pegasus.com (Tom Leylan)
Newsgroups: comp.databases
Subject: Re: So does Clipper do it ?
Keywords: Clipper Index gauge, .NTX file, dbCreatIndex()
Message-ID: <1991May26.034816.21511@pegasus.com>
Date: 26 May 91 03:48:16 GMT
References: <29737@hydra.gatech.EDU> <1991May24.173628.15324@msuinfo.cl.msu.edu> <1991May24.180404.18538@msuinfo.cl.msu.edu>
Organization: Pegasus,  Honolulu
Lines: 30

In article <1991May24.180404.18538@msuinfo.cl.msu.edu> cushman@cpsin2.cps.msu.edu (Roderick J Cushman) writes:
>
>                Internal to Clipper version 5.0 (and I believe it is
>        now documented in version 5.01) is a function called dbCreatIndex()
>        (spelling ??).  I would have to look up the actual spelling of the
>        function;  it can be found if you pre-process your code, then
>        observe the .PPO file relevant to the INDEX ON <expr> to file.
>        The parameters to the function are as follows:
> 
>        dbCreatIndex( cFileName, cFileExpr, bCreatExpr, lUniqflag)
>
Rod,  Just by way of clarification.  dbCreateIndex() is not undocumented
and is not "internal".  It should be in the NG that came with 5.01.  And
rather than read preprocessor output one can see it plainly sitting in
the STD.CH file.  I believe you will find that the NG has a small error
in the order of the arguments.

In both S'87 and 5.01 you will be required to "fix" the index header if
you index on a function.  A simple look at the index header with your
favorite hex editor will veryify the index expression.  I suggest leaving
the index string empty "" and supplying just the index code block if you
want a progress indicator.  If you don't do that you can test with a compound
key expression  lastname + firstname (for instance) and you will notice that
the index block is called only once at the beginning of the index process
and never again.  Your indicator will therefore not indicate.

I'll probably post my version later today if I can figure out how to
imbed it into a response to this thread.

tom