My questions is:
When i try to write an SQL Statement (Source of Data), how can i make an parameter optional ? (I have 3 parameters and i want like one to be optional).
Thanks very much.
Printable View
My questions is:
When i try to write an SQL Statement (Source of Data), how can i make an parameter optional ? (I have 3 parameters and i want like one to be optional).
Thanks very much.
this is how I do it:
the "Parameters" tab for the command has a "required" combobox. If you set the value in that box to "False", the parameter is optional.