Skip to Content
0

Calculated Column (using SQL -Mixing Tables in Data Foundation or Business Layer)

May 07 at 08:02 PM

14

avatar image
Former Member
  1. Hi Guys, I need to create a calculated column at detail level table, but I need to ask for a specific column in table header in order to get a value (master, detail). Both tables are linked by a primary key. I don't know how to do it in data foundation or business layer. Please any example is much appreciated.

Regards,

Iv.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Joe Peters May 07 at 08:43 PM
0

Calculated columns are strictly tied to a single table. You can either create a derived table that combines both, and include the calculation there, or do what we used to do in UDT: Create a regular object in the BL that does the calculation, and then reference its definition in other objects by using @Select().

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 08 at 11:34 AM
0

Hi Joe, much appreciated for your feedback. Any example that could help me.

Regards,

Iv.

Share
10 |10000 characters needed characters left characters exceeded