Trying to create an Updatable BAQ on erp.VendPart to add Vendor Pricing.
I have created the basic uBAQ, Dashboard and menu item.
I can change and save existing data in the grid, but when I hit the ‘New’ button to try to add a new record I get and Application Error Pop up: Exception caught in: System Data.
It looks like it is not happy with VendPart_EffectiveDate when trying to initialize a new row.
I went back to the uBAQ and under the UpdateTab/GeneralProperties… I set the ‘Initital Expression’ for VendPart_EffectiveDate to Constants.Today… but this did not do the trick.
Any hints are much appreciated.
Application Error
Exception caught in: System.Data
Error Detail
Message: Cannot set Column ‘VendPart_EffectiveDate’ to be null. Please use DBNull instead.
Program: System.Data.dll
Method: set_Item
Client Stack Trace
at System.Data.DataRow.set_Item(DataColumn column, Object value)
at Ice.Lib.Framework.BAQDataView.applyGetNewSubscribers(DataRow newRow)
at Ice.Lib.Framework.BAQUpdater.GetNewBAQRow(BAQDataView BAQView, Object[]& ItemArray)
at Ice.Lib.Framework.BAQUpdater.AddNewBAQRow(BAQDataView BAQView)
at Ice.Lib.Framework.BAQDataView.HandleAppControlEvent(AppController AppController, AppControlEvent AppEvent)
at Ice.Lib.Framework.UIApp.AppController.HandleBaqGetNew()
at Ice.UI.App.SupplierPriceListUpd.MainController.HandleAdapterGetNew()
at Ice.Lib.Framework.UIApp.AppController.OnGetNew(String GetNewText)
at Ice.Lib.Framework.UIApp.AppControllerPanel.OnClickNew(String ViewName)
at Ice.Lib.Framework.UIApp.AppControllerPanel.HandleToolClick(String tKey, ToolClickEventArgs ea)
at Ice.Lib.Framework.UIApp.EpiHostForm.EpiHostForm_BeforeToolClick(Object sender, BeforeToolClickEventArgs e)
at Ice.Lib.Framework.EpiBaseForm.OnBeforeToolClick(String tKey, ToolClickEventArgs ea)
at Ice.Lib.Framework.EpiBaseForm.handleToolClick(String tKey, ToolClickEventArgs ea)