Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to extract filename, indexname, key from .dbc
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00221452
Message ID:
00221467
Vues:
16
>>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform