LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Error 0x00000001 with Database Conectivity Toolkit

I have mi table in MySQL, mi conection is ok, I can see the data in every table, but, when I want insert value in database in array form, I can't...

How I need insert this values in every columns except in the first one, this is the ID and is Autoincrement, i dont want put anything there...Screenshot_2.png

0 Kudos
Message 1 of 4
(2,491 Views)

This error is correct you are passing 3 columns and specifying that 4 columns are expected in the insert.

you need a different insert.

INSERT INTO preuba (column2, column3, column4) VALUES (val2, val3, val4)

Paul Falkenstein
Coleman Technologies Inc.
CLA, CPI, AIA-Vision
Labview 4.0- 2013, RT, Vision, FPGA
0 Kudos
Message 2 of 4
(2,473 Views)

You rigth! My error was not puting in "0" the first value for the autoincrement. I use the query INSERT INTO blabla VALUE (0,"VAL1","VAL2",..."VALN"), thanks for the help...

0 Kudos
Message 3 of 4
(2,453 Views)

Glad it worked.  Actually the error messages from the DB toolkit are very good, much better than most code I see.  I was able to learn most of my database from the error messaged on the toolkit. 

Paul Falkenstein
Coleman Technologies Inc.
CLA, CPI, AIA-Vision
Labview 4.0- 2013, RT, Vision, FPGA
0 Kudos
Message 4 of 4
(2,433 Views)