Link to home
Start Free TrialLog in
Avatar of santosh_14
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
ASKER CERTIFIED SOLUTION
Avatar of daffyduck14mil
daffyduck14mil

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Anthony Perkins
I suppose there is no sense in reminding you to close your open questions, is there?  For the record:

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
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.
Avatar of daffyduck14mil
daffyduck14mil

Santosh,

Are you going to attend to this question? Given your record not, but i'll wait a few days...

Grtz.©

D.
Avatar of santosh_14

ASKER

Checked my old email account today .. thx
Great, hope you have your solution.

Grtz.©

D.