A question about LabSQL.
in [LabView]
|
From: hugoliang on 21 Dec 2006 04:40 Dear All, I want to learn SQL and have just download LabSQL. But I have found that some vi is lost, such as,ADO Recordset Addnew.vi and ADO Set Field Value.vi. I have tried to use Invoke Node to do the Addnew task and it can work well. But I don't know how about Set Field Value. Please give some suggestion. Thank you. Hugo.
From: David Crawford on 21 Dec 2006 05:10 Hi Hugo They are not in my LabSQL install either, so I am not sure what you mean. Do you mean that these are functions you would like to have seen included in the LabSQL zip file but they are not there. If I am understanding you then:- If you want to add a new record then it would be an INSERT query. If you want to update a field within a record then you would use an UPDATE query. using SQL Execute.vi Does that help? David
From: hugoliang on 21 Dec 2006 20:10 Thank you for your reply. I am sorry to say that my English is not good and I began to learn SQL yesterday.:( I have just learn how to use LabVIEW to add data to database from book step by step. And I can't to find ADO Recordset Addnew.vi and ADO Set Field Value.vi.(Someone said it can be found in Labview6.1) I tried to use Invoke Node to replace ADO Recordset Addnew and it can work. But I don't know how to replace ADO Set Field Value. The vi is attached. Thank you. <img src="http://forums.ni.com/attachments/ni/170/221625/1/12.jpg"> Hugo???hugoliang?12-21-2006 07:05 PM????? 12.jpg: http://forums.ni.com/attachments/ni/170/221625/1/12.jpg
From: hugoliang on 21 Dec 2006 21:10 Oh,Thank you. I will learn the example. Thanks. Hugo
From: hugoliang on 22 Dec 2006 02:40 Hi, I have just draw a vi using LabSQL and it can't work. warning is grammer is wrong. Could you tell me why? Thank you. Hugo mdb.llb: http://forums.ni.com/attachments/ni/170/221645/1/mdb.llb
|
Next
|
Last
Pages: 1 2 3 Prev: just switch channels of Keithley 7700 Next: Set XY Graph Y-Auto Scale |