--- In firebird-support@yahoogroups.com, "Clay Shannon"
<cshannon@d...> wrote:

> When a stored proc I've created is executed from within my app

(Delphi 7,

> using FIB components), I
>
> get the err msg:
> The insert failed because a column definition includes validation
> constraints.validation error for
>
> column ADV_DIR, value "".
> The ADV_DIR column, a VarChar(7), does not contain a constraint--the

only

> constraint on the entire
> table is the PK. Adv_Dir is nullable, and the value being rejected is an
> empty string.

My version of FIB+ carks when I clear a parameter during an insert series.
Haven't investigated far so solution to date is to manufacture new
queries on the fly for each insert.

HTH
Mick