November 25, 2024, 09:33:18 AM
|
Show Posts
|
Pages: [1]
|
1
|
Online Help Center / Data loggers and plug-ins / Re: SQL DB (MSSQL): Post NULL values
|
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:
|
|
|
2
|
Online Help Center / Data loggers and plug-ins / SQL DB (MSSQL): Post NULL values
|
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.
|
|
|
|
Loading...
|