How to get field despcription??

Thread View: borland.public.cppbuilder.database.ado

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Francesco Fri, 09 Dec 2005 09:50

#566

Author: Francesco
Date: Fri, 09 Dec 2005 09:50

10 lines
1222 bytes

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

Re: How to get field despcription??

#567

Author: Francesco
Date: Fri, 09 Dec 2005 12:55

19 lines
1340 bytes

Solved using the procedure fn_listextendedproperty

	thanks anyway, Francesco



Francesco wrote:

> 
> 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads