Skip to Content
avatar image
Former Member

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

  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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 07 at 08:43 PM

    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().

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 08 at 11:34 AM

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

    Regards,

    Iv.

    Add comment
    10|10000 characters needed characters exceeded