Failing to insert a single row in a Table..

Replies to This Discussion

Permalink Reply by Nathan Miller on August 13, 2011 at 7:47pm

Hello Stan,

I see you are grafting your inputs to the SQL Format Rows component.  Since you are supplying a single row, the merged list will work just fine.  No grafting necessary...

 

For example:

If you have a list that looks like this...

    0.  mesh_FromPoints

    1.  7.0

    2.  11.0

 

The SQL Format Rows will simply format the list items into a single string separated by commas:  "mesh_FromPoints, 7.0, 11.0"

 

If you want to have multiple rows in a similar format, you will want to input a data tree that looks like...

 

     {0}

          0.  mesh_FromPoints1

          1.  7.0

          2.  11.0

    {1}

          0.  mesh_FromPoints2

          1.  5.0

          2.  20.0

    {2}

          0.  mesh_FromPoints3

          1.  20.0

          2.  8.0

 

In which case the SQL Format Rows will give you a list of strings...

 

     0.  "mesh_FromPoints, 7.0, 11.0"

     1.  "mesh_FromPoints, 5.0, 20.0"

     2.  "mesh_FromPoints, 20.0, 8.0"

 

Hope this helps...

 

Nathan