AutoRefresh doesn't works as expected
Posted: Mon 15 Dec 2008 09:20
Hi,
When setting autorefresh to true, MyDAC generate a "bad" sql statement.
Here is the SQL Statement (TMyQuery.SQL) :
When autorefresh is set to true, MyDac generate this SQL Statement :
I'm getting an error because query isn't correct
When setting autorefresh to true, MyDAC generate a "bad" sql statement.
Here is the SQL Statement (TMyQuery.SQL) :
Code: Select all
Select distinct
planning.*,
affaires.IdTypeCommande,
affaires.poseht,
vrp.idagence,
vrp.iddepot,
ecrituresouvertes.MontantOuvertTTC,
receptionmarchandise.DateReception
from
planning
LEFT OUTER JOIN ecrituresouvertes on (ecrituresouvertes.idaffairefe2000 = planning.idaffairefe2000 and ecrituresouvertes.typeDocument '')
LEFT OUTER JOIN receptionmarchandise on (receptionmarchandise.idaffairefe2000 = planning.idaffairefe2000)
INNER JOIN clientssia on (clientssia.idclientsia = planning.idclientsia)
INNER JOIN `vrp` ON (`clientssia`.`IdVRP` = `vrp`.`IdVRP`)
INNER JOIN perimetressia ON (vrp.idAgence like perimetressia.IdAgence And perimetressia.Utilisateur like :prUtilisateur)
LEFT OUTER JOIN planningintervenants ON (planning.IdPlanning = planningintervenants.IdPlanning)
-- LEFT OUTER JOIN matricule ON (planningintervenants.IdMatricule = matricule.IdMatricule)
-- LEFT OUTER JOIN soustraitants ON (planningintervenants.idSoustraitant = soustraitants.idSoustraitant)
LEFT OUTER JOIN affaires on (affaires.idaffairefe2000 = planning.idaffairefe2000)
Where
fin >= Date_Sub(curdate(), Interval 2 month)
and
( planning.IdIntervention 0 and planning.idStadePlanning 0)
and ( affaires.edi = 0 )When autorefresh is set to true, MyDac generate this SQL Statement :
Code: Select all
SELECT IdPlanning FROM planning WHERE
fin >= Date_Sub(curdate(), Interval 2 month)
and
( planning.IdIntervention 0 and planning.idStadePlanning 0)
and ( affaires.edi = 0 ) ORDER BY IdPlanning