Jump to content

Updating Row SQLSERVER


danfergarc

Recommended Posts

Hi, I am updating a table with the elements I show you below:

pnqvtiV0p

I am updating 4 those rows with my job:

poM2QLCFp

As you can see, I have an infinite loop which is updating all the time the rows I showed you before. I am doing this fine with mysqlserverinput connection, using the option : "update".

MY PROBLEM is that I am updating all the time, even when I have no values. What I want to do is doing a condition that just updates a row when I have some values in there.  For example, If I have

id_machine=123 

I want it to remains "123" until I have some value to add, not when I have "blank or null".

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...