TD, just doing some catching up on your files and i was wondering if you can help so far i am upto adding these FLD_SHOWX, data type: int, lenght: 4, allow nul:false, default value:0 but
when i remove the tick out of allow null and then go to save it i get this error on all 3 edits to that table.
'TBL_MERCHANT' table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'FLD_SHOWX', table 'LOM2.dbo.Tmp_TBL_MERCHANT'; column does not allow nulls. INSERT fails.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
so i spose the question is, allow nulls is that ticked or unticked for it to be allow nulls =False
any ideas gratefully recieved
when i remove the tick out of allow null and then go to save it i get this error on all 3 edits to that table.
'TBL_MERCHANT' table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'FLD_SHOWX', table 'LOM2.dbo.Tmp_TBL_MERCHANT'; column does not allow nulls. INSERT fails.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
so i spose the question is, allow nulls is that ticked or unticked for it to be allow nulls =False
any ideas gratefully recieved