• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 176
  • Last Modified:

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

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
joelsilva
Asked:
joelsilva
  • 9
  • 9
1 Solution
 
esoftbgCommented:
> 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
 
joelsilvaAuthor Commented:
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
 
esoftbgCommented:
What of kind is your database ?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
joelsilvaAuthor Commented:
Microsoft Access and Firebird 1.5 (i need implement that in these two databases).
0
 
esoftbgCommented:
It is possible with Firebird database.... (and may be with MS Access), but I know the way about Firebird
0
 
joelsilvaAuthor Commented:
Ok... I will be very glad if you show me how to implement that with Firebird!
0
 
esoftbgCommented:
Would you provide me your database, or it is enough to make an example with my database ?
0
 
joelsilvaAuthor Commented:
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
 
esoftbgCommented:
Do you need an example, or just explanation ?
0
 
joelsilvaAuthor Commented:
Could be a example.
0
 
esoftbgCommented:
Ok. I am starting to develop it with my database....
0
 
joelsilvaAuthor Commented:
Thank you very much friend!!!!!!
0
 
esoftbgCommented:
Please give me an e-mail address to provide you the successful example
0
 
joelsilvaAuthor Commented:
Oh man... Thank you very much again... You could send to mack@cordeirorodrigues.com.br o joel@cordeirorodrigues.com.br

:)
0
 
esoftbgCommented:
I was sleep an hour....
I just sent a Q_21093547.zip file attached into an e-mail to mack@cordeirorodrigues.com.br
0
 
joelsilvaAuthor Commented:
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
 
esoftbgCommented:
joelsilva,
you are welcome !
Glad to help you !
0
 
joelsilvaAuthor Commented:
Thank you man!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 9
  • 9
Tackle projects and never again get stuck behind a technical roadblock.
Join Now