Subject | Null in Stored Procedure parameter. |
---|---|
Author | dale tabbert |
Post date | 2001-01-11T03:34:20Z |
Hello,
I have a stored procedure that enters a value into a table which
takes three input params: key_id, key_name and key_value. In my
client, I may know either the key_id or the key_name. If key_id =
null, then in my SP I use the value of key_name to determine which
key gets key_value. If key_id is not null, I use key_id to determine
who gets key_value.
I just started using IBObjects and with a TIB_DSQL it appears that I
cannot have nulls as params. I was able to do this with IBExpress.
Any help is greatly appreciated.
Thanks,
Dale
I have a stored procedure that enters a value into a table which
takes three input params: key_id, key_name and key_value. In my
client, I may know either the key_id or the key_name. If key_id =
null, then in my SP I use the value of key_name to determine which
key gets key_value. If key_id is not null, I use key_id to determine
who gets key_value.
I just started using IBObjects and with a TIB_DSQL it appears that I
cannot have nulls as params. I was able to do this with IBExpress.
Any help is greatly appreciated.
Thanks,
Dale