ApplyMap('Map_Repbasis',REPBASIS) asRepbasis_used ; SQL SELECT * FROM "OAS_BALANCE" WHERE CMPCODE LIKE '$(varCMPCODE)' //AND Repbasis_used = 'y' //not working AND YR >= '$(varMinJahrFix)' AND YR <= '$(varMaxJahrFix)' ; store oas_balance into$(vDataQVD)oas_balance.qvd;
How can I load from the Database with a filter, that is not in the Database?
I cannot list a repbasis entries, that I want to load (because this can Change).
Repbasis_used does not exist in the database, so your cannot do the filtering like that. Either do the mapping and bring in Repbasis_used in the database with a SQL join, or you will have to bring in all the data in the SQL part and filter the LOAD part, like:
ApplyMap('Map_Repbasis',REPBASIS) as Repbasis_used
Where ApplyMap('Map_Repbasis',REPBASIS) = 'y'
SQL SELECT ...
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein