> > A DEFAULT is not used when you supply NULL, but only
> > used when you don't include the column in the INSERT INTO
> > statement.
> >
>
> I agree... and that's exactly what I did in my stored procedure !
> CNVTICKETL is not included in the insert statement ; that's why I
> don't understand why I'm meeting this error.

Then better show the stored procedure code :-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com