What is the equivalent Database Connectivity VI of the SQL Toolkit 'Set SQL Parameter to Null' VI ?
The VI was not attached but I'm going to answer with what I have here.
- Currently, the Database Toolset converts NULLs to the default value
for LabVIEW data types (ie, False for Boolean, empty strings, zero for
numbers, empty arrays, etc). In the user manual there is an example
that shows database records containing NULL values being first
converted to a string, empty strings (the NULLs) are then converted to
NaNs instead of the usual zero value. This method requires you to know
what data types each field contains and that they know what to look
for and how to convert the data.
You can go to this following link to suggest that a null datatype be
-Also you cannot leave parameters values empty because there is a big
difference between executing an SQL statement and doing a
Parameterized Query, especially when looking at the low-level ADO
layer.When doing Parameterized Queries, you MUST specify all parameter
values - leaving them empty results in ADO trapping errors rather than
using a default value.