1 Reply Latest reply on Jan 17, 2018 12:17 PM by aseaton Branched from an earlier discussion. RSS
    aseaton Apprentice

    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