Prev: just switch channels of Keithley 7700
Next: Set XY Graph Y-Auto Scale
From: David Crawford on 22 Dec 2006 03:10
Hugo
The llb you posted cannot be loaded. Can you fix that and I will take a look at it with you?
<img src="http://forums.ni.com/attachments/ni/170/221651/1/error.jpg">
DavidMessage Edited by David Crawford on 12-22-2006 07:50 AM


error.jpg:
http://forums.ni.com/attachments/ni/170/221651/1/error.jpg
From: David Crawford on 22 Dec 2006 04:40
Hugo
I forgot to say that&nbsp;you&nbsp;should to do a File -&gt; Save with Options -&gt; Development Distribution NOT Application Distribution as this strips the diagrams out of the VIs. That will get your llb into the right format.
<img src="http://forums.ni.com/attachments/ni/170/221664/1/devdist.jpg">
David
Message Edited by David Crawford on 12-22-2006 09:32 AMMessage Edited by David Crawford on 12-22-2006 09:32 AM


devdist.jpg:
http://forums.ni.com/attachments/ni/170/221664/1/devdist.jpg
From: hugoliang on 22 Dec 2006 04:40
Thank you.
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?
Thank you.
&nbsp;
&nbsp;
&nbsp;
Hugo
From: hugoliang on 22 Dec 2006 05:40
Thank you.
I am sorry that I don't understand the difference between the two format.
Try this one.
Thank you again.
&nbsp;
&nbsp;
Hugo


mdb.llb:
http://forums.ni.com/attachments/ni/170/221667/1/mdb.llb
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&nbsp;tablename&nbsp;(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
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: just switch channels of Keithley 7700
Next: Set XY Graph Y-Auto Scale