SQL - ExecuteTable - change colname

[michael2007]

Hello,

does anybody know if it is possible to change the colname after
using command ExecuteTable ?
When I'm using e.g. cmd.ExecuteTable("table1",500)
I get the column names like the fieldnames in the database table
defined.
I would like to do something like this
table1.colname("field1") = "CatalogID"

Thanks for you help.

Best Regards

Michael

[willisgt]

I dont' think this is possible (although some of the true gurus here probably know some manner of black magic that could make it happen...)

Alternatively, you could specify the column name as part of the query. Instead of:

SELECT field1,field2,field3 FROM database WHERE...

try

SELECT field1 'Product Name', field2 'Supplier', field3 'Price' FROM database WHERE...

Everything else remains the same.


Gary

[michael2007]

Gary,
thank you for your help,
works perfect.

Regards
Michael