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
--sb--