contact
support
Download
order
news
AGG Software Forums
November 24, 2024, 01:34:49 PM
Welcome,
Guest
. Please
login
or
register
.
Did you miss your
activation email?
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News
: Welcome on our forum!
Home
Help
Search
Login
Register
AGG Software Forums
>
Online Help Center
>
Data loggers and plug-ins
>
SQL DB plug-in not write NULL value
Pages: [
1
]
« previous
next »
Print
Author
Topic: SQL DB plug-in not write NULL value (Read 14944 times)
jamesant
Jr. Member
Karma: +0/-0
Posts: 7
SQL DB plug-in not write NULL value
«
on:
October 11, 2013, 01:12:19 PM »
How can I stop the SQL database plug-in from carrying out an SQL query if any of the values it needs to write is NULL ?
For example
insert into ADatabaseT1
values (:P1,:P2,:P3)
if the value of P1 is NULL, I want the sql query to be skipped
Logged
Arthur Grasin
Tech. Support
Administrator
Hero Member
Karma: +0/-0
Posts: 806
Re: SQL DB plug-in not write NULL value
«
Reply #1 on:
October 11, 2013, 01:42:43 PM »
You need to do it with a filter plugin.
Logged
jamesant
Jr. Member
Karma: +0/-0
Posts: 7
Re: SQL DB plug-in not write NULL value
«
Reply #2 on:
October 11, 2013, 02:35:48 PM »
I tried using the deadband filter, but found it didn't do what I needed
I solved it by changing the sql query.
It deletes the record if it wrote a null value into the Temp1 column.
insert into ADatabaseT1
values (:P1,:P2,:P3)
delete from ADatabaseT1
where Temp1 is null
Logged
Pages: [
1
]
Print
« previous
next »
Jump to:
Please select a destination:
-----------------------------
News & Feedbacks
-----------------------------
=> News and Updates
=> Site Comments
-----------------------------
Online Help Center
-----------------------------
=> Advanced Serial Port Monitor
=> Data loggers and plug-ins
=> Data loggers ActiveX
=> Advanced USB Port Monitor
=> Virtual Null Modem
=> Software for DNC and CNC
=> Other questions
-----------------------------
Development
-----------------------------
=> Feature Requests
Loading...