how do I send null or empty date from aware IM to stored pro

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
swiftinitpvtltd
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

Post by swiftinitpvtltd »

how do I send null or empty date from aware IM to stored procedure?
BLOMASKY
Posts: 1470
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: how do I send null or empty date from aware IM to stored

Post by BLOMASKY »

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.
swiftinitpvtltd
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

Post by swiftinitpvtltd »

Thank you! this worked.
UnionSystems
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

Post by UnionSystems »

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
Post Reply