Hi !
I found anadher problem :
SET @zal = 0;
SELECT P.tip, P.dok, P.racunbr, P.datum, P.ids, P.naziv,
P.jm, P.ulaz, P.izlaz, P.nabc, P.pronc, P.cena,
@zal:=@zal+ulaz-izlaz zal, K.naziv1
FROM promet P
LEFT JOIN klijenti K ON P.idskl = K.idskl
WHERE P.ids = 7
ORDER BY P.datum, P.izlaz;
this query raise an "Assertion failure(D:\projects\delphi\mydac\source\MyAccess.pas, line 4008)
The source of error is @zal:= ... the char ":" is problematic !!!
widout ":" I get 0 (zero) results in field zal. In MyDAC 4.40.0.x
this wok fine, in MyDAC 5 is problem !
I'm try this query in MyJog separatly, and the result is perfect !
My bee I duing samthing wrong ?
MyDAC 5.00.0.4, D7, MySQL 5.0.37