Database command does not appear to be executing from the execute iterative

Hello easymorph community.

I have created a project that

  1. reads a table from database (Carmendw)
  2. add some more columns and some filters to get the easymorph table to align with the parameters of a module
  3. then I pass the easymorph table values to the easymorph module.
  4. the module calls a stored procedure in another database (accellos).

Here is the issue. When I run the module manually it works fine. The stored procedure executes and confirms the connector and parms works for custom sql. See below.

However no matter what I do, I am not able to pass the row of a table one row at a time to the stored procedure.

What I am doing wrong.

Here is the call to the module

Again, just looking to see what I am doing wrong.

The module has all the parms needed for the stored procedure and it works fine if I run it manually from within the module.

However when I call it as an iterative command, nothing appears to happen

This ticket and topic is closed. The date format of the stored procedure was the issue, I had to do an action "convert data type" to force it to text for the stored procedure wanted everything in text.

Working beautifully now and much more efficient then the previous approach.

1 Like