Click to See Complete Forum and Search --> : Data Environment in VB 6


Sava
May 18th, 1999, 01:32 PM
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.

Lothar Haensler
May 19th, 1999, 02:19 AM
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.