topic Re: A question about LabSQL. in LabVIEW

A question about LabSQL.

hugoliang — Thu, 21 Dec 2006 09:12:32 GMT

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.

Re: A question about LabSQL.

DavidJCrawford — Thu, 21 Dec 2006 09:43:03 GMT

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

Re: A question about LabSQL.

hugoliang — Fri, 22 Dec 2006 01:02:37 GMT

帖子被hugoliang在12-21-2006 07:03 PM时编辑过了

Re: A question about LabSQL.

hugoliang — Fri, 22 Dec 2006 01:02:52 GMT

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.

Hugo

帖子被hugoliang在12-21-2006 07:05 PM时编辑过了

Re: A question about LabSQL.

Dennis_Knutson — Fri, 22 Dec 2006 01:14:17 GMT

What exactly are you trying to do? Are you trying to retrieve data (as the select statement implies) or are you trying to add data to an existing table? If you are doing either, you should look at the shipping examples called Example - Fetch a Table or Example - Insert into a Table. With both of those, after you make the connection, you just need the SQL Execute function. It looks like you are making it more much more complex than it needs to be.

Re: A question about LabSQL.

hugoliang — Fri, 22 Dec 2006 01:41:03 GMT

Oh,Thank you.

I will learn the example.

Thanks.

Hugo

Re: A question about LabSQL.

hugoliang — Fri, 22 Dec 2006 07:20:27 GMT

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

Re: A question about LabSQL.

DavidJCrawford — Fri, 22 Dec 2006 07:46:55 GMT

Hugo

The llb you posted cannot be loaded. Can you fix that and I will take a look at it with you?

David

Message Edited by David Crawford on 12-22-2006 07:50 AM

Re: A question about LabSQL.

hugoliang — Fri, 22 Dec 2006 09:29:22 GMT

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.

Hugo

Re: A question about LabSQL.

DavidJCrawford — Fri, 22 Dec 2006 09:30:47 GMT

Hugo

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.

David

Message Edited by David Crawford on 12-22-2006 09:32 AM

Re: A question about LabSQL.

hugoliang — Fri, 22 Dec 2006 10:27:35 GMT

Thank you.

I am sorry that I don't understand the difference between the two format.

Try this one.

Thank you again.

Hugo

Re: A question about LabSQL.

Dennis_Knutson — Fri, 22 Dec 2006 14:12:48 GMT

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.

Re: A question about LabSQL.

DavidJCrawford — Fri, 22 Dec 2006 14:50:53 GMT

Hugo

Here is a zip file that contains an access database, the udl file and a labview example that demonstates using INSERT, SELECT and UPDATE queries.

Edit: Just realised that you will need to double click the udl file and change the path to where hugo.mdb is like this

David

Message Edited by David Crawford on 12-22-2006 02:54 PM

Message Edited by David Crawford on 12-22-2006 02:56 PM

Re: A question about LabSQL.

hugoliang — Sat, 23 Dec 2006 07:18:17 GMT

David Crawford and Dennis Knutson,

Thank you very very much for your help.

After reading your example vi, I begin to understand how to use SQL to solve the problem of database.

Thanks.

Hugo