Print Page - SQL DB (MSSQL): Post NULL values

Title: SQL DB (MSSQL): Post NULL values
Post by: pahag on June 23, 2010, 07:35:58 AM

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.

Title: Re: SQL DB (MSSQL): Post NULL values
Post by: Arthur Grasin on June 23, 2010, 08:32:36 AM

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.

Title: Re: SQL DB (MSSQL): Post NULL values
Post by: pahag on September 09, 2010, 12:12:55 PM

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:

Title: Re: SQL DB (MSSQL): Post NULL values
Post by: Arthur Grasin on September 09, 2010, 01:36:23 PM

Do you want always post NULL to a DB?

AGG Software Forums

Online Help Center => Data loggers and plug-ins => Topic started by: pahag on June 23, 2010, 07:35:58 AM