A question about LabSQL.

[hugoliang]

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.

[DavidJCrawford]

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

[hugoliang]

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

[hugoliang]

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时编辑过了

[Dennis_Knutson]

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.

[hugoliang]

Oh,Thank you.

I will learn the example.

Thanks.

Hugo

[hugoliang]

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

[DavidJCrawford]

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

[hugoliang]

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

[DavidJCrawford]

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

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