🚀 go-pugleaf

"nick" <nileiqi@hotmail.com> wrote in message 
news:47b24220$1@newsgroups.borland.com...

> How to read table's column name in database ? I think there is a way to do
> it.

If you want to get a table's column names then you can use the OpenSchema() 
method.  Its use is a little convoluted but once you understand how to use 
it all will be clear.  Here is an example:

  TADODataSet* dataSet = new TADODataSet(NULL);
  Variant columns[] = { Null(), Null(), WideString(tablename) };
  ADOConnection1->OpenSchema(siColumns, VarArrayOf(columns, 2),
    EmptyParam, dataSet);
  // iterate the dataset
  delete dataSet;

The result will have a bunch of fields describing almost everything you'll 
need to know about each column.  Each column is another record in the 
dataset.

VarArrayOf is a VCL function that creates a Variant Array from a simple 
array of variants.  The first parameter is the array and the second is the 
count minus 1.  EmptyParam is defined in <OleCtrls.hpp>.

Each query type that can be queried via OpenSchema expects a different 
number of constraints.  You can see a list for each (in the native ADO 
format) at:

  http://www.devguru.org/technologies/ADO/8548.asp

HTH,
Clayton