StrataFrame Forum » StrataFrame Application Framework - V1 » Issues » "Field" does not belong to table error.

"Field" does not belong to table error.

Ertan Deniz — Mon, 07 Jul 2008 08:18:04 GMT

To handle this error, I've generated FieldAccessing Event for all fields.

But the code that event is fired comes after the code that column is accessed. So, I couldn't handle this condition. I'm trying to catch property access, check column if exist. If column does not exist then column will be added to the table.

Is there alternative way to accomplish tis type of requirement ?

object loValue;

CompaniesFieldAccessingEventArgs e;

System.String loReturn;

loValue = this.CurrentRow["name"];

if (loValue == DBNull.Value)

{

loReturn = String.Empty;

}

else

{

loReturn = (System.String)loValue;

}

e = new CompaniesFieldAccessingEventArgs(CompaniesFieldNames.name, loReturn);

this.OnFieldPropertyAccessing(this, e);

return (System.String)e.ValueToReturn;

RE: "Field" does not belong to table error.

Trent L. Taylor — Mon, 07 Jul 2008 08:18:04 GMT

[quote]Remark : Devexpress Grid tries to reach each property even if is not selected. An exception occurs. So, every column and plus custom fields have to be included in the query.[/quote]

Ahhh....yeah, that makes sense. Glad you found a solution.

RE: "Field" does not belong to table error.

Ertan Deniz — Mon, 07 Jul 2008 03:50:18 GMT

I've found a hard way which seems to be infeasible. StrataFrame may solve this internally.

My Solution : In CurrentDataTableReFilled event, I 'm trying to define all the fields that are not included in the query.

Remark : Devexpress Grid tries to reach each property even if is not selected. An exception occurs. So, every column and plus custom fields have to be included in the query.

RE: "Field" does not belong to table error.

Ertan Deniz — Mon, 30 Jun 2008 01:13:16 GMT

Any Comment ?

RE: "Field" does not belong to table error.

Ertan Deniz — Fri, 20 Jun 2008 01:02:17 GMT

As you said, there may be many points to consider. Each of them have to be handled with specific code.

In my case, I want to handle "Object.Property1" case. When I'm trying to use property1, I need to ensure that the field is in the datatable. I couldn't write control logic for each property. Is there a general way that is known? This is my need.

RE: "Field" does not belong to table error.

Trent L. Taylor — Thu, 19 Jun 2008 10:05:29 GMT

This depends entirely on your code. When I have this issue, and depending on how I may use it, I may include this in the AfterAddNew or the CurrentDataTableRefilled event...it depends entirely on what you are trying to accomplish...I am not sure how to give you a straight answer on this without digging into your code.

RE: "Field" does not belong to table error.

Ertan Deniz — Thu, 19 Jun 2008 08:06:21 GMT

Any comment ?

RE: "Field" does not belong to table error.

Ertan Deniz — Wed, 18 Jun 2008 01:17:33 GMT

I know your method. I couldn't get answer how to use this method. See post below.

http://forum.strataframe.net/Topic15238-6-1.aspx

if you give a new position for FieldAccessing Event. This may solve the situation.

But I need quick way to progress. Where is the place to call the method. (EnsureColumnExist) There must be a central point.

RE: "Field" does not belong to table error.

Trent L. Taylor — Tue, 17 Jun 2008 20:10:56 GMT

In our medical app I created a shared method in our of our base classes that I pass over a DataTable, expected field, and field type. It then ensures that the column exists within the DataTable so that if a query is not performed, yet I have code expecting that field to have been returned from the query, I do not get an error. This way I can use it across BOs, etc.