Akcije
Greške #26846
Zatvoren
Kalk, import iz FMK, mi imamos mnogos problemos
Dodano od Jasmin Beganović prije više od 14 godina. Izmjenjeno prije oko 14 godina.
Početak:
22.02.2012
Završetak:
% završeno:
0%
Procjena vremena:
Opis
izbaci ovu grešku ne pojedinim dokumentima ali import se nastavlja
Izmjenjeno od Jasmin Beganović prije više od 14 godina
- Fajl f18_kalk_import_err.PNG dodano
prethodi joj
<hernad izbrisao>
f18 log s epuni ai je sada zaključan
Izmjenjeno od Ernad Husremović prije više od 14 godina
- Fajl obrisano (
f18_kalk_import_err.PNG)
Izmjenjeno od Ernad Husremović prije više od 14 godina
staviti info iz loga. screenshot je nepregledan pa sam ga izbrisao
Izmjenjeno od Jasmin Beganović prije više od 14 godina
Ernad Husremović je napisao/la:
staviti info iz loga. screenshot je nepregledan pa sam ga izbrisao
to ja da sale vidi dok se log ne oslobodi
Izmjenjeno od Jasmin Beganović prije više od 14 godina
evo loga za jedan sporni dokument 14-0660, nije ga procedura importovala nikako
DELETE FROM fmk.kalk_doks WHERE idfirma='10' AND idvd='14' AND brdok='06660 '
_sql_query VALTYPE(_ret) = O
INSERT INTO fmk.kalk_doks(nv,mpv,vpv,idvd,brdok,podbr,rabat,sifra,datdok,mkonto,pkonto,brfaktp,idfirma,idzaduz,idzaduz2,idpartner) VALUES( -114.12, 0.00, -147.57,'14','06660 ','$ ', 2.95,'áááá▒▒','2012-01-16','13202 ',' ','60856751 ','10',' ',' ','118335')
ERROR: unterminated quoted string at or near "'$"
LINE 1: ...ES( -114.12, 0.00, -147.57,'14','06660 ','$
^
INSERT INTO fmk.kalk_doks(nv,mpv,vpv,idvd,brdok,podbr,rabat,sifra,datdok,mkonto,pkonto,brfaktp,idfirma,idzaduz,idzaduz2,idpartner) VALUES( -114.12, 0.00, -147.57,'14','06660 ','$ ', 2.95,'áááá▒▒','2012-01-16','13202 ',' ','60856751 ','10',' ',' ','118335')
_sql_query VALTYPE(_ret) = L
ROLLBACK;
_sql_query VALTYPE(_ret) = O
BEGIN;
_sql_query VALTYPE(_ret) = O
DELETE FROM fmk.kalk_kalk WHERE idfirma='10' AND idvd='14' AND brdok='06660 ' AND rbr=' 1'
_sql_query VALTYPE(_ret) = O
INSERT INTO fmk.kalk_kalk(nc,fcj,mpc,rbr,vpc,fcj2,fcj3,idvd,mu_i,pu_i,brdok,error,marza,podbr,rabat,roktr,zavtr,banktr,cardaz,datdok,idroba,marza2,mkonto,pkonto,prevoz,rabatv,spedtr,tmarza,trabat,tzavtr,vpcsap,brfaktp,datkurs,idfirma,idkonto,idzaduz,mpcsapp,prevoz2,tbanktr,tcardaz,tmarza2,tprevoz,tspedtr,datfaktp,idkonto2,idtarifa,idzaduz2,kolicina,tprevoz2,gkolicin2,gkolicina,idpartner) VALUES( 0.63194956, 0.00000000, 17.00000000,' 1', 0.78000000, 0.00000000, 0.00000000,'14','5',' ','06660 ','0', 0.14805044,'$ ', 0.00000000,NULL, 0.00000000, 0.00000000, 0.00000000,'2012-01-16','K12001 ', 0.00000000,'13202 ',' ', 0.00000000, 2.00000000, 0.00000000,' ',' ',' ', 0.00000000,'60856751 ','2012-01-16','10','1200 ',' ', 0.00000000, 0.00000000,' ',' ',' ',' ',' ','2012-01-16','13202 ','PDV17 ',' ', 25.000,' ', 0.000, 0.000,'118335')
ERROR: unterminated quoted string at or near "'$"
LINE 1: ...0.00000000,'14','5',' ','06660 ','0', 0.14805044,'$
^
INSERT INTO fmk.kalk_kalk(nc,fcj,mpc,rbr,vpc,fcj2,fcj3,idvd,mu_i,pu_i,brdok,error,marza,podbr,rabat,roktr,zavtr,banktr,cardaz,datdok,idroba,marza2,mkonto,pkonto,prevoz,rabatv,spedtr,tmarza,trabat,tzavtr,vpcsap,brfaktp,datkurs,idfirma,idkonto,idzaduz,mpcsapp,prevoz2,tbanktr,tcardaz,tmarza2,tprevoz,tspedtr,datfaktp,idkonto2,idtarifa,idzaduz2,kolicina,tprevoz2,gkolicin2,gkolicina,idpartner) VALUES( 0.63194956, 0.00000000, 17.00000000,' 1', 0.78000000, 0.00000000, 0.00000000,'14','5',' ','06660 ','0', 0.14805044,'$ ', 0.00000000,NULL, 0.00000000, 0.00000000, 0.00000000,'2012-01-16','K12001 ', 0.00000000,'13202 ',' ', 0.00000000, 2.00000000, 0.00000000,' ',' ',' ', 0.00000000,'60856751 ','2012-01-16','10','1200 ',' ', 0.00000000, 0.00000000,' ',' ',' ',' ',' ','2012-01-16','13202 ','PDV17 ',' ', 25.000,' ', 0.000, 0.000,'118335')
_sql_query VALTYPE(_ret) = L
ROLLBACK;
_sql_query VALTYPE(_ret) = O
BEGIN;
_sql_query VALTYPE(_ret) = O
DELETE FROM fmk.kalk_kalk WHERE idfirma='10' AND idvd='14' AND brdok='06660 ' AND rbr=' 2'
_sql_query VALTYPE(_ret) = O
INSERT INTO fmk.kalk_kalk(nc,fcj,mpc,rbr,vpc,fcj2,fcj3,idvd,mu_i,pu_i,brdok,error,marza,podbr,rabat,roktr,zavtr,banktr,cardaz,datdok,idroba,marza2,mkonto,pkonto,prevoz,rabatv,spedtr,tmarza,trabat,tzavtr,vpcsap,brfaktp,datkurs,idfirma,idkonto,idzaduz,mpcsapp,prevoz2,tbanktr,tcardaz,tmarza2,tprevoz,tspedtr,datfaktp,idkonto2,idtarifa,idzaduz2,kolicina,tprevoz2,gkolicin2,gkolicina,idpartner) VALUES( 1.75870997, 0.00000000, 17.00000000,' 2', 2.18000000, 0.00000000, 0.00000000,'14','5',' ','06660 ','0', 0.42129003,'$ ', 0.00000000,NULL, 0.00000000, 0.00000000, 0.00000000,'2012-01-16','K12002 ', 0.00000000,'13202 ',' ', 0.00000000, 2.00000000, 0.00000000,' ',' ',' ', 0.00000000,'60856751 ','2012-01-16','10','1200 ',' ', 0.00000000, 0.00000000,' ',' ',' ',' ',' ','2012-01-16','13202 ','PDV17 ',' ', 10.000,' ', 0.000, 0.000,'118335')
ERROR: unterminated quoted string at or near "'$"
LINE 1: ...0.00000000,'14','5',' ','06660 ','0', 0.42129003,'$
^
INSERT INTO fmk.kalk_kalk(nc,fcj,mpc,rbr,vpc,fcj2,fcj3,idvd,mu_i,pu_i,brdok,error,marza,podbr,rabat,roktr,zavtr,banktr,cardaz,datdok,idroba,marza2,mkonto,pkonto,prevoz,rabatv,spedtr,tmarza,trabat,tzavtr,vpcsap,brfaktp,datkurs,idfirma,idkonto,idzaduz,mpcsapp,prevoz2,tbanktr,tcardaz,tmarza2,tprevoz,tspedtr,datfaktp,idkonto2,idtarifa,idzaduz2,kolicina,tprevoz2,gkolicin2,gkolicina,idpartner) VALUES( 1.75870997, 0.00000000, 17.00000000,' 2', 2.18000000, 0.00000000, 0.00000000,'14','5',' ','06660 ','0', 0.42129003,'$ ', 0.00000000,NULL, 0.00000000, 0.00000000, 0.00000000,'2012-01-16','K12002 ', 0.00000000,'13202 ',' ', 0.00000000, 2.00000000, 0.00000000,' ',' ',' ', 0.00000000,'60856751 ','2012-01-16','10','1200 ',' ', 0.00000000, 0.00000000,' ',' ',' ',' ',' ','2012-01-16','13202 ','PDV17 ',' ', 10.000,' ', 0.000, 0.000,'118335')
_sql_query VALTYPE(_ret) = L
ROLLBACK;
_sql_query VALTYPE(_ret) = O
BEGIN;
_sql_query VALTYPE(_ret) = O
DELETE FROM fmk.kalk_kalk WHERE idfirma='10' AND idvd='14' AND brdok='06660 ' AND rbr=' 3'
_sql_query VALTYPE(_ret) = O
INSERT INTO fmk.kalk_kalk(nc,fcj,mpc,rbr,vpc,fcj2,fcj3,idvd,mu_i,pu_i,brdok,error,marza,podbr,rabat,roktr,zavtr,banktr,cardaz,datdok,idroba,marza2,mkonto,pkonto,prevoz,rabatv,spedtr,tmarza,trabat,tzavtr,vpcsap,brfaktp,datkurs,idfirma,idkonto,idzaduz,mpcsapp,prevoz2,tbanktr,tcardaz,tmarza2,tprevoz,tspedtr,datfaktp,idkonto2,idtarifa,idzaduz2,kolicina,tprevoz2,gkolicin2,gkolicina,idpartner) VALUES( 3.64951424, 0.00000000, 17.00000000,' 3', 4.52000000, 0.00000000, 0.00000000,'14','5',' ','06660 ','0', 0.87048576,'$ ', 0.00000000,NULL, 0.00000000, 0.00000000, 0.00000000,'2012-01-16','K12075 ', 0.00000000,'13202 ',' ', 0.00000000, 2.00000000, 0.00000000,' ',' ',' ', 0.00000000,'60856751 ','2012-01-16','10','1200 ',' ', 0.00000000, 0.00000000,' ',' ',' ',' ',' ','2012-01-16','13202 ','PDV17 ',' ', 2.000,' ', 0.000, 0.000,'118335')
ERROR: unterminated quoted string at or near "'$"
LINE 1: ...0.00000000,'14','5',' ','06660 ','0', 0.87048576,'$
^
INSERT INTO fmk.kalk_kalk(nc,fcj,mpc,rbr,vpc,fcj2,fcj3,idvd,mu_i,pu_i,brdok,error,marza,podbr,rabat,roktr,zavtr,banktr,cardaz,datdok,idroba,marza2,mkonto,pkonto,prevoz,rabatv,spedtr,tmarza,trabat,tzavtr,vpcsap,brfaktp,datkurs,idfirma,idkonto,idzaduz,mpcsapp,prevoz2,tbanktr,tcardaz,tmarza2,tprevoz,tspedtr,datfaktp,idkonto2,idtarifa,idzaduz2,kolicina,tprevoz2,gkolicin2,gkolicina,idpartner) VALUES( 3.64951424, 0.00000000, 17.00000000,' 3', 4.52000000, 0.00000000, 0.00000000,'14','5',' ','06660 ','0', 0.87048576,'$ ', 0.00000000,NULL, 0.00000000, 0.00000000, 0.00000000,'2012-01-16','K12075 ', 0.00000000,'13202 ',' ', 0.00000000, 2.00000000, 0.00000000,' ',' ',' ', 0.00000000,'60856751 ','2012-01-16','10','1200 ',' ', 0.00000000, 0.00000000,' ',' ',' ',' ',' ','2012-01-16','13202 ','PDV17 ',' ', 2.000,' ', 0.000, 0.000,'118335')
_sql_query VALTYPE(_ret) = L
ROLLBACK;
_sql_query VALTYPE(_ret) = O
BEGIN;
_sql_query VALTYPE(_ret) = O
DELETE FROM fmk.kalk_kalk WHERE idfirma='10' AND idvd='14' AND brdok='06660 ' AND rbr=' 4'
_sql_query VALTYPE(_ret) = O
INSERT INTO fmk.kalk_kalk(nc,fcj,mpc,rbr,vpc,fcj2,fcj3,idvd,mu_i,pu_i,brdok,error,marza,podbr,rabat,roktr,zavtr,banktr,cardaz,datdok,idroba,marza2,mkonto,pkonto,prevoz,rabatv,spedtr,tmarza,trabat,tzavtr,vpcsap,brfaktp,datkurs,idfirma,idkonto,idzaduz,mpcsapp,prevoz2,tbanktr,tcardaz,tmarza2,tprevoz,tspedtr,datfaktp,idkonto2,idtarifa,idzaduz2,kolicina,tprevoz2,gkolicin2,gkolicina,idpartner) VALUES( 2.07311251, 0.00000000, 17.00000000,' 4', 2.69000000, 0.00000000, 0.00000000,'14','5',' ','06660 ','0', 0.61688749,'$ ', 0.00000000,NULL, 0.00000000, 0.00000000, 0.00000000,'2012-01-16','K12502 ', 0.00000000,'13202 ',' ', 0.00000000, 2.00000000, 0.00000000,' ',' ',' ', 0.00000000,'60856751 ','2012-01-16','10','1200 ',' ', 0.00000000, 0.00000000,' ',' ',' ',' ',' ','2012-01-16','13202 ','PDV17 ',' ', 6.000,' ', 0.000, 0.000,'118335')
ERROR: unterminated quoted string at or near "'$"
LINE 1: ...0.00000000,'14','5',' ','06660 ','0', 0.61688749,'$
^
INSERT INTO fmk.kalk_kalk(nc,fcj,mpc,rbr,vpc,fcj2,fcj3,idvd,mu_i,pu_i,brdok,error,marza,podbr,rabat,roktr,zavtr,banktr,cardaz,datdok,idroba,marza2,mkonto,pkonto,prevoz,rabatv,spedtr,tmarza,trabat,tzavtr,vpcsap,brfaktp,datkurs,idfirma,idkonto,idzaduz,mpcsapp,prevoz2,tbanktr,tcardaz,tmarza2,tprevoz,tspedtr,datfaktp,idkonto2,idtarifa,idzaduz2,kolicina,tprevoz2,gkolicin2,gkolicina,idpartner) VALUES( 2.07311251, 0.00000000, 17.00000000,' 4', 2.69000000, 0.00000000, 0.00000000,'14','5',' ','06660 ','0', 0.61688749,'$ ', 0.00000000,NULL, 0.00000000, 0.00000000, 0.00000000,'2012-01-16','K12502 ', 0.00000000,'13202 ',' ', 0.00000000, 2.00000000, 0.00000000,' ',' ',' ', 0.00000000,'60856751 ','2012-01-16','10','1200 ',' ', 0.00000000, 0.00000000,' ',' ',' ',' ',' ','2012-01-16','13202 ','PDV17 ',' ', 6.000,' ', 0.000, 0.000,'118335')
_sql_query VALTYPE(_ret) = L
ROLLBACK;
_sql_query VALTYPE(_ret) = O
BEGIN;
_sql_query VALTYPE(_ret) = O
DELETE FROM fmk.kalk_kalk WHERE idfirma='10' AND idvd='14' AND brdok='06660 ' AND rbr=' 5'
_sql_query VALTYPE(_ret) = O
INSERT INTO fmk.kalk_kalk(nc,fcj,mpc,rbr,vpc,fcj2,fcj3,idvd,mu_i,pu_i,brdok,error,marza,podbr,rabat,roktr,zavtr,banktr,cardaz,datdok,idroba,marza2,mkonto,pkonto,prevoz,rabatv,spedtr,tmarza,trabat,tzavtr,vpcsap,brfaktp,datkurs,idfirma,idkonto,idzaduz,mpcsapp,prevoz2,tbanktr,tcardaz,tmarza2,tprevoz,tspedtr,datfaktp,idkonto2,idtarifa,idzaduz2,kolicina,tprevoz2,gkolicin2,gkolicina,idpartner) VALUES( 1.40269208, 0.00000000, 17.00000000,' 5', 1.71000000, 0.00000000, 0.00000000,'14','5',' ','06660 ','0', 0.30730792,'$ ', 0.00000000,NULL, 0.00000000, 0.00000000, 0.00000000,'2012-01-16','V093017 ', 0.00000000,'13202 ',' ', 0.00000000, 2.00000000, 0.00000000,' ',' ',' ', 0.00000000,'60856751 ','2012-01-16','10','1200 ',' ', 0.00000000, 0.00000000,' ',' ',' ',' ',' ','2012-01-16','13202 ','PDV17 ',' ', 12.000,' ', 0.000, 0.000,'118335')
ERROR: unterminated quoted string at or near "'$"
LINE 1: ...0.00000000,'14','5',' ','06660 ','0', 0.30730792,'$
^
INSERT INTO fmk.kalk_kalk(nc,fcj,mpc,rbr,vpc,fcj2,fcj3,idvd,mu_i,pu_i,brdok,error,marza,podbr,rabat,roktr,zavtr,banktr,cardaz,datdok,idroba,marza2,mkonto,pkonto,prevoz,rabatv,spedtr,tmarza,trabat,tzavtr,vpcsap,brfaktp,datkurs,idfirma,idkonto,idzaduz,mpcsapp,prevoz2,tbanktr,tcardaz,tmarza2,tprevoz,tspedtr,datfaktp,idkonto2,idtarifa,idzaduz2,kolicina,tprevoz2,gkolicin2,gkolicina,idpartner) VALUES( 1.40269208, 0.00000000, 17.00000000,' 5', 1.71000000, 0.00000000, 0.00000000,'14','5',' ','06660 ','0', 0.30730792,'$ ', 0.00000000,NULL, 0.00000000, 0.00000000, 0.00000000,'2012-01-16','V093017 ', 0.00000000,'13202 ',' ', 0.00000000, 2.00000000, 0.00000000,' ',' ',' ', 0.00000000,'60856751 ','2012-01-16','10','1200 ',' ', 0.00000000, 0.00000000,' ',' ',' ',' ',' ','2012-01-16','13202 ','PDV17 ',' ', 12.000,' ', 0.000, 0.000,'118335')
_sql_query VALTYPE(_ret) = L
ROLLBACK;
_sql_query VALTYPE(_ret) = O
BEGIN;
_sql_query VALTYPE(_ret) = O
DELETE FROM fmk.kalk_kalk WHERE idfirma='10' AND idvd='14' AND brdok='06660 ' AND rbr=' 6'
_sql_query VALTYPE(_ret) = O
INSERT INTO fmk.kalk_kalk(nc,fcj,mpc,rbr,vpc,fcj2,fcj3,idvd,mu_i,pu_i,brdok,error,marza,podbr,rabat,roktr,zavtr,banktr,cardaz,datdok,idroba,marza2,mkonto,pkonto,prevoz,rabatv,spedtr,tmarza,trabat,tzavtr,vpcsap,brfaktp,datkurs,idfirma,idkonto,idzaduz,mpcsapp,prevoz2,tbanktr,tcardaz,tmarza2,tprevoz,tspedtr,datfaktp,idkonto2,idtarifa,idzaduz2,kolicina,tprevoz2,gkolicin2,gkolicina,idpartner) VALUES( 0.40125700, 0.00000000, 17.00000000,' 6', 0.52000000, 0.00000000, 0.00000000,'14','5',' ','06660 ','0', 0.11874300,'$ ', 0.00000000,NULL, 0.00000000, 0.00000000, 0.00000000,'2012-01-16','V053052 ', 0.00000000,'13202 ',' ', 0.00000000, 2.00000000, 0.00000000,' ',' ',' ', 0.00000000,'60856751 ','2012-01-16','10','1200 ',' ', 0.00000000, 0.00000000,' ',' ',' ',' ',' ','2012-01-16','13202 ','PDV17 ',' ', 20.000,' ', 0.000, 0.000,'118335')
ERROR: unterminated quoted string at or near "'$"
LINE 1: ...0.00000000,'14','5',' ','06660 ','0', 0.11874300,'$
^
INSERT INTO fmk.kalk_kalk(nc,fcj,mpc,rbr,vpc,fcj2,fcj3,idvd,mu_i,pu_i,brdok,error,marza,podbr,rabat,roktr,zavtr,banktr,cardaz,datdok,idroba,marza2,mkonto,pkonto,prevoz,rabatv,spedtr,tmarza,trabat,tzavtr,vpcsap,brfaktp,datkurs,idfirma,idkonto,idzaduz,mpcsapp,prevoz2,tbanktr,tcardaz,tmarza2,tprevoz,tspedtr,datfaktp,idkonto2,idtarifa,idzaduz2,kolicina,tprevoz2,gkolicin2,gkolicina,idpartner) VALUES( 0.40125700, 0.00000000, 17.00000000,' 6', 0.52000000, 0.00000000, 0.00000000,'14','5',' ','06660 ','0', 0.11874300,'$ ', 0.00000000,NULL, 0.00000000, 0.00000000, 0.00000000,'2012-01-16','V053052 ', 0.00000000,'13202 ',' ', 0.00000000, 2.00000000, 0.00000000,' ',' ',' ', 0.00000000,'60856751 ','2012-01-16','10','1200 ',' ', 0.00000000, 0.00000000,' ',' ',' ',' ',' ','2012-01-16','13202 ','PDV17 ',' ', 20.000,' ', 0.000, 0.000,'118335')
_sql_query VALTYPE(_ret) = L
ROLLBACK;
_sql_query VALTYPE(_ret) = O
BEGIN;
_sql_query VALTYPE(_ret) = O
DELETE FROM fmk.kalk_kalk WHERE idfirma='10' AND idvd='14' AND brdok='06660 ' AND rbr=' 7'
_sql_query VALTYPE(_ret) = O
INSERT INTO fmk.kalk_kalk(nc,fcj,mpc,rbr,vpc,fcj2,fcj3,idvd,mu_i,pu_i,brdok,error,marza,podbr,rabat,roktr,zavtr,banktr,cardaz,datdok,idroba,marza2,mkonto,pkonto,prevoz,rabatv,spedtr,tmarza,trabat,tzavtr,vpcsap,brfaktp,datkurs,idfirma,idkonto,idzaduz,mpcsapp,prevoz2,tbanktr,tcardaz,tmarza2,tprevoz,tspedtr,datfaktp,idkonto2,idtarifa,idzaduz2,kolicina,tprevoz2,gkolicin2,gkolicina,idpartner) VALUES( 0.56240960, 0.00000000, 17.00000000,' 7', 0.69000000, 0.00000000, 0.00000000,'14','5',' ','06660 ','0', 0.12759040,'$ ', 0.00000000,NULL, 0.00000000, 0.00000000, 0.00000000,'2012-01-16','V053310 ', 0.00000000,'13202 ',' ', 0.00000000, 2.00000000, 0.00000000,' ',' ',' ', 0.00000000,'60856751 ','2012-01-16','10','1200 ',' ', 0.00000000, 0.00000000,' ',' ',' ',' ',' ','2012-01-16','13202 ','PDV17 ',' ', 5.000,' ', 0.000, 0.000,'118335')
ERROR: unterminated quoted string at or near "'$"
LINE 1: ...0.00000000,'14','5',' ','06660 ','0', 0.12759040,'$
^
INSERT INTO fmk.kalk_kalk(nc,fcj,mpc,rbr,vpc,fcj2,fcj3,idvd,mu_i,pu_i,brdok,error,marza,podbr,rabat,roktr,zavtr,banktr,cardaz,datdok,idroba,marza2,mkonto,pkonto,prevoz,rabatv,spedtr,tmarza,trabat,tzavtr,vpcsap,brfaktp,datkurs,idfirma,idkonto,idzaduz,mpcsapp,prevoz2,tbanktr,tcardaz,tmarza2,tprevoz,tspedtr,datfaktp,idkonto2,idtarifa,idzaduz2,kolicina,tprevoz2,gkolicin2,gkolicina,idpartner) VALUES( 0.56240960, 0.00000000, 17.00000000,' 7', 0.69000000, 0.00000000, 0.00000000,'14','5',' ','06660 ','0', 0.12759040,'$ ', 0.00000000,NULL, 0.00000000, 0.00000000, 0.00000000,'2012-01-16','V053310 ', 0.00000000,'13202 ',' ', 0.00000000, 2.00000000, 0.00000000,' ',' ',' ', 0.00000000,'60856751 ','2012-01-16','10','1200 ',' ', 0.00000000, 0.00000000,' ',' ',' ',' ',' ','2012-01-16','13202 ','PDV17 ',' ', 5.000,' ', 0.000, 0.000,'118335')
_sql_query VALTYPE(_ret) = L
ROLLBACK;
_sql_query VALTYPE(_ret) = O
BEGIN;
_sql_query VALTYPE(_ret) = O
DELETE FROM fmk.kalk_kalk WHERE idfirma='10' AND idvd='14' AND brdok='06660 ' AND rbr=' 8'
_sql_query VALTYPE(_ret) = O
INSERT INTO fmk.kalk_kalk(nc,fcj,mpc,rbr,vpc,fcj2,fcj3,idvd,mu_i,pu_i,brdok,error,marza,podbr,rabat,roktr,zavtr,banktr,cardaz,datdok,idroba,marza2,mkonto,pkonto,prevoz,rabatv,spedtr,tmarza,trabat,tzavtr,vpcsap,brfaktp,datkurs,idfirma,idkonto,idzaduz,mpcsapp,prevoz2,tbanktr,tcardaz,tmarza2,tprevoz,tspedtr,datfaktp,idkonto2,idtarifa,idzaduz2,kolicina,tprevoz2,gkolicin2,gkolicina,idpartner) VALUES( 0.61816183, 0.00000000, 17.00000000,' 8', 1.28000000, 0.00000000, 0.00000000,'14','5',' ','06660 ','0', 0.66183817,'$ ', 0.00000000,NULL, 0.00000000, 0.00000000, 0.00000000,'2012-01-16','V053648 ', 0.00000000,'13202 ',' ', 0.00000000, 2.00000000, 0.00000000,' ',' ',' ', 0.00000000,'60856751 ','2012-01-16','10','1200 ',' ', 0.00000000, 0.00000000,' ',' ',' ',' ',' ','2012-01-16','13202 ','PDV17 ',' ', 12.000,' ', 0.000, 0.000,'118335')
ERROR: unterminated quoted string at or near "'$"
LINE 1: ...0.00000000,'14','5',' ','06660 ','0', 0.66183817,'$
^
INSERT INTO fmk.kalk_kalk(nc,fcj,mpc,rbr,vpc,fcj2,fcj3,idvd,mu_i,pu_i,brdok,error,marza,podbr,rabat,roktr,zavtr,banktr,cardaz,datdok,idroba,marza2,mkonto,pkonto,prevoz,rabatv,spedtr,tmarza,trabat,tzavtr,vpcsap,brfaktp,datkurs,idfirma,idkonto,idzaduz,mpcsapp,prevoz2,tbanktr,tcardaz,tmarza2,tprevoz,tspedtr,datfaktp,idkonto2,idtarifa,idzaduz2,kolicina,tprevoz2,gkolicin2,gkolicina,idpartner) VALUES( 0.61816183, 0.00000000, 17.00000000,' 8', 1.28000000, 0.00000000, 0.00000000,'14','5',' ','06660 ','0', 0.66183817,'$ ', 0.00000000,NULL, 0.00000000, 0.00000000, 0.00000000,'2012-01-16','V053648 ', 0.00000000,'13202 ',' ', 0.00000000, 2.00000000, 0.00000000,' ',' ',' ', 0.00000000,'60856751 ','2012-01-16','10','1200 ',' ', 0.00000000, 0.00000000,' ',' ',' ',' ',' ','2012-01-16','13202 ','PDV17 ',' ', 12.000,' ', 0.000, 0.000,'118335')
_sql_query VALTYPE(_ret) = L
ROLLBACK;
_sql_query VALTYPE(_ret) = O
BEGIN;
_sql_query VALTYPE(_ret) = O
DELETE FROM fmk.kalk_kalk WHERE idfirma='10' AND idvd='14' AND brdok='06660 ' AND rbr=' 9'
_sql_query VALTYPE(_ret) = O
INSERT INTO fmk.kalk_kalk(nc,fcj,mpc,rbr,vpc,fcj2,fcj3,idvd,mu_i,pu_i,brdok,error,marza,podbr,rabat,roktr,zavtr,banktr,cardaz,datdok,idroba,marza2,mkonto,pkonto,prevoz,rabatv,spedtr,tmarza,trabat,tzavtr,vpcsap,brfaktp,datkurs,idfirma,idkonto,idzaduz,mpcsapp,prevoz2,tbanktr,tcardaz,tmarza2,tprevoz,tspedtr,datfaktp,idkonto2,idtarifa,idzaduz2,kolicina,tprevoz2,gkolicin2,gkolicina,idpartner) VALUES( 0.32199438, 0.00000000, 17.00000000,' 9', 0.39000000, 0.00000000, 0.00000000,'14','5',' ','06660 ','0', 0.06800562,'$ ', 0.00000000,NULL, 0.00000000, 0.00000000, 0.00000000,'2012-01-16','V177620 ', 0.00000000,'13202 ',' ', 0.00000000, 2.00000000, 0.00000000,' ',' ',' ', 0.00000000,'60856751 ','2012-01-16','10','1200 ',' ', 0.00000000, 0.00000000,' ',' ',' ',' ',' ','2012-01-16','13202 ','PDV17 ',' ', 24.000,' ', 0.000, 0.000,'118335')
ERROR: unterminated quoted string at or near "'$"
LINE 1: ...0.00000000,'14','5',' ','06660 ','0', 0.06800562,'$
^
INSERT INTO fmk.kalk_kalk(nc,fcj,mpc,rbr,vpc,fcj2,fcj3,idvd,mu_i,pu_i,brdok,error,marza,podbr,rabat,roktr,zavtr,banktr,cardaz,datdok,idroba,marza2,mkonto,pkonto,prevoz,rabatv,spedtr,tmarza,trabat,tzavtr,vpcsap,brfaktp,datkurs,idfirma,idkonto,idzaduz,mpcsapp,prevoz2,tbanktr,tcardaz,tmarza2,tprevoz,tspedtr,datfaktp,idkonto2,idtarifa,idzaduz2,kolicina,tprevoz2,gkolicin2,gkolicina,idpartner) VALUES( 0.32199438, 0.00000000, 17.00000000,' 9', 0.39000000, 0.00000000, 0.00000000,'14','5',' ','06660 ','0', 0.06800562,'$ ', 0.00000000,NULL, 0.00000000, 0.00000000, 0.00000000,'2012-01-16','V177620 ', 0.00000000,'13202 ',' ', 0.00000000, 2.00000000, 0.00000000,' ',' ',' ', 0.00000000,'60856751 ','2012-01-16','10','1200 ',' ', 0.00000000, 0.00000000,' ',' ',' ',' ',' ','2012-01-16','13202 ','PDV17 ',' ', 24.000,' ', 0.000, 0.000,'118335')
_sql_query VALTYPE(_ret) = L
ROLLBACK;
_sql_query VALTYPE(_ret) = O
BEGIN;
_sql_query VALTYPE(_ret) = O
DELETE FROM fmk.kalk_kalk WHERE idfirma='10' AND idvd='14' AND brdok='06660 ' AND rbr=' 10'
_sql_query VALTYPE(_ret) = O
INSERT INTO fmk.kalk_kalk(nc,fcj,mpc,rbr,vpc,fcj2,fcj3,idvd,mu_i,pu_i,brdok,error,marza,podbr,rabat,roktr,zavtr,banktr,cardaz,datdok,idroba,marza2,mkonto,pkonto,prevoz,rabatv,spedtr,tmarza,trabat,tzavtr,vpcsap,brfaktp,datkurs,idfirma,idkonto,idzaduz,mpcsapp,prevoz2,tbanktr,tcardaz,tmarza2,tprevoz,tspedtr,datfaktp,idkonto2,idtarifa,idzaduz2,kolicina,tprevoz2,gkolicin2,gkolicina,idpartner) VALUES( 0.32207625, 0.00000000, 17.00000000,' 10', 0.39000000, 0.00000000, 0.00000000,'14','5',' ','06660 ','0', 0.06792375,'$ ', 0.00000000,NULL, 0.00000000, 0.00000000, 0.00000000,'2012-01-16','V177720 ', 0.00000000,'13202 ',' ', 0.00000000, 2.00000000, 0.00000000,' ',' ',' ', 0.00000000,'60856751 ','2012-01-16','10','1200 ',' ', 0.00000000, 0.00000000,' ',' ',' ',' ',' ','2012-01-16','13202 ','PDV17 ',' ', 24.000,' ', 0.000, 0.000,'118335')
ERROR: unterminated quoted string at or near "'$"
LINE 1: ...0.00000000,'14','5',' ','06660 ','0', 0.06792375,'$
^
INSERT INTO fmk.kalk_kalk(nc,fcj,mpc,rbr,vpc,fcj2,fcj3,idvd,mu_i,pu_i,brdok,error,marza,podbr,rabat,roktr,zavtr,banktr,cardaz,datdok,idroba,marza2,mkonto,pkonto,prevoz,rabatv,spedtr,tmarza,trabat,tzavtr,vpcsap,brfaktp,datkurs,idfirma,idkonto,idzaduz,mpcsapp,prevoz2,tbanktr,tcardaz,tmarza2,tprevoz,tspedtr,datfaktp,idkonto2,idtarifa,idzaduz2,kolicina,tprevoz2,gkolicin2,gkolicina,idpartner) VALUES( 0.32207625, 0.00000000, 17.00000000,' 10', 0.39000000, 0.00000000, 0.00000000,'14','5',' ','06660 ','0', 0.06792375,'$ ', 0.00000000,NULL, 0.00000000, 0.00000000, 0.00000000,'2012-01-16','V177720 ', 0.00000000,'13202 ',' ', 0.00000000, 2.00000000, 0.00000000,' ',' ',' ', 0.00000000,'60856751 ','2012-01-16','10','1200 ',' ', 0.00000000, 0.00000000,' ',' ',' ',' ',' ','2012-01-16','13202 ','PDV17 ',' ', 24.000,' ', 0.000, 0.000,'118335')
_sql_query VALTYPE(_ret) = L
ROLLBACK;
_sql_query VALTYPE(_ret) = O
BEGIN;
_sql_query VALTYPE(_ret) = O
DELETE FROM fmk.kalk_kalk WHERE idfirma='10' AND idvd='14' AND brdok='06660 ' AND rbr=' 11'
_sql_query VALTYPE(_ret) = O
INSERT INTO fmk.kalk_kalk(nc,fcj,mpc,rbr,vpc,fcj2,fcj3,idvd,mu_i,pu_i,brdok,error,marza,podbr,rabat,roktr,zavtr,banktr,cardaz,datdok,idroba,marza2,mkonto,pkonto,prevoz,rabatv,spedtr,tmarza,trabat,tzavtr,vpcsap,brfaktp,datkurs,idfirma,idkonto,idzaduz,mpcsapp,prevoz2,tbanktr,tcardaz,tmarza2,tprevoz,tspedtr,datfaktp,idkonto2,idtarifa,idzaduz2,kolicina,tprevoz2,gkolicin2,gkolicina,idpartner) VALUES( 0.65318132, 0.00000000, 17.00000000,' 11', 0.79000000, 0.00000000, 0.00000000,'14','5',' ','06660 ','0', 0.13681868,'$ ', 0.00000000,NULL, 0.00000000, 0.00000000, 0.00000000,'2012-01-16','V267729 ', 0.00000000,'13202 ',' ', 0.00000000, 2.00000000, 0.00000000,' ',' ',' ', 0.00000000,'60856751 ','2012-01-16','10','1200 ',' ', 0.00000000, 0.00000000,' ',' ',' ',' ',' ','2012-01-16','13202 ','PDV17 ',' ', 16.000,' ', 0.000, 0.000,'118335')
ERROR: unterminated quoted string at or near "'$"
LINE 1: ...0.00000000,'14','5',' ','06660 ','0', 0.13681868,'$
^
INSERT INTO fmk.kalk_kalk(nc,fcj,mpc,rbr,vpc,fcj2,fcj3,idvd,mu_i,pu_i,brdok,error,marza,podbr,rabat,roktr,zavtr,banktr,cardaz,datdok,idroba,marza2,mkonto,pkonto,prevoz,rabatv,spedtr,tmarza,trabat,tzavtr,vpcsap,brfaktp,datkurs,idfirma,idkonto,idzaduz,mpcsapp,prevoz2,tbanktr,tcardaz,tmarza2,tprevoz,tspedtr,datfaktp,idkonto2,idtarifa,idzaduz2,kolicina,tprevoz2,gkolicin2,gkolicina,idpartner) VALUES( 0.65318132, 0.00000000, 17.00000000,' 11', 0.79000000, 0.00000000, 0.00000000,'14','5',' ','06660 ','0', 0.13681868,'$ ', 0.00000000,NULL, 0.00000000, 0.00000000, 0.00000000,'2012-01-16','V267729 ', 0.00000000,'13202 ',' ', 0.00000000, 2.00000000, 0.00000000,' ',' ',' ', 0.00000000,'60856751 ','2012-01-16','10','1200 ',' ', 0.00000000, 0.00000000,' ',' ',' ',' ',' ','2012-01-16','13202 ','PDV17 ',' ', 16.000,' ', 0.000, 0.000,'118335')
_sql_query VALTYPE(_ret) = L
ROLLBACK;
Izmjenjeno od Saša Vranić prije više od 14 godina
To je polje "podbr"
LINE 1: ...0.00000000,'14','5',' ','06660 ','0', 0.13681868,'$
I šta u njemu radi znak dolar ???
Izmjenjeno od Saša Vranić prije više od 14 godina
Fakat u DBF-u postoji !!!
Dobro, napravio sam resetovanje ovog polja kod importa, commit
Izmjenjeno od Saša Vranić prije više od 14 godina
- Odgovorna osoba promijenjeno iz Saša Vranić u Jasmin Beganović
Sada više neće biti problema
Izmjenjeno od Jasmin Beganović prije oko 14 godina
- Status promijenjeno iz Novo u Zatvoreno
Akcije