StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Calulated Field

Calulated Field

Jon Olson — Fri, 13 Oct 2006 11:41:21 GMT

I have a database field that is calculated using a lookup table,

The lookup table has 9 rows and 10 columns, Currently it is stored in a table.

Is there a good way to add this to the business object?

RE: Calulated Field

Trent L. Taylor — Fri, 13 Oct 2006 11:41:21 GMT

[quote]

I have a table that has three fields A,B,C for example. When the user changed A or B then I need to get the new value for C for the table. Can I put custom code in the C field to calculate based on those two?

[/quote]

Yes. This is the purpose behind a custom field.

RE: Calulated Field

Jon Olson — Fri, 13 Oct 2006 11:17:19 GMT

Currently I am upgrading an app that does this through the form, basically performing the calculation anytime the user changes or clicks on any fields that may change A or B. I would like to move this to the BO.

RE: Calulated Field

Trent L. Taylor — Fri, 13 Oct 2006 11:03:16 GMT

Well...I guess I don't totally understand what you are trying to do...but there are a number of ways to consolidate that you may accomplish what you are attempting to do. You can create custom field properties, you can also use a view and map a business object to a view which will pull that data as well. I guess I need more information before I can give you a more direct answer.