Using range values with Stored Procedure

[williey]

Has anyone used range value(s) with stored procedures?
I have 2 dates variables defined in a stored procedure. But both showed as discrete parameters in CR8.5.




------------------------------------------
There are 10 kinds of people in this world. One that understands binary and the other one that does not.

 

[synapsevampire]

An SP can't take an array... It'a a limitation of almost every database.

Why would you pass more than one date to each??? The SP wasn't written to accept that.

-k

 

[synapsevampire]

Ahhh, I thinkI misundestood your question, you meant use a single date range parm for the 2 dates in the SP.

SP's parameters are automagically recognized by Crystal, so you don't get to control any of that, sorry.

-k

 

[williey]

thats what I thought too.

------------------------------------------
There are 10 kinds of people in this world. One that understands binary and the other one that does not.