Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
V6s5 & FireBird15 - Getting description / captions
Message
 
À
19/02/2004 02:54:06
Dorin Vasilescu
ALL Trans Romania
Arad, Roumanie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00878228
Message ID:
00878658
Vues:
15
Hi Dorin

Thanks again for your continous help.

>To get fields descriptions you must query the system table rdb$relation_fields
>
>table_name = ...
>SQLEXEC(1,[SELECT RDB$FIELD_NAME, RDB$RELATION_NAME,RDB$DESCRIPTION FROM RDB$RELATION_FIELDS WHERE RDB$RELATION_NAME=?table_name])
>
>Then you can scan the cursor and set caption property using DBSETPROP() function.
>(I'm curious if this function works, because in VFP7 seems broken for "FIELD" type object)

I am using VFP6 so we may get another angle to the problem <g>
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform