LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

delete row of other column except first column using labview database Connectivity tool

My Database have 7 columns in total.I want to delete row of other columns except the first column. In short I want the first column Unaffected when I'm doing delete operation. Is it possible to do?

If yes kindly help me with solutions.

Thanks in advance.

0 Kudos
Message 1 of 3
(1,785 Views)

hey 

I'm also doing the same exercise but here i want to delete a row of selected columns only..for eg:

if my table have 3 three columns col_0 = Sr no , col_1= Name and col_2= id number; so i have to delete only rows of col_1 and col_2 not col_0. Is it possible with database connectivity tool in labview. If so Please help me to find solution.

0 Kudos
Message 2 of 3
(1,734 Views)

Are you wanting to modify the data in the database or modify the table structure to remove the columns?  The only way that I know where you can delete columns of data is to set the value to NULL or 0 or ''(empty string), etc. 

 

UPDATE table_name SET column = 0 (or NULL or "") WHERE filter_column = some_value

 

aputman
------------------
Heads up! NI has moved LabVIEW to a mandatory SaaS subscription policy, along with a big price increase. Make your voice heard.
0 Kudos
Message 3 of 3
(1,680 Views)