Devart Forums

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

Thank you for this information. This is MyDAC's bug. It has already been fixed, and a bug fix will be included in the next build of MyDAC (MyDAC 5.00.0.5), which will be available in the nearest time.