Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
V6s5 & FireBird15 - Getting description / captions
Message
 
To
19/02/2004 02:54:06
Dorin Vasilescu
ALL Trans Romania
Arad, Romania
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00878228
Message ID:
00878658
Views:
14
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
___________________________________________
Previous
Reply
Map
View

Click here to load this message in the networking platform