- Status Zatvoren
- % izvršenja
- Tip zadatka Prijava greške
- Kategorija BusinessWise → Trade
- Dodeljen Nijedan
- Operativni sistem Nebitno koji
- Važnost Kritična
- Prioritet Trenutni
- Prijavljena verzija BusinessWare 6
- Očekuje se u verziji Neodređeno
-
Rok
Neodređeno
- Glasova
- Privatno
Priključen projektu: BusinessWise
Otvoren od Dragan Ivković - 18.11.2014
Poslednji menjao Zoran Marjanović - 19.01.2015
Otvoren od Dragan Ivković - 18.11.2014
Poslednji menjao Zoran Marjanović - 19.01.2015
FS#69 - MALOPRODAJA - PRESKLADIŠTENJE
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.