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
(162 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
(126 Views)

Yes, it works

 

Thank you!

0 Kudos
Message 3 of 3
(108 Views)