Here is the stack trace:

Stack Trace:

   at System.Data.ExpressionParser.Parse()

   at System.Data.DataExpression..ctor(DataTable table, String expression, Type type)

   at System.Data.DataView.set_RowFilter(String value)

   at MicroFour.StrataFrame.Business.BusinessLayer.set_Filter(String value)

   at MicroFour.StrataFrame.Business.BusinessLayer.FilterChildRecords(BusinessLayer ChildBusinessObject)

   at MicroFour.StrataFrame.Business.BusinessLayer.Navigate(BusinessNavigationDirection Direction, Int32 AbsoluteIndex, Object[] PrimaryKeyValues, Boolean AttemptToCheckRules, Boolean IsRefill)

   at MicroFour.StrataFrame.Business.BusinessLayer.Add(Boolean CheckSecurity)

   at MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.Add(Boolean CheckSecurity)

   at MicroFour.StrataFrame.UI.Windows.Forms.DevEx.MaintenanceFormToolbar.cmdNew_ItemClick(Object sender, ItemClickEventArgs e)

   at DevExpress.XtraBars.BarItem.OnClick(BarItemLink link)

   at DevExpress.XtraBars.BarBaseButtonItem.OnClick(BarItemLink link)

   at DevExpress.XtraBars.BarItemLink.OnLinkClick()

   at DevExpress.XtraBars.BarItemLink.OnLinkAction(BarLinkAction action, Object actionArgs)

   at DevExpress.XtraBars.BarButtonItemLink.OnLinkAction(BarLinkAction action, Object actionArgs)

   at DevExpress.XtraBars.BarItemLink.OnLinkActionCore(BarLinkAction action, Object actionArgs)

   at DevExpress.XtraBars.ViewInfo.BarSelectionInfo.ClickLink(BarItemLink link)

   at DevExpress.XtraBars.ViewInfo.BarSelectionInfo.UnPressLink(BarItemLink link)

   at DevExpress.XtraBars.Controls.CustomLinksControl.OnMouseUp(MouseEventArgs e)

   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

   at System.Windows.Forms.Control.WndProc(Message& m)

   at DevExpress.XtraBars.Controls.DockedBarControl.WndProc(Message& msg)

   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)

Generally, those syntax error operations come from trying to set the filter on the view, or do a Select() within the CurrentDataTable.  Could you post the stack trace for the exception so I can see where the exception is manifesting?

I'm adding a child BO that will be called similar to the childBO in your CRM example. Somewhere along the way after I added the child object to the form and configured my second child BO relationship by the primary key(case_sid) I get the following exception when adding a new record:

SyntaxErrorException

            Syntax error: Missing operand after 'case_sid' operator.

 

All of my fields are locked on the form until I either remove the childBO from my maintenance form or eliminate the relationship with the Parent BO. In the mean time I've added my third business object without error. The issue is probably some tweak of the object, but I cant figure it out. I thought the exception might be familar to you.

Derrick Bell