update using DB Tools execute query

[Soundarya]

hi,

thanks for showing me the way to insert values to a database. but i am finding some problem with update. as i already mentioned, according to the values given to the string controls on the front panel, the values should get updated.

if records of the table in the database is empty, then insert. otherwise update the values.

how can i do this in labview?

Thanks in Advance

Regards

Soundarya

[Dennis_Knutson]

I'm not sure I understand your reasoning. If the table is empty or not, you use Insert to add a new record. You use update to modify an existing record. If you can't get an update to work, then my guess is that your where clause is incorrect or the row(s) you are trying to modify do not exist. Why do you even want to do an update?