FiveTech Support Forums

Application
===========
   Path and name: C:\Des\fivewin\dbfquery\dbfquery.EXE (32 bits)
   Size: 5,147,648 bytes
   Compiler version: Harbour 3.2.0dev (r1406271520)
   FiveWin  Version: FWH 13.11
   Windows version: 6.1, Build 7601 Service Pack 1

   Time from start: 0 hours 0 mins 5 secs 
   Error occurred at: 25/07/2014, 08:12:52
   Error description: (DOS Error -2147352567) WINOLE/1007  A conversão de um tipo de dados varchar em um tipo de dados smalldatetime resultou em um valor fora do intervalo. (0x80040E07): Microsoft SQL Server Native Client 11.0
   Args:
     [   1] = C   INSERT INTO [CLIENTES] ( [NOMECLI],[FANTASI],[CODICLI],[ENDEREC],[ENDECOB],[BAIR_RO],[BAIRCOB],[ESTACOB],[CEPCOBR],[CIDA_DE],[ESTA_DO],[PRACAPG],[CONTATO],[INSCEST],[NUMECEP],[NUMEFAX],[TELE_FO],[NUMECGC],[OBSERVA],[TIPONUM],[ESTCIVI],[NASCIME],[NATURAL],[FILIACA],[TRABALH],[FATURAM],[CONJUGE],[DATACAD],[HISTO01],[HISTO02],[HISTO03],[HISTO04],[HISTO05],[HISTO06],[HISTO07],[HISTO08],[HISTO09],[HISTO10],[HISTO11],[HISTO12],[HISTO13],[HISTO14],[HISTO15],[CORREIO],[CODIREG],[CODIATI],[DATASPC],[ADMISSA],[CARGOEM],[PONTOR1],[PONTOR2],[PONTOR3],[NEGATIV],[MOTIVOS],[SITICMS],[ENDEOBR],[BAIROBR],[NCEPOBR],[CIDAOBR],[ESTAOBR],[NOMESO1],[ENDESO1],[BAIRSO1],[NCEPSO1],[CIDASO1],[ESTASO1],[TELESO1],[NUMECG1],[INSCES1],[NOMESO2],[ENDESO2],[BAIRSO2],[NCEPSO2],[CIDASO2],[ESTASO2],[TELESO2],[NUMECG2],[INSCES2],[NOMESO3],[ENDESO3],[BAIRSO3],[NCEPSO3],[CIDASO3],[ESTASO3],[TELESO3],[NUMECG3],[INSCES3],[NUMEROS],[PERIODO],[NUMECOB],[DESCCLI],[ALIQIFO],[CODIVEN],[CODIPLA],[CODIROT],[OLOODES],[OLOODCI],[OLOODEI],[OLOOEES],[OLOOECI],[OLOOEEI],[OPEODES],[OPEODCI],[OPEODEI],[OPEOEES],[OPEOECI],[OPEOEEI],[OADIC01],[OADIC02],[OADIC03],[PRODUTO],[PRODCOR],[DADOATA],[DADOAMD],[DADODNP],[DADZILO],[DADMETA],[DADFURO],[DADFRIS],[CODIVE2],[MARCECF],[MARCTEF],[MARCPED],[MARCCON],[MODEECF],[TELECEL],[PERCAUM],[DATAEXP],[CODICON],[DATAVAL],[INTERNE],[DIAVENC],[CODIBGE],[CODFEDE],[CODMUNI],[CODIBAN],[CODIAGE],[CODICCO],[DATABAN],[CPFCONJ],[EMAICOB],[TELECOB],[FAX_COB],[CELUCOB],[CONTCOB],[TELETRA],[CEPTRAB],[ENDETRA],[REF1NOM],[REF2NOM],[REF3NOM],[REF1FON],[REF2FON],[REF3FON],[REF1CON],[REF2CON],[REF3CON],[REF1DAT],[REF2DAT],[REF3DAT],[REF1COM],[REF2COM],[REF3COM],[REF1VAL],[REF2VAL],[REF3VAL],[REF1PES],[REF2PES],[REF1PFO],[REF2PFO],[REF1PAR],[REF2PAR],[VALRPED],[NUMEPED],[DATAPED],[ETIQCL3],[MARCNFE],[MARCCER],[MARCCVE],[MARCGIM],[MARCSPE],[PROTEST],[ALTERA1] ) VALUES ( 'CONSUMIDOR','CONSUMIDOR','000001','','','','','PB','58028840','JOAO PESSOA','PB','JOAO PESSOA','','000000000','58028840','','','00000000000000','','2','',NULL,'JOAO PESSOA','','CONSUMIDOR',0.01,'',NULL,'','PARA VENDAS AV/CH.','','','','','','','','','','','','','','','83','016',NULL,NULL,'','','','',NULL,'','NORMAL','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','0',0,'',0.00,0.00,'065','000','001','','','','','','','','','','','','','','','','','','','','','','','','','0001','','','',0.00,'','',0.00,NULL,'',NULL,'','','2507507','20516','9516','','','',NULL,'',<!-- e --><a href="mailto:'vendas@lduferro.com">'vendas@lduferro.com</a><!-- e -->','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'','','','','','',16.96,'665344','2014-06-30','','','',NULL,'','',0,'' ),( 'LOJAO DUFERRO LTDA','LDF CASA E CONSTRUCAO','000002','AV TANCREDO NEVES  N 203','AV TANCREDO NEVES  N 203','DOS IPES','DOS IPES','PB','58028840','JOAO PESSOA','PB','JOAO PESSOA','ROBERTO AMORIM','161168973','58028840','3244-6487','3244-6487','02019761000110','','1','','1997-08-01','JOAO PESSOA','','LOJAO DUFERRO LTDA',0.01,'','2000-04-24','191938','','','','','','','','','','','','','','',<!-- e --><a href="mailto:'vendaslduferro@gmail.com">'vendaslduferro@gmail.com</a><!-- e -->','83','016',NULL,NULL,'','','','',NULL,'CONSULTAR A GERENCIA','NORMAL','AV TANCREDO NEVES','IPES','58028840','JOAO PESSOA','PB','','','','','','','','','','','','','','','','','','','','','','','','','','','','203',0,'203',0.00,0.00,'001','000','001','','','','','','','','','','','','','','','','','','','','','','','','','0001','','','',0.00,'','',0.00,NULL,'',NULL,'','','2507507','20516','9516','','','',NULL,'',<!-- e --><a href="mailto:'vendaslduferro@gmail.com">'vendaslduferro@gmail.com</a><!-- e -->','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'','','','','','',131.56,'665190','2014-06-30','','','',NULL,'','',0,'' ),( 'CASA DO FERRO LTDA','CASA DO FERRO','000003','AV CRUZ DAS ARMAS N 1009','AV CRUZ DAS ARMAS N 1009','CRUZ DAS ARMAS','CRUZ DAS ARMAS','PB','58085000','JOAO PESSOA','PB','JOAO PESSOA','JONAS ARIMATEA','160279658','58085000','32426676','32426688','08842924000147','','1','','1984-09-14','JOAO PESSOA','','CASA DO FERRO LTDA',10000.00,'','2000-04-24','7777','','','','','','','','','','','','','','','','83','003',NULL,NULL,'','','','',NULL,'','NORMAL','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','1009',0,'1009',0.00,0.00,'009','000','001','','','','','','','','','','','','','','','','','','','','','','','','','0001','','','',0.00,'','',0.00,NULL,'',NULL,'','','2507507','','','','','',NULL,'','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'','','','','','',90.00,'637599','2014-02-22','','','',NULL,'','',0,'' ),( 'FORT FERRO COMERCIO DE FERRO LTDA','FORT FERRO','000004','AV FRANCISCO LONDRES N 108','AV FRANCISCO LONDRES N 108','VARADOURO','VARADOURO','PB','58010150','JOAO PESSOA','PB','JOAO PESSOA','FRANCISCO/CLEITON','160889022','58010150','32213401','32213496','35433226000160','TELEF 32213401','1','',NULL,'JOAO PESSOA','','FORT FERRO COMERCIO DE FERRO LTDA',50000.00,'','2000-04-24','14849','','','','','','','','','','','','','','',<!-- e --><a href="mailto:'fortferro@yahoo.com.br">'fortferro@yahoo.com.br</a><!-- e -->','83','003',NULL,NULL,'','','','',NULL,'','SIMPLES','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','108',0,'108',0.00,0.00,'002','000','001','','','','','','','','','','','','','','','','','','','','','','','','','0001','','','',0.00,'','',0.00,NULL,'',NULL,'','','2507507','20516','9516','','','',NULL,'',<!-- e --><a href="mailto:'fortferro@yahoo.com.br">'fortferro@yahoo.com.br</a><!-- e -->','(83)3221-3496','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'','','','','','',560.00,'492337','2012-04-25','','','',NULL,'','',0,'' ),( 'METALURGICA ESTRUTURAL LTDA','METALURGICA ESTRUTURAL','000005','R DA AREIA  N 249','R DA AREIA  N 249','CENTRO','CENTRO','PB','58010640','JOAO PESSOA','PB','JOAO PESSOA','','000000000','58010640','','3221-9508','03165658000141','','1','',NULL,'JOAO PESSOA','','METALURGICA ESTRUTURAL LTDA',1500.00,'','2000-04-24','384785','SERRALHARIA ALUMINIO','O MESMO','','','','','','','','','','','','','','83','001',NULL,NULL,'','','','',NULL,'','NORMAL','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','249',0,'249',0.00,0.00,'001','000','001','','','','','','','','','','','','','','','','','','','','','','','','','0001','','','',0.00,'','',0.00,NULL,'',NULL,'','','2507507','','','','','',NULL,'','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'','','','','','',0.00,'',NULL,'','','',NULL,'','',0,'' ),( 'BRASTEX SA  1','BRASTEX','000006','BR 230   KM 25 N 2550','BR 230   KM 25 N 2550','CRISTO REDENTOR','CRISTO REDENTOR','PB','58071680','JOAO PESSOA','PB','JOAO PESSOA','WALLACE 8605-8784','160564956','58071680','','2107-0538','09258807000101','ATUALIZADO EM 19.012.2013','1','','1973-07-17','JOAO PESSOA','','BRASTEX SA  1',1200.00,'','2000-04-24','406607','INDUSTRIA','O MESMO','','','','','','','','','','','','',<!-- e --><a href="mailto:'wallace@gso.com.br">'wallace@gso.com.br</a><!-- e -->','83','002',NULL,NULL,'','','','',NULL,'','NORMAL','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','2550',0,'2550',0.00,0.00,'087','000','001','','','','','','','','','','','','','','','','','','','','','','','','','0001','','','',0.00,'','(83)8605-8784',0.00,NULL,'',NULL,'','','2507507','20516','9516','','','',NULL,'',<!-- e --><a href="mailto:'wallace@gso.com.br">'wallace@gso.com.br</a><!-- e -->','(83)8605-8784','','','WALLACE','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'','','','','','',140.00,'653538','2014-05-07','','','',NULL,'','',0,'' ),( 'GRUPO 4 PLANEJAMENTO E OBRAS LTDA','GRUPO 4','000007','AVENIDA PIAUI SALA 104','R ALMEIDA BARRETO N 261 SL 201','BAIRRO DOS ESTADOS','CENTRO','PB','58013460','JOAO PESSOA','PB','JOAO PESSOA','ALEXANDRE','160328250','58030330','3244-2573','3222-4290','09601493000190','CLIENTE SEM LIMITE - AUT SR ROBERTO 24','1','',NULL,'JOAO PESSOA','','GRUPO 4 PLANEJAMENTO E OBRAS LTDA',30000.00,'','2000-04-24','ACERTO C/ ANDRE EM 10/00.','CONSTRUTORA','O MESMO','material retirado por junior dia 14/01/02','','','','','','','','','','','',<!-- e --><a href="mailto:'notafiscal@grupoquatro.eng.br">'notafiscal@grupoquatro.eng.br</a><!-- e -->','83','004',NULL,NULL,'','','','',NULL,'','NORMAL','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','311',0,'261',0.00,0.00,'003','000','001','','','','','','','','','','','','','','','','','','','','','','','','','0001','','','',0.00,'','(83)9961-7947',0.00,NULL,'',NULL,'','','2507507','20516','9516','','','',NULL,'',<!-- e --><a href="mailto:'notafiscal@grupoquatro.eng.br">'notafiscal@grupoquatro.eng.br</a><!-- e -->','(83)3244-2573','','','ALEXANDRE','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'','','','','','',75.43,'664761','2014-06-27','','','',NULL,'','',0,'' ),( 'INFORME PLACAS BOX E ESQUADRIAS LTDA','PLACAS  BOX E ESQUADRIAS','000008','R APOLONIO NOBREGA  N 177','R APOLONIO NOBREGA  N 177','CASTELO BRANCO','CASTELO BRANCO','PB','58050260','JOAO PESSOA','PB','JOAO PESSOA','','161185193','58050260','','32440605','02168230000190','','1','',NULL,'JOAO PESSOA','','INFORME PLACAS BOX E ESQUADRIAS LTDA',0.01,'','2000-04-24','262248','SERRALHARIA ALUMINIO','O MESMO','','','','','','','','','','','','','','83','001',NULL,NULL,'','','','','2010-01-21','CONFIRMAR INSCRICAO ANTES DE VENDER','NORMAL','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','177',0,'177',0.00,0.00,'021','000','001','','','','','','','','','','','','','','','','','','','','','','','','','0001','','','',0.00,'','',0.00,NULL,'',NULL,'','','2507507','','','','','',NULL,'','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'','','','','','',0.00,'',NULL,'','','',NULL,'','',0,'' ),( 'RIO SUL COMERCIO CONSTRUCOES E REPRESENTACOES LTDA','RIO SUL CONSTRUTORA','000009','AV MANOEL MESQUITA 63 SL 05 A','AV MAXIMIANO FIGUEIREDO  N 628','CENTRO','CENTRO','PB','58013470','BAYEUX','PB','JOAO PESSOA','MARCOS / RAMOS','000000000','58307040','3246-0792','3241-8292','01446724000126','93090238','1','',NULL,'BAYEUX','','RIO SUL COMERCIO CONSTRUCOES E REPRESENTACOES LTDA',5000.00,'','2000-04-24','408223','CONSTRUTORA','RUA: MARTIN LEITAO, 178 - CENTRO - 58011-070','','','','','','','','','','','','','','83','003',NULL,'2002-07-24','','','','','2002-08-26','DUPLIC  EM ATRASO','NORMAL','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','63',0,'628',0.00,0.00,'022','000','001','','','','','','','','','','','','','','','','','','','','','','','','','0001','','','',0.00,'','',0.00,NULL,'',NULL,'','','2501807','','','','','',NULL,'','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'','','','','','',0.00,'',NULL,'','','',NULL,'','',0,'' ),( 'COIMBRA CONSTRUTORA BRASILIA LTDA','COIMBRA CONSTRUTORA BRASILIA LTDA','000010','R MARIA ROSA JACINTO N 222','R MARIA ROSA JACINTO N 222','BESSA','BESSA','PB','58035280','JOAO PESSOA','PB','JOAO PESSOA','','161188907','58035280','','32452612','02066350000186','','1','','1997-08-28','JOAO PESSOA','','COIMBRA CONSTRUTORA BRASILIA LTDA',0.01,'','2000-04-24','259723','CONSTRUTORA','O MESMO','','','','','','','','','','','','','CLIENTE NAO POSSUI EMAIL','83','004',NULL,NULL,'','','','',NULL,'','NORMAL','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','222',0,'222',0.00,0.00,'021','000','001','','','','','','','','','','','','','','','','','','','','','','','','','0001','','','',0.00,'','',0.00,NULL,'',NULL,'','','2507507','20516','9516','','','',NULL,'','CLIENTE NAO POSSUI EMAIL','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'','','','','','',24.00,'530001','2012-11-06','','','',NULL,'','',0,'' ),( 'AILTON BENTO DA SILVA','AILTON BENTO','000011','R  SAO SEBASTIAO N 400','R  SAO SEBASTIAO N 400','CENTRO1','CENTRO','PB','58345000','MARI','PB','MARI','','160863465','58345000','','32781328','41198284000150','','1','','1993-04-01','MARI','','AILTON BENTO DA SILVA',1000.00,'','2000-04-24','364985','REVENDA','O MESMO','','','','','','','','','','','','','CLIENTE NAO POSSUI EMAIL','83','003',NULL,NULL,'','','','',NULL,'','SIMPLES','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','400',0,'400',0.00,0.00,'003','000','001','','','','','','','','','','','','','','','','','','','','','','','','','0001','','','',0.00,'','',0.00,NULL,'',NULL,'','','2509107','20834','11316','','','',NULL,'','CLIENTE NAO POSSUI EMAIL','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'','','','','','',52.00,'650304','2014-04-22','','','',NULL,'','',0,'' ),( 'COLUNAS CONSTRUCOES LTDA','COLUNAS CONSTRUCOES LTDA','000012','AV DOM PEDRO II N 2581 SL 3 4','AV DOM PEDRO II N 2581 SL 3 4','TORRE','TORRE','PB','58013240','JOAO PESSOA','PB','JOAO PESSOA','ALCIDES','000000000','58013240','','32447151','01595348000131','LIBERADO P ROBERTO EM 07 03 01  DUPLIC','1','','1996-12-18','JOAO PESSOA','','COLUNAS CONSTRUCOES LTDA',0.01,'','2000-04-24','169512','','','','','','','','','','','','','','','CLIENTE NAO POSSUI EMAIL','83','004',NULL,NULL,'','','','',NULL,'','NORMAL','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','2581',0,'2581',0.00,0.00,'003','000','001','','','','','','','','','','','','','','','','','','','','','','','','','0001','','','',0.00,'','',0.00,NULL,'',NULL,'','','2507507','20516','9516','','','',NULL,'','CLIENTE NAO POSSUI EMAIL','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'','','','','','',16.00,'594570','2013-09-04','','','',NULL,'','',0,'' ),( 'ALCIDES COSME DE BRITO','ALCIDES COSME','000013','R HEROINA MARIA CLEIDE        N 240','R HEROINA MARIA CLEIDE        N 240','CENTRO','CENTRO','PB','58360000','ITABAIANA','PB','ITABAIANA','','161149820','58360000','','32811178','01634827000110','BLOQUEADO POR JUNIOR 10 05 01','1','',NULL,'ITABAIANA','','ALCIDES COSME DE BRITO',1000.00,'','2000-04-24','143751','REVENDA','O MESMO','','','','','','','','','','','','','CLIENTE NAO POSSUI EMAIL','83','003',NULL,NULL,'','','','',NULL,'DUPLIC  EM ATRASO','NORMAL','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','00',0,'00',0.00,0.00,'033','000','001','','','','','','','','','','','','','','','','','','','','','','','','','0001','','','',0.00,'','',0.00,NULL,'',NULL,'','','2506905','20397','8916','','','',NULL,'','CLIENTE NAO POSSUI EMAIL','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'','','','','','',7.00,'655937','2014-05-17','','','',NULL,'','',0,'' ),( 'COMPAC ENGENHARIA LTDA','COMPAC','000014','AV CAMPINA GRANDE','R HILDA COUTINHO LUCENA','MUNICIPIOS','MARAMAR','PB','58043110','SANTA RITA','PB','JOAO PESSOA','SIMONE  OU LUCIANO','161195997','58302195','32475707','32475707','02468543000163','','1','',NULL,'SANTA RITA','','COMPAC ENGENHARIA LTDA',50000.00,'','2000-04-24','307607','','','','','','','','','','','','','','',<!-- e --><a href="mailto:'compac.engenharia@gmail.com">'compac.engenharia@gmail.com</a><!-- e -->','83','004',NULL,NULL,'LUIZ FINANCEIRO','','','',NULL,'LIMITE DE CREDITO','NORMAL','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','51',0,'102',0.00,0.00,'114','000','001','','','','','','','','','','','','','','','','','','','','','','','','','0001','','','',0.00,'','',0.00,NULL,'',NULL,'','','2513703','21750','17116','','','',NULL,'',<!-- e --><a href="mailto:'compac.engenharia@gmail.com">'compac.engenharia@gmail.com</a><!-- e -->','(83)3247-5707','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'','','','','','',197.31,'665343','2014-06-30','','','',NULL,'','',0,'' ),( 'CONDOMINIO RESIDENCIAL PARAISO TROPICAL','CONDOMINIO RESIDENCIAL PARAISO TROPICAL','000015','AV CABO BRANCO SN','AV DOM PEDRO I   N 719','CABO BRANCO','CEMTRO  ED DINAMIC CENTER','PB','58013000','JOAO PESSOA','PB','JOAO PESSOA','','000000000','58045010','','32226776','03304842000125','BLOQUEADO POR JUNIOR','1','','1999-07-08','JOAO PESSOA','','CONDOMINIO RESIDENCIAL PARAISO TROPICAL',1000.00,'','2000-04-24','399333','','','','','','','','','','','','','','','','83','014',NULL,NULL,'','','','',NULL,'DUPLIC EM ATTASO','NORMAL','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','719',0,'719',0.00,0.00,'003','000','001','','','','','','','','','','','','','','','','','','','','','','','','','0001','','','',0.00,'','',0.00,NULL,'',NULL,'','','2507507','20516','9516','','','',NULL,'','.','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'','','','','','',0.00,'',NULL,'','','',NULL,'','',0,'' ),( 'ALCONIL ALMEIDA CONSTRUCAO E INCORPORACAO','ALCONIL ALMEIDA CONSTRUCAO E INCORPORACAO','000016','AV JOAO MAURICIO   SL 403','AV JOAO MAURICIO   SL 403','MANAIRA','MANAIRA','PB','58038000','JOAO PESSOA','PB','JOAO PESSOA','ANTONIO ALMEDA','161220282','58038000','','9982-6950','08342602000139','','1','',NULL,'JOAO PESSOA','','ALCONIL ALMEIDA CONSTRUCAO E INCORPORACAO',2000.00,'','2000-04-24','213960','CONSTRUTORA','O MESMO','','','','','','','','','','','','','.','83','016',NULL,NULL,'','','','',NULL,'','NORMAL','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','1675',0,'1675',0.00,0.00,'002','000','001','','','','','','','','','','','','','','','','','','','','','','','','','0001','','','',0.00,'','(  )    -',0.00,NULL,'',NULL,'','','2507507','20516','9516','','','',NULL,'',',','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'','','','','','',161.20,'665191','2014-06-30','','','',NULL,'','',0,'' ),( 'CONDOMINIO RESIDENCIAL VILLAGE MONTALLO','CONDOMINIO RESIDENCIAL VILLAGE MONTALLO','000017','R EUTEQUIANO BARRETO LT 01 QD 25','R EUTEQUIANO BARRETO LT 01 QD 25','MANAIRA','MANAIRA','PB','58038310','JOAO PESSOA','PB','JOAO PESSOA','ROBERTO DOURADO','000000000','58038310','','32270510','01430993000102','','1','',NULL,'JOAO PESSOA','','CONDOMINIO RESIDENCIAL VILLAGE MONTALLO',1500.00,'','2000-04-24','177592','','','','','','','','','','','','','','','.','83','014',NULL,NULL,'','','','',NULL,'','NORMAL','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','00',0,'00',0.00,0.00,'003','000','001','','','','','','','','','','','','','','','','','','','','','','','','','0001','','','',0.00,'','',0.00,NULL,'',NULL,'','','2507507','20516','9516','','','',NULL,'','.','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'','','','','','',0.00,'',NULL,'','','',NULL,'','',0,'' ),( 'ALMONTE ESTRUTURAS ESPACIAS LTDA','ALMONTE LTDA','000018','AV CAXANGA N 833','AV CAXANGA N 833','ZUMBI','ZUMBI','PE','50800210','RECIFE','PE','RECIFE','','000000000','50800210','','34452755','08663221000151','','1','','1995-02-13','RECIFE','','ALMONTE ESTRUTURAS ESPACIAS LTDA',500.00,'','2000-04-24','378220','CONSTRUTORA','O MESMO','','','','','','','','','','','','','','81','003',NULL,NULL,'','','','','2009-08-22','CADASTRO NAO COINCIDE COM CARTAO CNPJ','NORMAL','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','833',0,'833',0.00,0.00,'021','000','001','','','','','','','','','','','','','','','','','','','','','','','','','0001','','','',0.00,'','',0.00,NULL,'',NULL,'','','2611606','','','','','',NULL,'','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'','','','','','',0.00,'',NULL,'','','',NULL,'','',0,'' ),( 'CONDOMINIO RESIDENCIAL COLUMBIA','CONDOMINIO RESIDENCIAL COLUMBIA','000019','AV MAR DE BERING N 193','AV MAR DE BERING N 193','INTERMARES','INTERMARES','PB','58310000','CABEDELO','PB','CABEDELO','32484398 ELIOMAR','000000000','58310000','','32452007','41214990000148','','1','','1995-02-01','CABEDELO','','CONDOMINIO RESIDENCIAL COLUMBIA',0.00,'','2000-04-24','83341','','','','','','','','','','','','','','','.','83','014',NULL,NULL,'','','','',NULL,'','NORMAL','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','193',0,'193',0.00,0.00,'003','000','001','','','','','','','','','','','','','','','','','','','','','','','','','0001','','','',0.00,'','',0.00,NULL,'',NULL,'','','2503209','19658','4016','','','',NULL,'','.','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'','','','','','',77.00,'660997','2014-06-07','','','',NULL,'','',0,'' ),( 'ALUMINIUS INDUSTRIA COMERCIO DE ESQUADRIAS LTDA','ALUMINIUS','000020','R PROJETADA 02  QD B  LT 11 N§ 137','R PROJETADA 02  QD B  LT 11    SN','LOT JOAO PAULO II','LOT JOAO PAULO II','PB','58310000','CABEDELO','PB','CABEDELO','MARCELO','161130445','58310000','99961041','32463194','01324669000100','','1','','1996-07-23','CABEDELO','','ALUMINIUS INDUSTRIA COMERCIO DE ESQUADRIAS LTDA',20000.00,'','2000-04-24','203050','SERRALHARIA ALUMINIO','O MESMO','','','','','','','','','','','','',<!-- e --><a href="mailto:'financeiro@aluminiusesquadrias.com.br">'financeiro@aluminiusesquadrias.com.br</a><!-- e -->','83','003',NULL,NULL,'','POR TRAS DA PROJECTA','','',NULL,'','SIMPLES','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','137',0,'',0.00,0.00,'137','000','001','','','','','','','','','','','','','','','','','','','','','','','','','0001','','','',0.00,'','',0.00,NULL,'',NULL,'','','2503209','19658','4016','','','',NULL,'',<!-- e --><a href="mailto:'financeiro@aluminiusesquadrias.com.br">'financeiro@aluminiusesquadrias.com.br</a><!-- e -->','(83)3246-3194','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'','','','','','',36.00,'601219','2013-09-30','','','',NULL,'','',0,'' ),( 'CONDOMINIO REINO DE ESPANHA','CONDOMINIO REINO DE ESPANHA','000021','AV PRES EPITACIO PESSOA SN','AV PRES EPITACIO PESSOA SN','MIRAMAR','MIRAMAR','PB','58030000','JOAO PESSOA','PB','JOAO PESSOA','','000000000','58030000','','32217587','00962330000168','','1','','1995-12-13','JOAO PESSOA','','CONDOMINIO REINO DE ESPANHA',1500.00,'','2000-04-24','ACERTO C/ JORGE EM 10/00.','','','','','','','','','','','','','','','CLIENTE NAO POSSUI EMAIL','83','014',NULL,NULL,'','','','',NULL,'DUPLIC EM ATRASO','NORMAL','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','00',0,'00',0.00,0.00,'030','000','001','','','','','','','','','','','','','','','','','','','','','','','','','0001','','','',0.00,'','',0.00,NULL,'',NULL,'','','2507507','20516','9516','','','',NULL,'','CLIENTE NAO POSSUI EMAIL','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'','','','','','',0.00,'606368','2013-10-19','','','',NULL,'','',0,'' )



 ADOCONNECT oCn TO MSSQL SERVER 'MATHEUS\SQLEXPRESS' USER 'SA' PASSWORD 'matrix' DATABASE 'novo'
   USE CLIENTES SHARED
    cSql := FW_AdoCreateTableSQL( "CLIENTES", CLIENTES->(DBSTRUCT()), oCn )
    MemoWrit(cSql)
   FW_AdoImportFromDBF( oCn, DIRAPP+"\clientes.dbf", "CLIENTES" )

    oCn:Execute('SET DATEFORMAT YMD') // MUDA DATA PARA O FORMATO USADO PELO SQL