6 Replies Latest reply on Oct 10, 2017 5:31 AM by lshihao RSS
    yanfeim Newbie

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

    Hi,


    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.