Using GetValue Inner Select

Were going to use an Inner Select to get the value from the Exchange Rates table.

The first step is to add a local Column instead of the Rate column from the ExchangeRate entity.

Add the Rate Local Column

#region Columns
readonly Types.Amount RowTotal = new Types.Amount { Caption = "RowTotal" };
readonly NumberColumn Rate = new NumberColumn("Rate", "2.4");
#endregion 

Add the Rate Local Column to the Column Collection, and add a BindValue for it.

Columns.Add(ExchangeRates.Currency);
Columns.Add(ExchangeRates.EffectiveDate);
Columns.Add(ExchangeRates.Rate);
Rate.BindValue(ExchangeRates.Rate);
Columns.Add(Rate);
Columns.Add(CategorySales.Year);
Columns.Add(CategorySales.CategoryID); 

Use the local column in the expression

protected override void OnLeaveRow()
{
-   RowTotal.Value = Order_Details.UnitPrice * Order_Details.Quantity * ExchangeRates.Rate;
    RowTotal.Value = Order_Details.UnitPrice * Order_Details.Quantity * this.Rate;
                
    if (u.Month(Orders.OrderDate) == 1)
        CategorySales.Jan.Value += RowTotal; 

• Using the original relation when using Pervasive
• GetValue Inner Select
• Understanding the SQL behind the Scenes
• Using GetValue for multiple columns

---

Help us improve, Edit this page on GitHub
or email us at info@fireflymigration.com