StrataFrame Forum » StrataFrame Application Framework - V1 » Issues » column X does not belong to table X

column X does not belong to table X

Sam Garvin — Sun, 19 Oct 2008 15:16:05 GMT

Hi again

I'm really sorry to bother you with this stupid error, but I haven't been able to fix it.

I modified a table structure ( I added more fields ), but there was already a BO associated to that table, so I opened the BO Mapper, re-configured the existing BO and I could see all the fields (new and old), I rebuilt the partial, I went back to VS and checked the BO.designer.cs file and the code for the new fields was already there, next I created a maintenance form, dropped my BO, added textboxes, etc. and did the binding.

But when I debugged the solution I got an error that says: column X does not belong to table X, the exception was raised in the BO.designer.cs file in the field properties region.

Ok, if I change the fields binded to my textboxes and use the ones that already existed before the structure changes everything works fine, it only happens when I use the new added fields.

Maybe I'm skipping one o more steps when configuring the BO or something.

Again I'm so sorry to bother you with this, any help would be highly appreciated

Thanks in advance!!!!

RE: column X does not belong to table X

Sam Garvin — Sun, 19 Oct 2008 15:16:05 GMT

Hi!!!

Well, the fields were there and I followed the steps you mentioned, but in the end I decided to create a brand-new BO and forget about the one that already existed (too many problems).

Thank you very much for your replies!!!!

RE: column X does not belong to table X

Trent L. Taylor — Thu, 16 Oct 2008 09:12:33 GMT

This could come from several places depending on where and when you are getting this error. But the most common error is that your query doesn't include all of the columns, so when you reference the strong-typed property of the new column, it doesn't actually exist within the CurrentDataTable. The first thing that I would do is put a break point on the Get or Set of the strong-typed property in question, and when it breaks, put the following in the watch window:

[codesnippet]MyBO.CurrentDataTable[/codesnippet]

Does the column(s) in question actually exist? If not, there is your problem. Otherwise, please post the full stack trace so that we can see where the error is originating.

RE: column X does not belong to table X

Sam Garvin — Thu, 16 Oct 2008 09:09:24 GMT

I made the structure changes using the SQL Server Management Studio Express.

RE: column X does not belong to table X

Ivan George Borges — Thu, 16 Oct 2008 07:56:14 GMT

Hi Sam.

Have you used the DDT to make the changes to your table? If so, have you deployed your changes to your database?

RE: column X does not belong to table X

Edhy Rijo — Thu, 16 Oct 2008 07:12:47 GMT

Hi Sam,

The steps I use for this are:

Modify table structure
Open BOM, refresh the the BO and rebuild partial
Go back to VS and rebuild the project
Use new fields anywhere.

Some times you may need to clean up the solution (right click the solution and select cleanup) and also sometimes you may need to close VS and open it again.