SQL - ExecuteTable - change colname

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

  1. michael2007

    michael2007 New Member


    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
    I would like to do something like this
    table1.colname("field1") = "CatalogID"

    Thanks for you help.

    Best Regards

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


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

    Everything else remains the same.

  3. michael2007

    michael2007 New Member

    thank you for your help,
    works perfect.

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice