It would be nice if you could specify a default value for a query parameter as often times running a parameterized query you have values are are usually, not but always the same. Something like the following where you are specifying a default parameter value for the IsDone parameter:

• insert into Note (NoteText, IsDone) values ('\&Text', '\&{IsDone|N}');

Also see 13744 for "dynamic defaults" specific to date/time/timestamp fields.

In the parameter dialog box there should be an option to reset all parameter value fields to any defaults defined, caveat that if a field does not have a default, it would be left alone and not cleared out.

One special default value should be something like "(null)" which would insert a null value into the column if not populated in the parameter dialog. If "(null)" isn't specified then instead an empty string should be inserted into the column.