SQL - ExecuteTable - change colname

Discussion in 'Questions (Windows Mobile)' started by michael2007, Apr 16, 2008.

  1. michael2007

    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
     
  2. willisgt

    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
     
  3. michael2007

    michael2007 New Member

    Gary,
    thank you for your help,
    works perfect.

    Regards
    Michael
     
Loading...