ni.com is currently undergoing scheduled maintenance.

Some services may be unavailable at this time. Please contact us for help or try again later.

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
(3,120 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
(3,102 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
(3,082 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
(3,062 Views)