When I save I get an error that says

Marcia G Akins — Tue, 06 Oct 2009 23:59:45 GMT

And I really do not understand why. I set the BO's AllowNullValuesOnNewRow property to true because From the documentation (even though it sounds a little backwards :P):

When True, the NewRow() function will automatically initialze the row to prevent any DBNull values from occurring

In the BO mapper, I also customized the field to return alternate on null - is_primary is a boolean field, so I set the alternate to false.

So I am more than a little mystified that I am getting this error - can someone please help me find a solution?

DataLayerSavingException
Cannot insert the value NULL into column 'is_primary', table 'TGIF.dbo.Contact'; column does not allow nulls. INSERT fails.
The statement has been terminated.
SqlException
Cannot insert the value NULL into column 'is_primary', table 'TGIF.dbo.Contact'; column does not allow nulls. INSERT fails.
The statement has been terminated.

Source : MicroFour StrataFrame Business

Stack Trace:
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
   at MicroFour.StrataFrame.Data.DbDataSourceItem.InternalExecuteReader(DbCommand Command, Boolean IsTransactional, String TransactionKey)
   at MicroFour.StrataFrame.Data.SqlDataSourceItem.UpdateRow(QueryInformation QueryInfo, DataRow RowToUpdate, ConcurrencyExceptionHandler ConcurrencyHandler, AddRowErrorHandler RowErrorHandler, Boolean RecreateCommand)
   at MicroFour.StrataFrame.Data.DbDataSourceItem.UpdateRow(QueryInformation QueryInfo, DataRow RowToUpdate, ConcurrencyExceptionHandler ConcurrencyHandler, AddRowErrorHandler RowErrorHandler)
   at MicroFour.StrataFrame.Data.DataLayer.UpdateDataTableThread(Object ThreadParams)
   at MicroFour.StrataFrame.Data.DataLayer.UpdateDataTable(DataTable TableToUpdate, Boolean Transactional, String TransactionKey)
   at MicroFour.StrataFrame.Data.DataLayer.Save(DataTable TableToSave, Boolean Transactional, String TransactionKey)
   at MicroFour.StrataFrame.Business.BusinessLayer.Save(Boolean Transactional, String TransactionKey)
   at MicroFour.StrataFrame.Business.BusinessLayer.Save()
   at TGIF.Forms.Contact.cmdOK_Click(Object sender, EventArgs e) in F:\TGIF\Forms\Contact.cs:line 109
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativewindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m)
   at System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

RE: When I save I get an error that says

Greg McGuffey — Tue, 06 Oct 2009 23:59:45 GMT

A better place would be using the SetDefaultValues event. I typically handle it in the BO and then you don't have to worry about it.

RE: When I save I get an error that says

Marcia G Akins — Tue, 06 Oct 2009 17:32:34 GMT

I tried leaving it set to false - same problem. So, I did this in the BO's BeforeSave method and that took care of the problem:

// when all else fails, try a bigger hammer

// kept getting a "column does not accept null values" error

// on save

if (chkis_primary.Checked == false)

boContact.is_primary = false;

RE: When I save I get an error that says

Greg McGuffey — Tue, 06 Oct 2009 15:00:27 GMT

And as I reread the docs, they appear to be backwards. I.e. based on docs true would initialize, but in source, its obviously false that causes the initialization...

[codesnippet]If Not _AllowNullValuesOnNewRow Then
'-- initialization code
End If[/codesnippet]

RE: When I save I get an error that says

Greg McGuffey — Tue, 06 Oct 2009 14:57:15 GMT

It appears that if you want the BO to initialize your columns with default data based on the data type, you need to set the AllowNullValuesOnNewRow property to [b]false[/b]. If it is true, it allows NULLs in the current data table. If false, then it does the initialization. (checked source to figure out what was up).

StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » When I save I get an error that says

When I save I get an error that says

RE: When I save I get an error that says

RE: When I save I get an error that says

RE: When I save I get an error that says

RE: When I save I get an error that says