Handling NULL values with database connectivity toolkit

[Aleeex07]

Hi,

I read a lot of articles about problems with inserting null values into database throught labview but can´t found the best solution.

In my database sometimes I don´t have to fill all the columns with data (f.e. the person doesn´t want to allow some personal information). So in that case i have to insert Null value.

Here is a modified small part of code where i´d like to learn how to handle this problem.

Thank you for your help 

[jeffneuner]

check your optional field items to see if any of them are empty strings... if so, replace the empty strings with the word "NULL".  This should work for MS Access and SQL Server.

of course, your database table fields must also be able to accept NULL values

[Aleeex07]

I tried the solution, but as I expected, it didn´t work. The personal identity column is set to number, so it doesn´t accept the NULL value as a string. Is there any other option? This column accept Null values.

[Yamaeda]

Set it to -1

/Y

[sletrab]

There is a VI "DB Tools NULL.vi" try this VI.