JDP Science Tools

cancel
Showing results for 
Search instead for 
Did you mean: 

SQLite Insert empty string with parameter(s)

I am trying to implement a parameterized INSERT statement with two columns that are text.  When I pass an empty string for the parameter, it inserts a NULL and not an empty string into the table.

Is there something I need to setup to have empty strings insert as empty strings and not NULL?

0 Kudos
Message 1 of 3
(4,539 Views)

I found that changing the "Call Library Function" for sqlite3_bind_text in the "Bind Text.vi" to type array of U8 and set minimum size to "Number of Bytes" input it will insert an empty string.

paulmw_0-1727188896164.png

 

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

I had already fixed this, but had not released a new version in a while.  I have just submitted a new version to teh Tools Network.

Message 3 of 3
(3,577 Views)