santosh_14
asked on
NULL ADO Parameter
Surely this has been done in the past.
I need to sometimes assign a NULL value to an ADO Parameter for supply to a parameterized query ... which is the best available routine to solve this?
TIA
I need to sometimes assign a NULL value to an ADO Parameter for supply to a parameterized query ... which is the best available routine to solve this?
TIA
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or, you could just omit the parameter and give the parameter within the SP a default value of null.
This also keeps the definition of the SP more consistant, i.e. So that you can see which parameters are optional.
This also keeps the definition of the SP more consistant, i.e. So that you can see which parameters are optional.
Santosh,
Are you going to attend to this question? Given your record not, but i'll wait a few days...
Grtz.©
D.
Are you going to attend to this question? Given your record not, but i'll wait a few days...
Grtz.©
D.
ASKER
Checked my old email account today .. thx
Great, hope you have your solution.
Grtz.©
D.
Grtz.©
D.
Questions Asked 55
Last 10 Grades Given A A A A A A A A A A
Question Grading Record 48 Answers Graded / 48 Answers Received
Anthony