how do I send null or empty date from aware IM to stored pro
-
- Posts: 370
- Joined: Sat Apr 28, 2018 3:33 am
- Location: India
- Contact:
how do I send null or empty date from aware IM to stored pro
how do I send null or empty date from aware IM to stored procedure?
Re: how do I send null or empty date from aware IM to stored
When you define the SP, you can have a DEFAULT value, so if your SP looks like this:
Create Procedure MYSP
@param1 varchar(20) = null
If you have a default value, then you can skip sending the param in your rule.
Create Procedure MYSP
@param1 varchar(20) = null
If you have a default value, then you can skip sending the param in your rule.
-
- Posts: 370
- Joined: Sat Apr 28, 2018 3:33 am
- Location: India
- Contact:
Re: how do I send null or empty date from aware IM to stored
Thank you! this worked.
-
- Posts: 197
- Joined: Fri Jun 17, 2016 7:10 am
- Location: Brisbane Australia
- Contact:
Re: how do I send null or empty date from aware IM to stored
.BLOMASKY wrote:When you define the SP, you can have a DEFAULT value, so if your SP looks like this:
Create Procedure MYSP
@param1 varchar(20) = null
If you have a default value, then you can skip sending the param in your rule.
You can do this in MS SQL but unfortunately not in mySQL as mySQL does not support defaults for stored procedure parameters (hope I’m wrong).
AWS Linux, Windows Server, AIM 8.4 & 8.6