== F18 start: 09.04.12 / 15:56:58 ==
setovanje ekrana: setovan ekran po rezoluciji
server connection ok: vsasa / cago_2011
home baze: /Users/bringout/.f18/cago_2011/
Ne postoji ini fajl /Users/bringout/.f18/cago_2011/.f18_config.ini
Fajl je prazan: /Users/bringout/.f18/cago_2011/.f18_config.ini
current dbf version:         0
    F18 dbf version:       406
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/ops.dbf, ID
index on id / ID / /Users/bringout/.f18/cago_2011/ops / alias=ops / used() = .T.
BEGIN;
_sql_query VALTYPE(_ret) = O
my_use table:banke / rdd: SEMAPHORE alias: BANKE exclusive: .T. new: .F.
qry: SELECT id,match_code,naz,mjesto,adresa FROM fmk.banke ORDER BY id LIMIT      15000 OFFSET          0
banke updated from sql server rec_cnt: 7
banke synchro cache:          0.11
update_semaphore_version banke ver: -1/ last_ver: 0
ret[qry]=(array): 1 / ?U? ; 
ret[ids]=(array): 1 / ?U? ; 
ids_synchro - ids_queries: (hash): ids / (array): 1 / ?U? ;  ; qry / (array): 1 / ?U? ;  ; 
COMMIT;
_sql_query VALTYPE(_ret) = O
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/banke.dbf, ID
index on id / ID / /Users/bringout/.f18/cago_2011/banke / alias=banke / used() = .T.
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/banke.dbf, NAZ
index on naz / NAZ / /Users/bringout/.f18/cago_2011/banke / alias=banke / used() = .T.
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/rnal.dbf, ID
index on id / ID / /Users/bringout/.f18/cago_2011/rnal / alias=rnal / used() = .T.
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/rnal.dbf, NAZ
index on naz / NAZ / /Users/bringout/.f18/cago_2011/rnal / alias=rnal / used() = .T.
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/refer.dbf, ID
index on id / ID / /Users/bringout/.f18/cago_2011/refer / alias=refer / used() = .T.
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/refer.dbf, NAZ
index on naz / NAZ / /Users/bringout/.f18/cago_2011/refer / alias=refer / used() = .T.
BEGIN;
_sql_query VALTYPE(_ret) = O
my_use table:vrstep / rdd: SEMAPHORE alias: VRSTEP exclusive: .T. new: .F.
qry: SELECT id,naz FROM fmk.vrstep ORDER BY id LIMIT      15000 OFFSET          0
vrstep updated from sql server rec_cnt: 0
vrstep synchro cache:          0.05
update_semaphore_version vrstep ver: -1/ last_ver: 0
ret[qry]=(array): 1 / ?U? ; 
ret[ids]=(array): 1 / ?U? ; 
ids_synchro - ids_queries: (hash): ids / (array): 1 / ?U? ;  ; qry / (array): 1 / ?U? ;  ; 
COMMIT;
_sql_query VALTYPE(_ret) = O
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/vrstep.dbf, ID
index on Id / ID / /Users/bringout/.f18/cago_2011/vrstep / alias=VRSTEP / used() = .T.
BEGIN;
_sql_query VALTYPE(_ret) = O
my_use table:lokal / rdd: SEMAPHORE alias: LOKAL exclusive: .T. new: .F.
qry: SELECT id,id_str,naz FROM fmk.lokal ORDER BY id LIMIT      15000 OFFSET          0
lokal updated from sql server rec_cnt: 0
lokal synchro cache:          0.02
update_semaphore_version lokal ver: -1/ last_ver: 0
ret[qry]=(array): 1 / ?U? ; 
ret[ids]=(array): 1 / ?U? ; 
ids_synchro - ids_queries: (hash): ids / (array): 1 / ?U? ;  ; qry / (array): 1 / ?U? ;  ; 
COMMIT;
_sql_query VALTYPE(_ret) = O
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/lokal.dbf, ID
index on id+STR(id_str,6,0)+naz / ID / /Users/bringout/.f18/cago_2011/lokal / alias=LOKAL / used() = .T.
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/lokal.dbf, IDNAZ
index on id+naz / IDNAZ / /Users/bringout/.f18/cago_2011/lokal / alias=LOKAL / used() = .T.
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/lokal.dbf, ID_STR
index on STR(id_str,6,0)+naz+id / ID_STR / /Users/bringout/.f18/cago_2011/lokal / alias=LOKAL / used() = .T.
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/lokal.dbf, NAZ
index on naz+str(id_str,6,0) / NAZ / /Users/bringout/.f18/cago_2011/lokal / alias=LOKAL / used() = .T.
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/doksrc.dbf, 1
index on idfirma+idvd+brdok+DTOS(datdok)+src_modul+src_idfirm+src_idvd+src_brdok+DTOS(src_datdok) / 1 / /Users/bringout/.f18/cago_2011/doksrc / alias=DOKSRC / used() = .T.
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/doksrc.dbf, 2
index on src_modul+src_idfirm+src_idvd+src_brdok+DTOS(src_datdok) / 2 / /Users/bringout/.f18/cago_2011/doksrc / alias=DOKSRC / used() = .T.
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/p_doksrc.dbf, 1
index on idfirma+idvd+brdok+DTOS(datdok)+src_modul+src_idfirm+src_idvd+src_brdok+DTOS(src_datdok) / 1 / /Users/bringout/.f18/cago_2011/p_doksrc / alias=P_DOKSRC / used() = .T.
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/p_doksrc.dbf, 2
index on src_modul+src_idfirm+src_idvd+src_brdok+DTOS(src_datdok) / 2 / /Users/bringout/.f18/cago_2011/p_doksrc / alias=P_DOKSRC / used() = .T.
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/p_update.dbf, 1
index on modul+idkonto+p_updated / 1 / /Users/bringout/.f18/cago_2011/p_update / alias=P_UPDATE / used() = .T.
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/relation.dbf, 1
index on TFROM+TTO+TFROMID / 1 / /Users/bringout/.f18/cago_2011/relation / alias=RELATION / used() = .T.
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/relation.dbf, 2
index on TTO+TFROM+TTOID / 2 / /Users/bringout/.f18/cago_2011/relation / alias=RELATION / used() = .T.
BEGIN;
_sql_query VALTYPE(_ret) = O
my_use table:f18_rules / rdd: SEMAPHORE alias: FMKRULES exclusive: .T. new: .F.
qry: SELECT rule_id,modul_name,rule_obj,rule_no,rule_name,rule_ermsg,rule_level,rule_c1,rule_c2,rule_c3,rule_c4,rule_c5,rule_c6,rule_c7,rule_n1,rule_n2,rule_n3,rule_d1,rule_d2 FROM fmk.f18_rules ORDER BY rule_id LIMIT      15000 OFFSET          0
f18_rules updated from sql server rec_cnt: 0
f18_rules synchro cache:          0.04
update_semaphore_version f18_rules ver: -1/ last_ver: 0
ret[qry]=(array): 1 / ?U? ; 
ret[ids]=(array): 1 / ?U? ; 
ids_synchro - ids_queries: (hash): ids / (array): 1 / ?U? ;  ; qry / (array): 1 / ?U? ;  ; 
COMMIT;
_sql_query VALTYPE(_ret) = O
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/f18_rules.dbf, 1
index on STR(RULE_ID,10) / 1 / /Users/bringout/.f18/cago_2011/f18_rules / alias=fmkrules / used() = .T.
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/f18_rules.dbf, 2
index on MODUL_NAME+RULE_OBJ+STR(RULE_NO,10) / 2 / /Users/bringout/.f18/cago_2011/f18_rules / alias=fmkrules / used() = .T.
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/f18_rules.dbf, 3
index on MODUL_NAME+RULE_OBJ+STR(RULE_LEVEL,2)+STR(RULE_NO,10) / 3 / /Users/bringout/.f18/cago_2011/f18_rules / alias=fmkrules / used() = .T.
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/f18_rules.dbf, 4
index on MODUL_NAME+RULE_OBJ+RULE_C1+RULE_C2 / 4 / /Users/bringout/.f18/cago_2011/f18_rules / alias=fmkrules / used() = .T.
modifikacija struktura - start
ime fajla: /Users/bringout/.f18/cago_2011/roba
Greska: Polje IDKONTO vec postoji u DBF-u, linija: IDKONTO C 7 0
modstru problem :roba
BEGIN;
_sql_query VALTYPE(_ret) = O
my_use table:roba / rdd: SEMAPHORE alias: ROBA exclusive: .T. new: .F.
qry: SELECT id,sifradob,match_code,naz,strings,jmj,idtarifa,nc,vpc,vpc2,plc,mpc,mpc2,mpc3,k1,k2,k7,k8,k9,n1,n2,tip,mink,opis,barkod,fisc_plu,zanivel,zaniv2,trosk1,trosk2,trosk3,trosk4,trosk5,idkonto FROM fmk.roba ORDER BY id LIMIT      15000 OFFSET          0
roba updated from sql server rec_cnt: 6807
roba synchro cache:          5.95
update_semaphore_version roba ver: -1/ last_ver: 1
ret[qry]=(array): 1 / SELECT id,sifradob,match_code,naz,strings,jmj,idtarifa,nc,vpc,vpc2,plc,mpc,mpc2,mpc3,k1,k2,k7,k8,k9,n1,n2,tip,mink,opis,barkod,fisc_plu,zanivel,zaniv2,trosk1,trosk2,trosk3,trosk4,trosk5,idkonto FROM fmk.roba WHERE (id) IN ('10032     ') ; 
ret[ids]=(array): 1 / (array): 1 / 10032      ;  ; 
ids_synchro - ids_queries: (hash): ids / (array): 1 / (array): 1 / 10032      ;  ;  ; qry / (array): 1 / SELECT id,sifradob,match_code,naz,strings,jmj,idtarifa,nc,vpc,vpc2,plc,mpc,mpc2,mpc3,k1,k2,k7,k8,k9,n1,n2,tip,mink,opis,barkod,fisc_plu,zanivel,zaniv2,trosk1,trosk2,trosk3,trosk4,trosk5,idkonto FROM fmk.roba WHERE (id) IN ('10032     ') ;  ;