Home > Archive > Clipper > October 2005 > cdx index problem
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Alan Secker 2005-10-24, 6:55 pm |
| I'm trying to index a file that contains a ten char ID. I want to
create an an additional order. This should be the alphabetical order of
the corresponding names.
My first attempt was to include a function call in the construct. This
passes the ID to the function which returns the corresponding name.
The construct looks like this (there were already 14 orders before the
proposed new one:
index on ..... to (ctime + "cdx") // 14th
index on ( myfile->rec_type + ;
str (myfile->operno, 7) + ;
dtos (bom (myfile->entrydate)) + ;
getclntname ( myfile->task_id ) + ;
str (myfile->actino, 3) ) to (ctime + "cdx") // 15th
never got to find if this works or not. As soon as the program control
had executed the 15th order, it 'lost' the preceding 14!
Has anyone ay idea why that might be?
Alan
'
| |
|
|
| Alan Secker 2005-10-25, 6:55 pm |
| On Mon, 24 Oct 2005 15:33:55 -0700, E. Fridman wrote:
> Alan,
>
> In your example there is no TAG clause.
>
> See http://www.clipx.net/ng/cmx/ngd4f.php
Sorry that was just a typo in the message.
As I understand it, anything can be included in key provided it resolves
to a character string.
| |
| Alan Secker 2005-10-25, 6:55 pm |
| On Mon, 24 Oct 2005 15:33:55 -0700, E. Fridman wrote:
> Alan,
>
> In your example there is no TAG clause.
>
> See http://www.clipx.net/ng/cmx/ngd4f.php
've found the answer. I has interposed a function call between successive
'index on' calls. Sorry for the knee jerk.
Alan
| |
| E. Fridman 2005-10-25, 6:55 pm |
| Alan,
Glad that you solved the problem.
<<< As I understand it, anything can be included in key provided it
resolves to a character string. >>>
.... to a string with a fixed length.
HTH, Eugene
|
|
|
|
|