From: David Crawford on 22 Dec 2006 03:10
The llb you posted cannot be loaded. Can you fix that and I will take a look at it with you?
DavidMessage Edited by David Crawford on 12-22-2006 07:50 AM
From: David Crawford on 22 Dec 2006 04:40
I forgot to say that you should to do a File -> Save with Options -> Development Distribution NOT Application Distribution as this strips the diagrams out of the VIs. That will get your llb into the right format.
Message Edited by David Crawford on 12-22-2006 09:32 AMMessage Edited by David Crawford on 12-22-2006 09:32 AM
From: hugoliang on 22 Dec 2006 04:40
I don't know why it can't be loaded.
I have just installed LabSQL and use LabVIEW 7.1.
Is it the reason of LABSQL or LABVIEW7.1? How to fix it?
From: hugoliang on 22 Dec 2006 05:40
I am sorry that I don't understand the difference between the two format.
Try this one.
Thank you again.
From: Dennis Knutson on 22 Dec 2006 09:40
You said you would look at the examples but it is pretty obvious that you didn't. You have a SQL SELECT statement that implies you are trying to read all of the columns of the db. Then you have a bunch of strings that I think you are trying to add to the db. None of this is correct. To repeat what I said before, look at the shipping examples. If you want to insert data, then after the Open Conn function, use a SQL Execute function with a statement like:
INSERT INTO tablename (column1name, column2name, column3name)VALUES ('A', 'B', 'C');
where column1 name, etc. is the actual names of the columns in your database and tablename is the actual name of the table in your database.
Here's one of the shipping examples modified to the correct format for inserting 16 columns of data as you have. Replace with the name of your table and your column names. Also spend a little time studying SQL before trying anything.
Modified Example - Insert into a Table.vi:
http://forums.ni.com/attachments/ni/170/221688/1/Modified Example - Insert into a Table.vi