BorlandTalk.com Forum Index BorlandTalk.com
Borland discussion newsgroups
 
Archives   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

How to get field despcription??

 
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> C++ Builder Databases (ADO)
View previous topic :: View next topic  
Author Message
Francesco
Guest





PostPosted: Fri Dec 09, 2005 9:50 am    Post subject: How to get field despcription?? Reply with quote




Hello,

when I create a field in a table, for example in MS SQL SERVER, I can
write a description line. Is it possible to get that description at run
time. For example I execute a query on table1 that has FIELD1, FIELD2
and FIELD3. I'd like to get description of those fields to use for
DBGrid column caption instead of field name.

Francesco
Back to top
Francesco
Guest





PostPosted: Fri Dec 09, 2005 12:55 pm    Post subject: Re: How to get field despcription?? Reply with quote




Solved using the procedure fn_listextendedproperty

thanks anyway, Francesco



Francesco wrote:

Quote:

Hello,

when I create a field in a table, for example in MS SQL SERVER, I can
write a description line. Is it possible to get that description at
run time. For example I execute a query on table1 that has FIELD1,
FIELD2 and FIELD3. I'd like to get description of those fields to use
for DBGrid column caption instead of field name.

Francesco


Back to top
Display posts from previous:   
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> C++ Builder Databases (ADO) All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2006 phpBB Group
SEO toolkit © 2004-2006 webmedic.