07-13-2007 02:43 AM
07-13-2007 03:28 AM
That's not an insert but an update command and the toolkit does not have a VI for doing it.
If you want, you can modify the insert VI to be an update VI. You will need to modify the VI that creates the initial parameterized query and then add a condition in the end.
An example for what the parameterized query should look like: update TableX set temp=? where Batch_No=AB1234 AND sample_no=1
07-13-2007 04:46 AM
Could you please explain me in detail ? i am just beginer.
If possible, please get me a example. Because i have some other dat in same record set which should not change.
1. need to find the record set which is having Batch_no = x and sample_no=y
2. then update the value of temp. (it should not impact my other data such as date& time, Lot_no.)
plz send one example.
thanks in advance
karthik
07-13-2007 04:46 AM
Could you please explain me in detail ? i am just beginer.
If possible, please get me a example. Because i have some other dat in same record set which should not change.
1. need to find the record set which is having Batch_no = x and sample_no=y
2. then update the value of temp. (it should not impact my other data such as date& time, Lot_no.)
plz send one example.
thanks in advance
karthik
07-13-2007 05:31 AM
Here is a very simplistic example which simply builds an SQL query. I didn't test it and it's even possible that it is wrong and that I missed something.
I suggest you search for some tutorials about SQL and how to work with DBs.
To learn more about LabVIEW, I suggest you try searching this site and google for LabVIEW tutorials. Here, here, here, here, here and here are a few you can start with and here are some tutorial videos. You can also contact your local NI office and join one of their courses.
In addition, I suggest you read the LabVIEW style guide and the LabVIEW user manual (Help>>Search the LabVIEW Bookshelf).
07-13-2007 06:45 AM
Thank you very much.
i did and tested successfully.