Skip to Content
avatar image
Former Member

Update SQL query working in transaction but not in database

Hi Everyone,

I am encountering a strange issue in MII, the update query action block in a transaction is working; but in the database it is inserting NULL in the columns. The values returned from the update query action block is correct- but for some reason on, on executing the transaction, the updated values are not seen in the database but NULL. I did try deleting the action block and configuring it again- still the same issue persists.

My update query is of the form:-

UPDATE   TABLE  

SET A= '[Param.4]' , B= '[Param.5]', B= '[Param.6]', D= '[Param.7]', E= '[Param.8]', F= '[Param.9]'

WHERE G= '[Param.1]'

and H= '[Param.2]'

and I= '[Param.3]'

and J= '[Param.10]'

and K= '[Param.11]'

Has anyone faced this issue? How can I resolve the issue? Any suggestions/insights are highly appreciated

Thanks

Rajeev

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 08, 2015 at 08:45 AM

    Hi Rajeev,

    How are you assigning the parameters?

    Also, have you set Auto-Type Parameters to true in the query?

    Regards,

    Swaroop

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 08, 2015 at 10:32 AM

    Hi Swaroop,

    Issue resolved, it was data format issue.

    Regards

    Add comment
    10|10000 characters needed characters exceeded