Hi i have this problem with my project, i think it DUPLICATE values, i think the problem is in CONCATENATE, using my QVD files:
IF filetime('.\DataStores\TABLE_YEAR_OLD_CDG_GAS.qvd') > 0 then CDG_Gas: LOAD NOME, CONSUMO from '.\DataStores\TABLE_YEAR_OLD_CDG_GAS.qvd' (qvd); ELSE CDG_Gas: LOAD NOME, CONSUMO; SQL SELECT * FROM ***:OLD; STORE CDG_Gas INTO '.\DataStores\TABLE_YEAR_OLD_CDG_GAS.qvd' (qvd); ENDIF
IF filetime('.\DataStores\V_FATTURATO_CDG_GAS_19.qvd') > 0 then Concatenate: CDG_Gas: LOAD NOME, CONSUMO from '.\DataStores\V_FATTURATO_CDG_GAS_19.qvd' (qvd); ELSE Concatenate: CDG_Gas: LOAD NOME, CONSUMO; SQL SELECT * FROM ***:19; STORE CDG_Gas INTO '.\DataStores\V_FATTURATO_CDG_GAS_19.qvd' (qvd); ENDIF
Concatenate: CDG_Gas: LOAD NOME, CONSUMO; SQL SELECT * FROM ***_20; STORE CDG_Gas INTO '.\DataStores\V_FATTURATO_CDG_GAS_20.qvd' (qvd); ENDIF
Whei i go in my project if i look values in my Table all is ok, CONSUMO is with right value (25.000).
But when i see in the straight table chart the Sum(Consumo) make me values like are duplicate or similar (51.000)
If i delete all my QVD so it take values from database with SELECT all is ok, but when the second time i reload and it will take the rows from my QVD.... so now i have this problem
