Hi, after installing and recompiling the project i got sql errors. This is what the sql monitor showed. As you can notice the ORDER by clause is in the wrong place. I am using SetOrderBy to set it by code.
select m.ppldid, m.pplsid, m.apptype, m.rvcsid, m.fromtbl,
m.totbl, m.termid, m.dvcsid, m.bdvcsid, m.printcopy,
m.incycle,
m.syncpplsid,
r.name rvcsname,
t.name termname,
d.name dvcsname,
d2.name dvcs2name,
p.name pplsname
from ppld m
left join rvcs r on m.rvcsid = r.rvcsid
left join term t on m.termid = t.termid
left join dvcs d on m.dvcsid = d.dvcsid
left join dvcs d2 on m.dvcsid = d2.dvcsid
left join ppls p on p.pplsid = m.syncpplsid
ORDER BY ppldid
where apptype = :apptype
and m.pplsid = :pplsid