[WD 23] Query UNION Problem

Hello everyone

I have the following query:

SELECT
	ArtikliID AS ArtikliID,	
	artoznaka AS artoznaka,	
	artnaziv AS artnaziv,	
	ArtikliGrupaID AS ArtikliGrupaID,	
	artvrsta AS artvrsta,
	SUM(Ulazi) AS Ulazi,
	SUM(Izlazi) AS Izlazi,
	SUM(Zaliha) AS Zaliha,
	SUM(Vrijednost) AS Vrijednost
FROM
(
SELECT 
	Artikli.ArtikliID AS ArtikliID,	
	Artikli.artoznaka AS artoznaka,	
	Artikli.artnaziv AS artnaziv,	
	Artikli.ArtikliGrupaID AS ArtikliGrupaID,	
	Artikli.artvrsta AS artvrsta,	
	Artikli.MPC AS MPC_Artikli,	
	Promet.MPC AS MPC_Promet,	
	Promet.Ulaz AS Ulazi,	
	Promet.Izlaz AS Izlazi,	
	( Promet.Ulaz - Promet.Izlaz )  AS Zaliha,
	( ( Promet.Ulaz - Promet.Izlaz ) * Promet.MPC )  AS Vrijednost,	
	Normativi.kolicina AS kolicina
FROM 
	(
	Artikli
	LEFT OUTER JOIN
	Normativi
	ON Artikli.ArtikliID = Normativi.ArtikliID
	)
	LEFT OUTER JOIN
	Promet
	ON Artikli.ArtikliID = Promet.ArtikliID
WHERE 
	(

	(
	Promet.PoslovnejediniceID = {Param_PJ_Promet}
	OR	Promet.PoslovnejediniceID IS NULL 
	)
	AND	
	(
	Normativi.PoslovnejediniceID = {Param_PJ_Normativi}
	OR	Normativi.PoslovnejediniceID IS NULL 
	)
	AND	Promet.datum BETWEEN {Datum_Od} AND {Datum_Do}
	)

UNION ALL

SELECT 
	Artikli.ArtikliID AS ArtikliID,	
	Artikli.artoznaka AS artoznaka,	
	Artikli.artnaziv AS artnaziv,	
	Artikli.ArtikliGrupaID AS ArtikliGrupaID,	
	Artikli.artvrsta AS artvrsta,	
	Artikli.MPC AS MPC,	
	Promet.MPC AS MPC_Pr,	
	Promet.Ulaz AS Ulazi,	
	( Promet.Izlaz * Normativi.kolicina ) AS Izlazi,
	( Promet.Ulaz - ( Promet.Izlaz * Normativi.kolicina ) )  AS Zaliha,	
	( ( Promet.Izlaz * Promet.MPC ) * Normativi.kolicina )  AS Vrijednost,	
	Normativi.kolicina AS kolicina
FROM 
	Artikli
	LEFT OUTER JOIN
	(
	Normativi
	RIGHT OUTER JOIN
	Promet
	ON Normativi.ArtikliID = Promet.ArtikliID
	)
	ON Artikli.ArtikliID = Normativi.Normativ_IDArt
WHERE 
	(
	Artikli.artvrsta = 3
	AND	Promet.PoslovnejediniceID = {ParamPoslovnejediniceID}
	AND	Promet.datum BETWEEN {Datum_Od} AND {Datum_Do}
	)
)
	AS Kartica_artikala
GROUP BY
	ArtikliID,	
	artoznaka,	
	artnaziv,	
	ArtikliGrupaID,	
	artvrsta

In test mode, this query does what it needs to do, however, when I call the query with the HExecuteQuery () function it does not produce any results.

1. Can WinDev perform such queries?
2. Or my query should be asked differently.

Has anyone had similar issues with queries?
Thank you

[infosonline.net]

Hi.

Try the constants, hQueryWithoutCorrection or hQueryWithoutHFCorrection.

Quote
HExecuteQuery(MyQry,hQueryWithoutHFCorrection)

Thanks Elias for the answer

I tried all those combinations.
The problem is that the queries that make up the Query Union must be run first ?!

I subsequently discovered this problem

[infosonline.net]



Edited 1 time(s). Last edit at 04/22/2020 11:02AM by infos.

EliasRC Wrote:
-------------------------------------------------------
> Hi.
>
> Try the constants, hQueryWithoutCorrection or
> hQueryWithoutHFCorrection.
>
>

Quote
HExecuteQuery(MyQry,hQueryWithoutHFCorrection)
>
>

if you want to use hquerywithouthfcorrection , you must remove all parameter in the code like {Datum_Od}