Database Connectivity Toolkit (multi row insert)

[Sam_Sharp]

Also - you can do this as a single insert - like this:
INSERT INTO table (value,name) VALUES (1.123,Temp1), (2.123,Temp2), (5.1235,Temp3);

[Emidpont]

Hello aputman,

I've tried what you suggested but unfortunately it didn't work and I still get the same error.

As for what you suggested Sam, I can't do that because my values are generated by the DaqAssistant.

[pincpanter]

I never tried the syntax suggested by Sam, but certainly you can reproduce it modifying the code in your loop.

The string "INSERT INTO table (value,name) " should be injected into the shift register, then you should add your value pairs properly.

[Sam_Sharp]

You have misunderstood what I suggested, in your for loop, you generate N queries (one for each channel). Instead of that, generate a single query with N VALUE sections, like this:

 It has the exact same structure as your existing code but does the inserts in a single query.

[Emidpont]

I'm sorry I didn't understand you at the beginnig, I tested that and I have the same string query as you showed me. But now I have an error that says that "Column count doesn't match value count at row 1". I'd like to inform you that my database table has two columns (value & channels).

[Yamaeda]

Try your question in the database, e.g. SQL manager, and/or build the question there as a reference to how you need to formulate it in LV.

/Y

[Emidpont]

It seems like the decimal separator where the problem was, I added %.; to my query and now it works.

Thank you so much for your help, I really appreciate.

[aputman]

---

@AhciaDa wrote:

Hello aputman,

I've tried what you suggested but unfortunately it didn't work and I still get the same error.

As for what you suggested Sam, I can't do that because my values are generated by the DaqAssistant.

---

Well, of course it won't work if you don't incorporate all of the advice you have been given.  

[Emidpont]

I did incorporate them and it works well now.

Thank you very much.

[ganquetil]

Hello,

I try to insert multiple values in .mdb database using standard microsoft jet oledb connection.

My query is:

INSERT INTO T_Column (C_Name)

VALUES ('1') , ('2');

I use NI_Database_API.lvlib: DB Tools Execute Query.vi

I get the error -2147217900: "

L'erreur -2147217900 s'est produite à : NI_Database_API.lvlib:Conn Execute.vi->Add_Multiple_Columns_onDatabase.vi->Test_Create_big_database_optim.vi

Raisons possibles :
ADO Error: 0x80040E14
Exception occured in Microsoft JET Database Engine: Point-virgule absent à la fin de l'instruction SQL. dans NI_Database_API.lvlib:Conn Execute.vi->Add_Multiple_Columns_onDatabase.vi->Test_Create_big_database_optim.vi"

It indicates that the semicolon character is missing in the query...

I think that I can not execute multiple query because the request below works:

INSERT INTO T_Column (C_Name)

VALUES ('1') ;

What do I have to do to correct this?

I really need help urgently! Thanks for your help!