Solved

How can  I show, in a DBGrid, the name, fields and fields properties of my DATABASE?

Posted on 2004-08-13
18
165 Views
Last Modified: 2010-04-05
Hello folks,

Any of you imagine how can i show, in a DBGrid (or in other object) the:
1) Name of my database tables;
2) The fields of a selected table;
3) The fields properties of a selected table.

More clearly: first i need show the name of my tables (for example, table A, table B and table C).
After, if the user click in a TABLE NAME (for example, table A), the DBGrid shows that table fields and the properties of it field.

I will be very glad if anyone could solve this question.

Best Regards.
0
Comment
Question by:joelsilva
  • 9
  • 9
18 Comments
 
LVL 12

Expert Comment

by:esoftbg
ID: 11798632
> Any of you imagine how can i show, in a DBGrid (or in other object) the:
> 1) Name of my database tables;
> 2) The fields of a selected table;
> 3) The fields properties of a selected table.

I know how to show in a DBGrid The fields and values of a table:
Just put into the DBGrid's property DataSource a DataSource name to the Table or Query which will connect to desired Table into database. After activation of the Table or Query, you will see fields and values of a table by DBGrid ....
0
 

Author Comment

by:joelsilva
ID: 11798636
Thx. for your comments,

Ok with the FIELDS, but i didn´t want to see the FIELD´s VALUES but the FIELD´s PROPERTIES (for example, VARCHAR, AUTOINC, etc.)
0
 
LVL 12

Expert Comment

by:esoftbg
ID: 11798687
What of kind is your database ?
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:joelsilva
ID: 11798694
Microsoft Access and Firebird 1.5 (i need implement that in these two databases).
0
 
LVL 12

Expert Comment

by:esoftbg
ID: 11798712
It is possible with Firebird database.... (and may be with MS Access), but I know the way about Firebird
0
 

Author Comment

by:joelsilva
ID: 11798735
Ok... I will be very glad if you show me how to implement that with Firebird!
0
 
LVL 12

Expert Comment

by:esoftbg
ID: 11798740
Would you provide me your database, or it is enough to make an example with my database ?
0
 

Author Comment

by:joelsilva
ID: 11798752
Feel free to do it with your own database (there is no difference for me). I think that i will understand your example (if you think not, tell me pls.)
0
 
LVL 12

Expert Comment

by:esoftbg
ID: 11798758
Do you need an example, or just explanation ?
0
 

Author Comment

by:joelsilva
ID: 11798777
Could be a example.
0
 
LVL 12

Expert Comment

by:esoftbg
ID: 11798782
Ok. I am starting to develop it with my database....
0
 

Author Comment

by:joelsilva
ID: 11798784
Thank you very much friend!!!!!!
0
 
LVL 12

Expert Comment

by:esoftbg
ID: 11799161
Please give me an e-mail address to provide you the successful example
0
 

Author Comment

by:joelsilva
ID: 11800207
Oh man... Thank you very much again... You could send to mack@cordeirorodrigues.com.br o joel@cordeirorodrigues.com.br

:)
0
 
LVL 12

Accepted Solution

by:
esoftbg earned 25 total points
ID: 11800352
I was sleep an hour....
I just sent a Q_21093547.zip file attached into an e-mail to mack@cordeirorodrigues.com.br
0
 

Author Comment

by:joelsilva
ID: 11800361
Man, i dont have words to tell you!!! Accept my THANX...

It´s exactly what i need to implement.

Best regards... (I will send you an e-mail.)
0
 
LVL 12

Expert Comment

by:esoftbg
ID: 11800388
joelsilva,
you are welcome !
Glad to help you !
0
 

Author Comment

by:joelsilva
ID: 11800396
Thank you man!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Help on project with Soap 10 61
How to save the image in the .cds File ClientDataSet? 1 28
Typecasting TBytes to Integer in Delphi XE8 2 32
Broadcast a message using ICS 2 20
This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question