BusinessWise

Priključen projektu: BusinessWise
Otvoren od dragan - 18.11.2014
Poslednji menjao zoran - 19.01.2015

MALOPRODJA - PRESKLADISTENJE

KADA SE PRITISNE ENTER NA BROJ KALKULACIJE PROGRAM SE UKOCI, NEKAD POSLE PAR MINUTA PREDJE NA POLJE DATUM, ALI I TU OPET STOJI PAR MINUTA I PREDJE NA BROJ NALOGA, U POZADINI PRIJAVLJUE:

klasa: Preskladistenje
DELETE from STARTER.nalog where nalbr in ( select t1.nalbr from STARTER.nalog t1 left outer join (select nalozi from (select finnalog as nalozi from STARTER.finex where fingodina = 2014 AND finnalog='' union select dnalog as nalozi from STARTER.doks where dgodina = 2014 AND dnalog='' union select dmnalog as nalozi from STARTER.dokm where dmgodina = 2014 AND dmnalog='' ) t0 ) t2 ON t1.nalbr=t2.nalozi where t2.nalozi is null AND t1.naloperid=3) and nalgod=2014 AND nalbr=''
upit: select nalbr, naldat, vl, (case when nalstat=0 then '' else 'Zaključan' end) as status, ('Vlasnik : ' || vl || ' | ' || 'Status : ' || (case when nalstat=0 then 'Otključan' else 'Zaključan - '||zak end)) as tooltip, nalstat,zak, naloperid from STARTER.nalog t1 left outer join (select lozid as vid, lozime as vl from micro.loza) t2 on naloperid=vid left outer join (select lozid as zid, lozime as zak from micro.loza) t3 on nalstat=zid where nalgod = 2014 AND nalbr ='' order by nalbr desc, naldat
catch: org.postgresql.util.PSQLException: ResultSet not positioned properly, perhaps you need to call next.
upit: select nalbr, naldat, vl, (case when nalstat=0 then '' else 'Zaključan' end) as status, ('Vlasnik : ' || vl || ' | ' || 'Status : ' || (case when nalstat=0 then 'Otključan' else 'Zaključan - '||zak end)) as tooltip, nalstat,zak, naloperid from STARTER.nalog t1 left outer join (select lozid as vid, lozime as vl from micro.loza) t2 on naloperid=vid left outer join (select lozid as zid, lozime as zak from micro.loza) t3 on nalstat=zid where nalgod = 2014 AND nalbr ='' order by nalbr desc, naldat
catch: org.postgresql.util.PSQLException: ResultSet not positioned properly, perhaps you need to call next.