Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Reported for Version 4.15 » View Incident Report |
Serious |
Reported By: Clive Bennett Reported On: 12/13/2004 For: Version 4.15 Build 1 |
drop table if exists "\memory\bal_items"; select sum(value) as item_value, period, type, scenario_code, project_code into "\memory\bal_items" from rpt_balance_sheet_variable_items where type in ('I','T','S','N','F') and scenario_code = -2 group by period,type,scenario_code,project_code; create index idx_1 on "\memory\bal_items" (type); select 46,period,scenario_code,'Shareholder funds',b.item_value, coalesce(b. item_value,0.0) + c.value + a.value + s.value as value,project_code from rpt_generic_detail c inner join rpt_generic_detail a on a.period = c.period and a. scenario_code = c.scenario_code inner join rpt_generic_detail s on s.period = c.period and s. scenario_code = c.scenario_code LEFT OUTER JOIN "\memory\bal_items" b on b.period = c.period and b. type = 'S' where c.rowid = 28 and a.rowid = 29 and s.rowid = 30 and c.scenario_code =-2;
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |