SQL Query - Data Table name is not set

Sean McClurkan

January 22, 2015 03:02

Essentials 4.2.3  HTML5 2.3.1  Workflow Designer 4.2.0

I'm using the SQL Query activty but get the error - Data Table cannot be serialized. Data Table name is not set.

I don't see anywhere to set this value on the activity.  Can anyone guide me in where i can set this value?

0

• 

  Permanently deleted user

  January 22, 2015 03:13

  You need to assign the DataTable Name to avoid the issue.

  If you assign the result of the SQLQuery activity as a variable named 'dtResult'.

  Add a Assign activity after 'SQLQuery' activity, and dtResult.TableName  whose value is whatever you want to assin (hardcoded string, or a a variable configured itas default value.

  I remember this forum discussed before, but can't find easily enough so I am writing here again.

  Munhwan 

  0
• 

  Sean McClurkan

  January 22, 2015 04:45

  Thanks!  That worked.  

  0

Please sign in to leave a comment.