1 Reply Latest reply on Jun 12, 2017 6:36 AM by supandey Branched from an earlier discussion. RSS
    aseaton Explorer

    Trying to use string input in my query to return the columns based on the tableName input provided but i'm seeing error

    I'm trying to use a string input in my query to return the columns based on the tableName input provided but i'am  seeing this error result and here is my script:

     

    query script.PNG

    error message for database columns script with input.PNG

    When the query service is called with the input the query executed looks like:

     

    query for columns script.PNG

    and so i think this syntax should be correct. Any advice on this?

     

    Thanks

     

    Message was edited by: Sushant Pandey branched from https://community.thingworx.com/message/59921#59921 as new question