SQL - ExecuteTable - change colname

M

michael2007

New Member
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
 
W

willisgt

Active Member
Licensed User
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
 
You must log in or register to reply here.
Top