Problem With DB Insert VI

[The-Dude]

Hello Forum,

i have an strange behavior i can`t explain. I try to write some info's in a SQL Database.

If i use the SQL Execute VI it works fine, but if i use the Insert VI, that i would prefer, the error 1 occurred.

Can someone help me to get the failure? 

Thanks a lot!

Tim

[pincpanter]

A first problem is that you cannot set UniqueID since it's AUTOINCREMENT, thus automatically managed by the RDBMS. In any case, it's not a text.

[The-Dude]

Thanks for replying!

I would like that the first row "UniqueID" will get automatically filled out with the next UInt number by the DatabaseEngine.

But when I only insert one value, for Example the "BauteilKategorie" an error occurred.

My wish is, that i provide "BauteilKategorie" Line 2 till "Besitzer" Line 8 and the Database engine will fill out "UniqueID" automatically.

Best Regards

Tim