🚀 go-pugleaf

>   1. Is it possible to detect the fields of a given table at run time?
>      You ask the user for a table in the database, and user gives you
>      a table name, say "employee".  And your code should detect the
>      field names of this table (for ex: your code should say that this
>      table has "emp_id" and "emp_name" fields.
>
Try the TTable.GetFieldNames method to get a list of names.

>   1. Using the pre-learned fields of a table, the code should be able
>      to make a query in the database. If you can get the field name as
>      strings, can you locate these string in any queries. (at run
>      time)
>
Locate? You can create a query at run time.  Is that what you mean?  See
http://www.dejanews.com for examples on basic query building.

>   1.
>   2. Can I say, "Create a data label with the source of it pre-learned
>      table and releated field"?
>
Hook up a datasource to the ttable in question.  Create the TdbText, set
its datasource and datafield properties.  That should work.

> Actually I want to let the user to select the table and the fields to
> be used in my application as data. Maybe there is another solution for
> this instead of the above tech.
>

Probably about a million ways! :-)

DMGoncalves