Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Adding/Extracting Index Comments?
Message
De
31/12/1999 14:34:15
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00310911
Message ID:
00310996
Vues:
37
Jim, try this. Add some comments to an index. The use the DCT file
and you will see the index comments. The leading characters preceeding
the comments are not deciferable to me. I can do some crude code to
extract the index comments but I would think that would be the purpose
of the DBGETPROP().

The sad thing is that I can add comments manually but not programatically.
You may be correct that the comments are added to the project- I did not
look there. But I can assure you that they are also contained in the
DCT file of the database container.

I was attempting to utilize this info to grab a description of the index
file in a class to change the order of a table. I saw this technique
done manually in Whil Hentzen's newest book "Fundamentals". I was merely
going to try and go one step better but am at a road block now. Perhaps
it can't be done since to my knowledge Doug Henning, editor of the
Fundamentals book, is probably the subject matter expert on the DBC.

Then again, maybe it can be done...

>>Open up the project manager. Select a table contained in a DBC and right mouse click on an index. Notice that you can add comments for an index using this approach.
>>
>>However, I have been unsuccessful in extracting the index comments via DBGETPROP(). Also, unless I can programatically add index comments for distributed apps the value is moot. I have looked at
>>the code generated by GENDBCX and it does not address this issue.
>>
>>Can this be done?
>
>Tom,
>
>The comment is added to the Project not the DBC. You can read the comment from the Project (at least in VFP 6) using the project object model.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform