Hi Sergey,

I didn't specify a default value. When I try to set the default value to 0, I get the following error message:

'InvoiceHeader' table
- Unable to modify table.  
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Type ??meric is not a defined system type.

>Hi Allan
>
>You cannot add field with NO NULLS attribute w/o default value. What's default value for that column?
>
>>Hi, I'm designing a DB for a new system. At the current time - none of the tables have any rows. Using Enterprise Mangler, I'm trying to add a new field 'UserID' (integer, NO NULLS) to an existing table.
>>
>>When I try to save the changes, I get the following error:
>>
>>

>>'InvoiceHeader' table
>>- Unable to modify table.
>>ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 4: Incorrect syntax near '?'.
>>
>>

>>
>>The error message seems weird to me and I can't figure out what it means. Any assistance would be appreciated. Note that there are other tables in the database that have the same field name ('UserID') and attributes.
>>
>>
>>Al