Projekat

Općenito

Profil

Akcije
Copy link

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.

Status:
Zatvoreno
Prioritet:
Normalan
Odgovorna osoba:
Jasmin Beganović
Početak:
22.02.2012
Završetak:
% završeno:

0%

Procjena vremena:

Opis

izbaci ovu grešku ne pojedinim dokumentima ali import se nastavlja

Akcije
Copy link
 #1

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

Akcije
Copy link
 #2

Izmjenjeno od Ernad Husremović prije više od 14 godina

  • Fajl obrisano (f18_kalk_import_err.PNG)
Akcije
Copy link
 #3

Izmjenjeno od Ernad Husremović prije više od 14 godina

staviti info iz loga. screenshot je nepregledan pa sam ga izbrisao

Akcije
Copy link
 #4

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

Akcije
Copy link
 #5

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;
Akcije
Copy link
 #6

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 ???

Akcije
Copy link
 #7

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

Akcije
Copy link
 #8

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

Akcije
Copy link
 #9

Izmjenjeno od Jasmin Beganović prije oko 14 godina

  • Status promijenjeno iz Novo u Zatvoreno
Akcije
Copy link

Također dostupno kao Atom PDF