BO Populated combo boxes causing errors


Author
Message
Andria Jensen
Andria Jensen
StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)
Group: Forum Members
Posts: 336, Visits: 497
Since I upgraded to the latest version of SF, none of my combo boxes will populate.  This happens for all ComboBoxEdits that are set to populate by BO.  They were working before and now everytime a form with a combobox on it tries to load I get an error and the rest of the form quits loading.  I get an error with a stack trace like the following.  I also attached the SQL log from this morning.


11/14/2006 5:25:09 PM
Source: System.Data
Message: Column 'CurrencyType' does not belong to table .
Stack:    at System.Data.DataRow.GetDataColumn(String columnName)
   at System.Data.DataRow.get_Item(String columnName)
   at MicroFour.StrataFrame.UI.Windows.Forms.DevEx.ComboBoxEdit.PopulateFromDataTable()
   at MicroFour.StrataFrame.UI.Windows.Forms.DevEx.ComboBoxEdit.PopulateComboBox()
   at MicroFour.StrataFrame.UI.Windows.Forms.DevEx.ComboBoxEdit.set_DataSource(DataTable value)
   at MicroFour.StrataFrame.UI.Windows.Forms.DevEx.ComboBoxEdit.SetDataSource(Object DataSource, String DisplayMember, String ValueMember)
   at MicroFour.StrataFrame.UI.Windows.Forms.ListControl.PopulateComboFromBusinessObject(IListControl lstControl, Object[] Parameters)
   at MicroFour.StrataFrame.UI.Windows.Forms.ListControl.PopulateCombo(Control lstControl, Object[] Parameters)
   at MicroFour.StrataFrame.UI.Windows.Forms.DevEx.ComboBoxEdit.PopulateCombo(Object[] Parameters)
   at MicroFour.StrataFrame.UI.Windows.Forms.DevEx.ComboBoxEdit.Requery()
   at BBS.GUI.Tables.frmChkSourceTbl.frmChkSourceTbl_Activated(Object sender, EventArgs e) in C:\FactorSoftV3\BBS.GUI\Tables\frmChkSourceTbl.vb:line 11
   at System.Windows.Forms.Form.OnActivated(EventArgs e)
   at System.Windows.Forms.Form.set_Active(Boolean value)
   at System.Windows.Forms.Form.ActivateMdiChildInternal(Form form)
   at System.Windows.Forms.Form.WmMdiActivate(Message& m)
   at System.Windows.Forms.Form.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)

StrataFrame Team
S
StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
I'm not sure why you're getting this error because I just tested it and it worked fine on this end... what you might do is put a break point in the method that you're using to populate the business object (FillWhatever()).  And step through the method until the current line lands on the End Sub.  Then, check Me.CurrentDataTable within the Watch window and make sure that the CurrencyType column does actually exist on the table...
Andria Jensen
Andria Jensen
StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)
Group: Forum Members
Posts: 336, Visits: 497
Yep, did exactly what you said and it DOES have a CurrencyType field in there.  I have attached the screenshot so you can see what I mean.  This is happening on every combo box and I can't get to a lot of my forms to work.  Any other ideas?
Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
What version of DevExpress are you using?
Andria Jensen
Andria Jensen
StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)
Group: Forum Members
Posts: 336, Visits: 497
DevExpress version is 6.2.3
Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
First of all, we beleive you otherwise you would not be posting out here.  But neither of us have been able to reproduce this.  Could you create a small sample project, you could use the StrataFrameSample database if you would like, so that we might be able to see this in action.  Obviously there is something different between what you are doing and what we are doing or there is another element in the forumula.

Also, you are the first to report this as well, so I do not think it is a framework wide thing.  Otherwise, we would have already heard about this since the 1.5.1 release has been out for 3 weeks now.

So if you could help us work through your problem, that would be great.  We want to help, but we need more information.

Andria Jensen
Andria Jensen
StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)
Group: Forum Members
Posts: 336, Visits: 497
Ok, no problem.  I'll try to get together a sample project.  I figured this would be an interesting one to figure out.  I've looked through StrataFrame source code, my source code, and just haven't seen anything I could pinpoint as the cause.  Maybe a smaller project will shed some light on this.  Stay tuned Smile
Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
Great...thanks.
Andria Jensen
Andria Jensen
StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)
Group: Forum Members
Posts: 336, Visits: 497
I now get a different error after I set up a sample project.  I used the customers table and just put a customers BO in the project from the StrataFrameSample db.  I then set the PopulationDataSourceSettings on the ComboBoxEdit to use a FillAll method which I added to the BO.  When I load the form, I get an error which says: "Exception has been thrown by the target of an invocation."  Please check out the project I am attaching and tell me if I've done something wrong here.  I have also attached a screenshot of the error I get in case it does something different on your end.  Thanks in advance.
Andria Jensen
Andria Jensen
StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)StrataFrame User (422 reputation)
Group: Forum Members
Posts: 336, Visits: 497
Ok, I feel stupid now. My database wasn't pointing to the right place so that's why the invocation error.  I fixed it and it seems to populate from the Customers BO.  Let me try a couple of other things and see what I can come up with.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search