AGG Software Forums
September 20, 2024, 07:23:18 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Welcome on our forum!
 
  Home Help Search Login Register  
  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.


Pages: [1]
Powered by SMF 1.1.21 | SMF © 2015, Simple Machines