SQL DB (MSSQL): Post NULL values

[pahag]

Hi.

I am posting an NMEA (comma separated string) to a database using Advanced TCP/IP Logger and SQL Database Professional.

I want a null - value to be sent to database if i don't get correct data from the parser.

Is it possible to send a NULL - value as default if there is no other value to send? If so: Is the procedure differet for string, float, int etc.

Best Regards,
PA.

[Arthur Grasin]

You can do it with the Script Execute plugin (override a parser item or change its value). We've discussed about this plugin in the previous topic.

[pahag]

Hi,

Thanks for the reply.

I have tried the following to make my SQL parser post NULL-value to the database:

In the Script Execute plugin (JScript):

Deleted the parser item (DeleteVariable(...))
Overwritten the parser item (SetVariable("LONGITUDE", NULL)) - Makes the paser post default value.
Overwritten the parser item (SetVariable("LONGITUDE", nil)) - Makes the paser post value 0.

But no changes to the items make my SQL parser post NULL.

Any ideas?

PA:

[Arthur Grasin]

Do you want always post NULL to a DB?