G
g.belanger
I am trying to pass parameters to a stored proc via the
InputParameters on the form.
I set up the Proc with a couple of parameters with LIKE (e.g. LIKE
@p_File_Type)
On the form, in the InputParameters property I can string the values
out with commas inbetween and it works like a charm.
Problem is, if the user leaves a value blank, I would like the query
to select all values for that field. I have tried '%', leaving the
value blank, NULL, etc and nothing seems to work.
Anyone have any ideas?
InputParameters on the form.
I set up the Proc with a couple of parameters with LIKE (e.g. LIKE
@p_File_Type)
On the form, in the InputParameters property I can string the values
out with commas inbetween and it works like a charm.
Problem is, if the user leaves a value blank, I would like the query
to select all values for that field. I have tried '%', leaving the
value blank, NULL, etc and nothing seems to work.
Anyone have any ideas?