That's what I was using at first, but I came up with a field without default and that does not accept null values. Of course in this case, the INSERT fails.
But while reading your post, it just occured to me that all I have to do assign a default of '' to those fields.
Thanks!
>I'm not quite sure that I understand the question but using
>
>INSERT INTO table DEFAULT VALUES
>
>will create a new row in the table and all the columns will contain defaults, NULLs, timestamps, or IDENTITY values depending on how the column was defined.
>
>-Mike
Sylvain Demers