>>>I have an index routine that uses a KEYS.DBF file. This file contains the filename, index name, key expression and Ascending/Descending indicator.
>>>
>>>Is there a way to populate this file by reading the .dbc directly?
>>>
>>>Ideally, I'd like to run "LoadKeys()" at app startup as well as intermittently during development.
>>>
>>>TIA
>>Hi Larry,
>>
>>The table and tag names are present but not the expression. You could use the KEY() function to retrieve those. I did something similar in FPW, and it isn't that hard to do. Of course, didn't have the DBC so I had to use other functions.
>>
>>hth,
>
>Thanks George... So I can
>
>- USE the table
>- SET ORDER TO tagname
>- save KEY() info
>
>and that should do it? sound simple enough, I'll try it right now.
>
>Thanks again...
Hi Larry,
You're working too hard at this.:-) You don't have to issue SET ORDER. For example, TAG(1) returns the first tagname and KEY(1) returns the expression of the first tag.
George
Ubi caritas et amor, deus ibi est