LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Displaying, deleting and updating the table extracted from Microsoft SQL Database in LabVIEW

Solved!
Go to solution

I have table in my SQL database which I am displaying through table indicator in Labview. The table is shown below:

qureshi000_0-1717651733845.png

As you can see I added the button Delete and Update. I want to add these feature. I should be able to select any row based on its ID and delete it by clicking on delete button after selection of it on table indicator and I should be able to edit only already present rows and table should be updated upon clicking on update button. The table should be updated both in Labview table indicator display and in SQL database. This all should happen while code in running.
I am using event structure to do it. How I am displaying the table in Labview is shown in the figure below:

qureshi000_1-1717652404334.png

0 Kudos
Message 1 of 3
(379 Views)

What is your question? I don't know what issue you are having

0 Kudos
Message 2 of 3
(297 Views)
Solution
Accepted by topic author qureshi000

You need to build the SQL call as you press the buttons and your code execute. On the appropriate Event structure you will be able to retrive the information you need to build your SQL Command. 

0 Kudos
Message 3 of 3
(290 Views)