From 04:00 PM CDT – 08:00 PM CDT (09:00 PM UTC – 01:00 AM UTC) Tuesday, April 16, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

how to remove only one row from the database using labview6.1

using labview 6.1 I create a table with various rows and columns and store bulk of data's in them.,, what procedure should I follow to remove only one paticular row from the database? Help me out with an example please,,
Thanking you in advance!
0 Kudos
Message 1 of 5
(3,732 Views)
Hi,

If you have the database toolkit you can delete a row using just a SQL Query to "DB Tools Execute Query.VI"
Example:
DELETE FROM Table name Where SerialNum='Value' And Date='Value' And Time='Value'

See also attached VI
Best Regards

Johan
Message 2 of 5
(3,732 Views)
Thanks for your suggestion! I'm able to solve my problem,,
-Lalitha
0 Kudos
Message 3 of 5
(3,732 Views)

Hi lalitha,

 

 

 how to remove database row if you have any vi please post here .

 

 

 

Thanks advance...

 

Regards

Arunkumar

India

0 Kudos
Message 4 of 5
(3,199 Views)
1. This is an 11 year old thread
2. This is already answered in your other post

Mike...

Certified Professional Instructor
Certified LabVIEW Architect
LabVIEW Champion

"... after all, He's not a tame lion..."

For help with grief and grieving.
0 Kudos
Message 5 of 5
(3,168 Views)