Rookie Labview Question

[StavA]

Hello again,

I'm trying to modify one row in my database VI, and have been having difficulty.

The first image (modifysimplesingle) shows the update database working properly, however i don't want to just change one column value. I read the help document on the update data VI, which led me to believe it's possible to input a cluster to update the entire row.

So i attempted this (modifysimplecluster), and have yet to achieve success. Am i misreading this? I also looked at the example provided by Labview, copying their syntax. If i am wrong, what would be the best way to modify a single row, provided that there are primary keys, and foreign keys at times (If that makes a difference).

[Thoric · Accepted solution]

It looks like you're providing the data but not the names of the columns. Provide a string array to input columns so that the function knows which columns to apply the data to.

[StavA]

Indeed, i saw my mistake a few minutes earlier. I kept trying to wire no column input as i thought it worked similiar to inserting a new entry into the table, where if you don't specify a column but input a cluster it updates every column in that row. Thanks for your reply!

[aputman]

The first problem I see is you have quotes around your userid.  If your userid values are indeed numeric, do not use strings.  String comparison takes much longer to complete.

Next, it might be easier to understand what your doing if you format your own SQL query like this and use the Execute query VI: