From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

SAPHIR - Toolkits Discussions

cancel
Showing results for 
Search instead for 
Did you mean: 

Saphir mySQL toolkit DROP statement

I'm using the Saphir mySQL toolkit, can anyone tell me how to use a DROP tablerow statement, which VI do I use?

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

Hi hansie,

 

Do you want to delete a row in a table or drop a table ?

In the first case, you have "Execute sql query" functions you can use. You will have to specify your sql query (https://www.w3schools.com/sql/sql_delete.asp)

In the second case, you have a drop table function to drop the whole table.

MountainClimber_0-1615450195197.png

 

 

Hope this helps !

Christophe | qmt | Certified LabVIEW Architect
0 Kudos
Message 2 of 3
(1,635 Views)

Yes, it works

 

Thank you!

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