7 Replies Latest reply on Dec 7, 2017 11:28 AM by dking RSS
    yanfeim Newbie

    service type of SQL(command) cannot handle INFOTABLE parameters.


    I'm writing a Database connection thing to insert data into my local database. I have a service type of SQL(command) accepting type INFOTABLE parameter. But Thingworx complains when using fields of this parameter: 

    Error executing SQL command. ERROR: ERROR ERROR: syntax error at or near "["; Error while executing the query

    The way I'm inserting the record is like this: 

    insert into myTable values ([[myInfotable.recordOne]], [[myInfotable.recordTwo]]);

    When breaking the INFOTABLE into a list of parameters, this way of insertion works just fine.

    Can you guys help? Thanks a lot.