|
Title: SQL DB (MSSQL): Post NULL values Post by: pahag on June 23, 2010, 10: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, 11: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, 03: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, 04:36:23 PM Do you want always post NULL to a DB?
|