DBF to SQL script tool

Re: DBF to SQL script tool

Postby dutch » Sat Jun 28, 2014 2:32 am

Dear Rao,

I can convert as your suggestion but it got an error as below;
Code: Select all  Expand view  RUN

Application
===========
   Path and name: E:\EASYFO\FO\V5\MBL\testimp.exe (32 bits)
   Size: 2,738,176 bytes
   Compiler version: xHarbour 1.2.3 Intl. (SimpLex) (Build 20130903)
   FiveWin  Version: FWHX 13.11
   Windows version: 6.1, Build 7601 Service Pack 1

   Time from start: 0 hours 0 mins 30 secs
   Error occurred at: 06/28/14, 09:07:47
   Error description: Error ADODB.Connection/0  S_OK: EXECUTE
   Args:
     [   1] = C   INSERT INTO `CCRMAIL` ( `ML_SENDER`,`ML_RECEIVR`,`ML_SUBJECT`,`ML_DATE`,`ML_TIME`,`ML_RSTATUS`,`ML_OPEN`,`ML_SSTATUS`,`ML_TEXT` ) VALUES ( 'NANTANEE','NATSUCHA',.....
Stack Calls
===========
   Called from:  => TOLEAUTO:EXECUTE( 0 )
   Called from: .\source\function\ADOFUNCS.PRG => FW_ADOIMPORTFROMDBF( 1006 )
Regards,
Dutch

FWH 19.01 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio
FWPPC 10.02 / Harbour for PPC (FTDN)
ADS V.9 / MySql / MariaDB
R&R 12 Infinity / Crystal Report XI R2
(Thailand)
User avatar
dutch
 
Posts: 1542
Joined: Fri Oct 07, 2005 5:56 pm
Location: Thailand

Re: DBF to SQL script tool

Postby nageswaragunupudi » Sat Jun 28, 2014 4:09 am

Mr Dutch

I sent you a personal email. I hope your email is still the same.
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10646
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: DBF to SQL script tool

Postby cdmmaui » Thu Jul 03, 2014 6:57 pm

Thank you for your help. That was the problem and we go the tables to create in MS SQL. We are on to importing the data.
*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
User avatar
cdmmaui
 
Posts: 689
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong

Re: DBF to SQL script tool

Postby cdmmaui » Thu Jul 03, 2014 9:50 pm

Dear Mr. Rao,

Sorry to bother you. I am getting the following error when trying to import data to MS SQL 2012. Function did import 105 records (rows) before error was received.

Here is my connection string:
cSqlCon = 'PROVIDER=SQLNCLI11;Server='+xSOURCE+';Database='+xDATABASE+';Trusted_Connection=yes;'


How do I resolve this?

Application
===========
Path and name: C:\cdm\winsql\cdmsql.exe (32 bits)
Size: 2,547,712 bytes
Compiler version: xHarbour 1.2.3 Intl. (SimpLex) (Build 20130422)
FiveWin Version: FWHX 14.06
Windows version: 6.2, Build 9200

Time from start: 0 hours 0 mins 23 secs
Error occurred at: 07/03/2014, 17:40:55
Error description: Error ADODB.Connection/0 S_OK: EXECUTE
Args:
[ 1] = C INSERT INTO [air] ( [COMPANY],[QUOTENO],[STATION],[DSTSTAT],[HSE],[HOUSE],[FILE],[SERIAL],[BOOKNO],[MODE],[TRANS],[MOVE],[DATE],[STATUS],[SHIPID],[SHIPNAME],[SHIPADD1],[SHIPADD2],[SHIPADD3],[SHIPCITY],[SHIPST],[SHIPSTE],[SHIPZIP],[SHIPISO],[SHIPISOP],[REFERENCE],[SHIPCONT],[SHIPCONTP],[SHIPPH],[SHIPPHP],[SHIPFAX],[SHIPFAXP],[SHIPREP],[CONSID],[CONSNAME],[CONSADD1],[CONSADD2],[CONSADD3],[CONSCITY],[CONSST],[CONSSTE],[CONSZIP],[CONSREF],[CONSISO],[CONSISOP],[CONSCONT],[CONSCONTP],[CONSPH],[CONSPHP],[CONSFAX],[CONSFAXP],[CONSREP],[NOTIID],[NOTINAME],[NOTIADD1],[NOTIADD2],[NOTIADD3],[NOTICITY],[NOTIST],[NOTISTE],[NOTIZIP],[NOTIISO],[NOTIISOP],[NOTICONT],[NOTICONTP],[NOTIPH],[NOTIPHP],[NOTIFAX],[NOTIFAXP],[PICKID],[PICKNAME],[PICKADD1],[PICKADD2],[PICKADD3],[PICKCITY],[PICKST],[PICKZIP],[PICKCONT],[PICKPH],[PICKFAX],[DESTID],[DESTNAME],[DESTADD1],[DESTADD2],[DESTADD3],[DESTCITY],[DESTST],[DESTZIP],[DESTCONT],[DESTPH],[DESTFAX],[ACCTID],[ACCT01],[ACCT02],[ACCT03],[ACCT04],[ACCT05],[ACCT06],[ACCT07],[ACCT08],[EXREF01],[EXREF02],[EXREF03],[CARRIER],[CARRIER2],[CARRIER3],[CARRIER4],[MANIFEST],[SUBMAN],[PFX],[PFX02],[PFX03],[PFX04],[MBILL],[MBILL2],[MBILL3],[MBILL4],[HBILL],[BOOKING],[TO01],[TO02],[BY02],[TO03],[BY03],[TO04],[BY04],[CURRENCY],[WTVAL],[OTHER],[CARVAL],[CUSVAL],[INSVAL],[AIRMIN],[PICKDATE],[PICKTIME],[DELVDATE],[DELVTIME],[FLT01],[DTE01],[TME01],[FLT02],[DTE02],[TME02],[FLT03],[DTE03],[TME03],[FLT04],[DTE04],[TME04],[PRECARRID],[PRECARR],[PRCODE],[PLACEREC],[ORCODE],[ORIGIN],[CONSOL],[POL],[POL02],[POL03],[POL04],[PORTLOAD],[POUL],[POUL02],[POUL03],[POUL04],[PORTDISC],[PDCODE],[PLACEDEL],[ULCODE],[ULTIMATE],[SERVICE],[PRIORITY],[DEPART],[ETA],[ETATIME],[ETA02],[ETATIME2],[ETA03],[ETATIME3],[ETA04],[ETATIME4],[HSECAR],[HANDLE01],[HANDLE02],[HANDLE03],[DELV01],[DELV02],[DELV03],[RATEID],[WTPPD],[WTCOL],[VCPPD],[VCCOL],[TXPPD],[TXCOL],[DAPPD],[DACOL],[DCPPD],[DCCOL],[TOTPPD],[TOTCOL],[WBLINE01],[WBLINE02],[WBLINE03],[WBLINE04],[ISSDATE],[ISSPLACE],[WTCODE],[OFFICIAL],[INVCNT],[INCH],[DIMFACT],[DIMWT],[ZONEF],[ZONET],[ZF01],[ZF02],[ZF03],[ZF04],[ZT01],[ZT02],[ZT03],[ZT04],[AIRCOMM],[AIRPERCENT],[BILLABLE],[READY],[CLOSE],[TRANSMIT],[AWBM],[ADDBY],[ADDDATE],[LASTUSER],[LASTDATE],[LASTTIME],[SITA],[SITAFLAG],[SITADATE],[SITATIME],[SITACODE],[SITALDATE],[SITALTIME],[CLOSED],[CLOSEDATE],[CLOSETIME],[CLOSEUSER],[CUSTID],[CUSTNAME],[CUSTREP],[COONAME],[COOCOUNTRY],[COOBODY],[DOCKBODY],[REP],[ACTUAL],[INVOICED],[INVOICE],[INVDATE],[INVUSER],[TRADELANE],[CUSTOM01],[CUSTOM02],[CUSTOM03],[CUSTOM04],[CUSTOM05],[BLDIVER],[FWBDATE],[FWBTIME],[FWBUSER],[FWBNO],[FHLDATE],[FHLTIME],[FHLUSER],[FHLNO],[ESTREVENUE],[UNKNOWN],[ITEM1],[ITEM2],[ITEM3] ) VALUES ( ... truncated due to limitation with FTS web forum ... )

Stack Calls
===========
Called from: => TOLEAUTO:EXECUTE( 0 )
Called from: .\source\function\ADOFUNCS.PRG => FW_ADOIMPORTFROMDBF( 1082 )
Called from: cdmsql.prg => _SQLIMPORT( 193 )
Called from: cdmsql.prg => (b)MAIN( 67 )
Called from: .\source\classes\MENU.PRG => TMENU:COMMAND( 463 )
Called from: .\source\classes\WINDOW.PRG => TWINDOW:COMMAND( 1050 )
Called from: => TWINDOW:HANDLEEVENT( 0 )
Called from: .\source\classes\WINDOW.PRG => _FWH( 3279 )
Called from: => WINRUN( 0 )
Called from: .\source\classes\WINDOW.PRG => TWINDOW:ACTIVATE( 1003 )
Called from: cdmsql.prg => MAIN( 83 )

System
======
CPU type: Intel(R) Xeon(R) CPU E5-2407 0 @ 2.20GHz 2200 Mhz
Hardware memory: 12243 megs

Free System resources: 90 %
GDI resources: 90 %
User resources: 90 %

Windows total applications running: 2
1 ,
2 Task Switching, C:\cdm\winsql\cdmsql.exe

Variables in use
================
Procedure Type Value
==========================
TOLEAUTO:EXECUTE
Param 1: C "INSERT INTO [air] .. MA','K','',0,'I',166,0,1,1,'','','','','','','','',0,5.00,0,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' )"
Local 1: U
Local 2: C "ADODB.Connection"
FW_ADOIMPORTFROMDBF
Param 1: O Class: TOLEAUTO
Param 2: C "AIR.dbf"
Param 3: C "air"
Local 1: U
Local 2: N 20
Local 3: U
Local 4: C "SRC"
Local 5: A Len: 280
Local 6: C "INSERT INTO [air] ( [COMPANY],[QUOTENO],[STATION],[DSTSTAT],[HSE],[HOUSE],[FILE],[SERIAL],[BOOKNO],[MODE],[TRANS],[MOVE],[DATE],[STATUS],[SHIPID],[SHIPNAME],[SHIPADD1],[SHIPADD2],[SHIPADD3],[SHIPCITY],[SHIPST],[SHIPSTE],[SHIPZIP],[SHIPISO],[SHIPISOP],[REFERENCE],[SHIPCONT],[SHIPCONTP],[SHIPPH],[SHIPPHP],[SHIPFAX],[SHIPFAXP],[SHIPREP],[CONSID],[CONSNAME],[CONSADD1],[CONSADD2],[CONSADD3],[CONSCITY],[CONSST],[CONSSTE],[CONSZIP],[CONSREF],[CONSISO],[CONSISOP],[CONSCONT],[CONSCONTP],[CONSPH],[CONSPHP],[CONSFAX],[CONSFAXP],[CONSREP],[NOTIID],[NOTINAME],[NOTIADD1],[NOTIADD2],[NOTIADD3],[NOTICITY],[NOTIST],[NOTISTE],[NOTIZIP],[NOTIISO],[NOTIISOP],[NOTICONT],[NOTICONTP],[NOTIPH],[NOTIPHP],[NOTIFAX],[NOTIFAXP],[PICKID],[PICKNAME],[PICKADD1],[PICKADD2],[PICKADD3],[PICKCITY],[PICKST],[PICKZIP],[PICKCONT],[PICKPH],[PICKFAX],[DESTID],[DESTNAME],[DESTADD1],[DESTADD2],[DESTADD3],[DESTCITY],[DESTST],[DESTZIP],[DESTCONT],[DESTPH],[DESTFAX],[ACCTID],[ACCT01],[ACCT02],[ACCT03],[ACCT04],[ACCT05],[ACCT06],[ACCT07],[ACCT08],[EXREF01],[EXREF02],[EXREF03],[CARRIER],[CARRIER2],[CARRIER3],[CARRIER4],[MANIFEST],[SUBMAN],[PFX],[PFX02],[PFX03],[PFX04],[MBILL],[MBILL2],[MBILL3],[MBILL4],[HBILL],[BOOKING],[TO01],[TO02],[BY02],[TO03],[BY03],[TO04],[BY04],[CURRENCY],[WTVAL],[OTHER],[CARVAL],[CUSVAL],[INSVAL],[AIRMIN],[PICKDATE],[PICKTIME],[DELVDATE],[DELVTIME],[FLT01],[DTE01],[TME01],[FLT02],[DTE02],[TME02],[FLT03],[DTE03],[TME03],[FLT04],[DTE04],[TME04],[PRECARRID],[PRECARR],[PRCODE],[PLACEREC],[ORCODE],[ORIGIN],[CONSOL],[POL],[POL02],[POL03],[POL04],[PORTLOAD],[POUL],[POUL02],[POUL03],[POUL04],[PORTDISC],[PDCODE],[PLACEDEL],[ULCODE],[ULTIMATE],[SERVICE],[PRIORITY],[DEPART],[ETA],[ETATIME],[ETA02],[ETATIME2],[ETA03],[ETATIME3],[ETA04],[ETATIME4],[HSECAR],[HANDLE01],[HANDLE02],[HANDLE03],[DELV01],[DELV02],[DELV03],[RATEID],[WTPPD],[WTCOL],[VCPPD],[VCCOL],[TXPPD],[TXCOL],[DAPPD],[DACOL],[DCPPD],[DCCOL],[TOTPPD],[TOTCOL],[WBLINE01],[WBLINE02],[WBLINE03],[WBLINE04],[ISSDATE],[ISSPLACE],[WTCODE],[OFFICIAL],[INVCNT],[INCH],[DIMFACT],[DIMWT],[ZONEF],[ZONET],[ZF01],[ZF02],[ZF03],[ZF04],[ZT01],[ZT02],[ZT03],[ZT04],[AIRCOMM],[AIRPERCENT],[BILLABLE],[READY],[CLOSE],[TRANSMIT],[AWBM],[ADDBY],[ADDDATE],[LASTUSER],[LASTDATE],[LASTTIME],[SITA],[SITAFLAG],[SITADATE],[SITATIME],[SITACODE],[SITALDATE],[SITALTIME],[CLOSED],[CLOSEDATE],[CLOSETIME],[CLOSEUSER],[CUSTID],[CUSTNAME],[CUSTREP],[COONAME],[COOCOUNTRY],[COOBODY],[DOCKBODY],[REP],[ACTUAL],[INVOICED],[INVOICE],[INVDATE],[INVUSER],[TRADELANE],[CUSTOM01],[CUSTOM02],[CUSTOM03],[CUSTOM04],[CUSTOM05],[BLDIVER],[FWBDATE],[FWBTIME],[FWBUSER],[FWBNO],[FHLDATE],[FHLTIME],[FHLUSER],[FHLNO],[ESTREVENUE],[UNKNOWN],[ITEM1],[ITEM2],[ITEM3] ) VALUES "
Local 7: C "INSERT INTO [air] ( [COMPANY],[QUOTENO],[STATION],[DSTSTAT],[HSE],[HOUSE],[FILE],[SERIAL],[BOOKNO],[MODE],[TRANS],[MOVE],[DATE],[STATUS],[SHIPID],[SHIPNAME],[SHIPADD1],[SHIPADD2],[SHIPADD3],[SHIPCITY],[SHIPST],[SHIPSTE],[SHIPZIP],[SHIPISO],[SHIPISOP],[REFERENCE],[SHIPCONT],[SHIPCONTP],[SHIPPH],[SHIPPHP],[SHIPFAX],[SHIPFAXP],[SHIPREP],[CONSID],[CONSNAME],[CONSADD1],[CONSADD2],[CONSADD3],[CONSCITY],[CONSST],[CONSSTE],[CONSZIP],[CONSREF],[CONSISO],[CONSISOP],[CONSCONT],[CONSCONTP],[CONSPH],[CONSPHP],[CONSFAX],[CONSFAXP],[CONSREP],[NOTIID],[NOTINAME],[NOTIADD1],[NOTIADD2],[NOTIADD3],[NOTICITY],[NOTIST],[NOTISTE],[NOTIZIP],[NOTIISO],[NOTIISOP],[NOTICONT],[NOTICONTP],[NOTIPH],[NOTIPHP],[NOTIFAX],[NOTIFAXP],[PICKID],[PICKNAME],[PICKADD1],[PICKADD2],[PICKADD3],[PICKCITY],[PICKST],[PICKZIP],[PICKCONT],[PICKPH],[PICKFAX],[DESTID],[DESTNAME],[DESTADD1],[DESTADD2],[DESTADD3],[DESTCITY],[DESTST],[DESTZIP],[DESTCONT],[DESTPH],[DESTFAX],[ACCTID],[ACCT01],[ACCT02],[ACCT03],[ACCT04],[ACCT05],[ACCT06],[ACCT07],[ACCT08],[EXREF01],[EXREF02],[EXREF03],[CARRIER],[CARRIER2],[CARRIER3],[CARRIER4],[MANIFEST],[SUBMAN],[PFX],[PFX02],[PFX03],[PFX04],[MBILL],[MBILL2],[MBILL3],[MBILL4],[HBILL],[BOOKING],[TO01],[TO02],[BY02],[TO03],[BY03],[TO04],[BY04],[CURRENCY],[WTVAL],[OTHER],[CARVAL],[CUSVAL],[INSVAL],[AIRMIN],[PICKDATE],[PICKTIME],[DELVDATE],[DELVTIME],[FLT01],[DTE01],[TME01],[FLT02],[DTE02],[TME02],[FLT03],[DTE03],[TME03],[FLT04],[DTE04],[TME04],[PRECARRID],[PRECARR],[PRCODE],[PLACEREC],[ORCODE],[ORIGIN],[CONSOL],[POL],[POL02],[POL03],[POL04],[PORTLOAD],[POUL],[POUL02],[POUL03],[POUL04],[PORTDISC],[PDCODE],[PLACEDEL],[ULCODE],[ULTIMATE],[SERVICE],[PRIORITY],[DEPART],[ETA],[ETATIME],[ETA02],[ETATIME2],[ETA03],[ETATIME3],[ETA04],[ETATIME4],[HSECAR],[HANDLE01],[HANDLE02],[HANDLE03],[DELV01],[DELV02],[DELV03],[RATEID],[WTPPD],[WTCOL],[VCPPD],[VCCOL],[TXPPD],[TXCOL],[DAPPD],[DACOL],[DCPPD],[DCCOL],[TOTPPD],[TOTCOL],[WBLINE01],[WBLINE02],[WBLINE03],[WBLINE04],[ISSDATE],[ISSPLACE],[WTCODE],[OFFICIAL],[INVCNT],[INCH],[DIMFACT],[DIMWT],[ZONEF],[ZONET],[ZF01],[ZF02],[ZF03],[ZF04],[ZT01],[ZT02],[ZT03],[ZT04],[AIRCOMM],[AIRPERCENT],[BILLABLE],[READY],[CLOSE],[TRANSMIT],[AWBM],[ADDBY],[ADDDATE],[LASTUSER],[LASTDATE],[LASTTIME],[SITA],[SITAFLAG],[SITADATE],[SITATIME],[SITACODE],[SITALDATE],[SITALTIME],[CLOSED],[CLOSEDATE],[CLOSETIME],[CLOSEUSER],[CUSTID],[CUSTNAME],[CUSTREP],[COONAME],[COOCOUNTRY],[COOBODY],[DOCKBODY],[REP],[ACTUAL],[INVOICED],[INVOICE],[INVDATE],[INVUSER],[TRADELANE],[CUSTOM01],[CUSTOM02],[CUSTOM03],[CUSTOM04],[CUSTOM05],[BLDIVER],[FWBDATE],[FWBTIME],[FWBUSER],[FWBNO],[FHLDATE],[FHLTIME],[FHLUSER],[FHLNO],[ESTREVENUE],[UNKNOWN],[ITEM1],[ITEM2],[ITEM3] ) VALUES ( '001','','','','H',1,'HFA-2228','001 260','','A','E','I','2000-10-17','',' RNI001','HEIDELBERG WEB PRESS','121 BROADWAY','DOVER','NH','','',0,'','',0,'','',0,'',0,'',0,'','BECHTRANS','WILLIAM BROOKS COMPANY','41 ROBERTS ROAD','CHULLERA','NSW, AUSTRALIA','','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',' #:HFA-2228','QF','','','','HFA-2228','','081','','','','90150281','','','','HFA-2228','','SYD','','','','','','','USD','P','P','NCV','13521.','NIL','','2000-07-07','','2000-07-07','','108','2000-10-19','','',NULL,'','',NULL,'','',NULL,'','','','','N.H.','','N.H.','SYD','BOS','','','','BOSTON, MA','SYD','','','','SYDNEY, AUSTRALIA','','AUSTRALIA','','AUSTRALIA','','',NULL,'2000-10-20','',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL.','TEL: 61293169500 FAX:61293166585','','','','','',505.30,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,505.30,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','MICHELLE O''BRIEN','AS AGENTS','2000-10-17','BILLERICA, MA','K','',0,'I',166,0,1,1,'','','','','','','','',0,5.00,0,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' ),( '001','','','','H',1,'HFA-2235','001 263','','A','E','I','2000-10-18','','','ANTAYA TECHNOLOGIES','72 FENNER STREET','CRANSTON','RHODE ISLAND','','MA',0,'02910','',0,'','',0,'',0,'',0,'','','VIDRIO SEKURI T ST GOBAIN','AV NICOLAS BRAVO SIN','PARQUE INDUSTRIAL CUATLA','C.P. 62741 MPIO DE AYALA','MEXICO','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',' #:HFA-2235','AF','','','','','','057','','','','16448062','','','','HFA-2235','','CDG','MEX','','','','','','USD','P','P','NCV','150.','NIL','','2000-10-18','','2000-10-18','','6434','2000-10-19','','',NULL,'','',NULL,'','',NULL,'','','','','','','','MEX','BOS','','','','BOSTON, MA','MEX','','','','MEXICO CITY','','','','MEXICO CITY','','',NULL,NULL,'',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL.','','','','','','',148.80,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,148.80,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','AS AGENT','MICHELLE O''BRIEN','2000-10-18','BILLERICA, MA','K','',0,'1',366,0,1,1,'','','','','','','','',0,5.00,1,'','',0,'','',NULL,'WELLMAN','2008-03-13','15:33:20',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' ),( '001','','','','M',0,'HFA-2235M','001 264','','A','E','I','2000-10-18','','','ANTAYA TECHNOLOGY','72 FENNER STREET','CRANSTON','RHODE ISLAND 02910','','',0,'','',0,'','',0,'',0,'',0,'','','ADUANAL ALVARO PADILLA','MUNDICARGA Y SERVICIOS','SINALOA 72 COL, PENON DE LOS BANOS','C.P. 15520','MEXICO D.F.','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',' #:HFA-2235M','AF','','','','HFA-2235M','','057','','','','16448062','','','','','','CDG','MEX','','','','','','USD','P','P','NCV','150.','NIL','','2000-10-18','','2000-10-18','','6434','2000-10-19','','',NULL,'','',NULL,'','',NULL,'','','','','','','','MEX','BOS','','','','BOSTON, MA','MEX','','','','MEXICO CITY','','','','MEXICO CITY','','',NULL,NULL,'',NULL,'',NULL,'',NULL,'','','**DANGEROUS GOODS AS PER ATTACHED SHIPPERS DECLARATION**CAO','','','','','','',148.80,0.00,0.00,0.00,0.00,0.00,4.80,0.00,80.00,0.00,233.60,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','AS AGENT','MICHELLE O''BRIEN','2000-10-18','BILLERICA, MA','K','',0,'I',366,0,1,1,'','','','','','','','',0,5.00,1,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' ),( '001','','','','H',1,'HFA-2236','001 266','','A','E','I','2000-10-19','','0020217','AMERICAN SCIENCE AND ENGINERRING','829 MIDDLESEX TURNPIKE','','','BILLERICA','MA',0,'01821','',0,'','',0,'',0,'',0,'','','AS & E GLOBAL INC.','(AKA AS&E , UK BRANCH)','18A SHAW LANE, INDUSTRIAL ESTATE','DONCASTER DN2 4SQ, UNITED KINGDOM','ATTN: GRAHAM HOLT','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',' #:HFA-2236','US','','','','','','037','','','','13360196','','','','HFA-2236','','PHL','LON','','','','','','USD','P','P','NCV','199,124.94','NIL','','2000-10-19','','2000-10-19','','98','2000-10-21','','',NULL,'','',NULL,'','',NULL,'','','LIGHTNING EXPRESS','','BOSTON','','BILLERICA, MA','LON','BOS','','','','BOSTON, MA','LON','','','','LONDON, ENGLAND','','','','UNITED KINGDOM','','',NULL,'2000-10-22','',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL.','ATTN: GRAHAM HOLT TEL: 44-1302327645','','','','','',1590.75,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1590.75,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','AS AGENT','MICHELLE O''BRIEN','2000-10-19','BILLERICA, MA','K','',0,'I',366,0,1,1,'','','','','','','','',0,5.00,1,'','',0,'','MICHELLE O''BRIEN','2007-06-12','',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' ),( '001','','','','M',0,'HFA-2236M','001 267','','A','E','I','2000-10-19','','HORNI001','HORN INTERNATIONAL FORWARDING.,INC.','44 DUNHAM ROAD','BILLERICA, MA 01821 USA','','','',0,'','',0,'','',0,'',0,'',0,'','0020157','BOSS CARGO LIMITED','UNITS 4/5, THE ALCORNS','CAMBRIDGE ROAD','ESSEX CM24 8DF, STANSTED','UNITED KINGDOM','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','',' 746-9125','','','','','','','','',' #:HFA-2236M','US','','','','HFA-2236M','','037','','','','13360196','','','','','','PHL','HEA','','','','','','USD','P','P','NCV','199,124.94','NIL','','2000-10-19','','2000-10-19','','98','2000-10-21','','',NULL,'','',NULL,'','',NULL,'','','LIGHTNING EXPRESS','','BOSTON','','BILLERICA, MA','HEA','BOS','','','','BOSTON, MA','HEA','','','','HEATHROW AIRPORT','','','','UNITED KINGDOM','','',NULL,'2000-10-22','',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL.','ATTN: HOWARD DACK 441279815322','','','','','',1590.75,0.00,0.00,0.00,0.00,0.00,151.50,0.00,0.00,0.00,1742.25,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','AS AGENT','MICHELLE O''BRIEN','2000-10-19','BILLERICA, MA','K','',0,'I',366,0,1,1,'','','','','','','','',0,5.00,1,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' ),( '001','','','','M',0,'HFA-2237M','001 268','','A','E','I','2000-10-19','','HORNI001','HORN INTERNATIONAL FORWARDING.,INC.','44 DUNHAM ROAD','BILLERICA, MA 01821 USA','','','',0,'','',0,'','',0,'',0,'',0,'','','EMERALD FREIGHT EXPRESS','SANTRY HALL INDUSTRIAL ESTATE','DUBLIN 9','DUBLIN, IRELAND','','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','',' "JFK010586"','','','','','','','','',' #:HFA-2237M','AF','','','','HFA-2237','','057','','','','61822600','','','','','','CDG','DUB','AF','','','','','USD','P','P','NCV','NCV','NIL','','2000-08-31','','2000-08-31','','337','2000-10-21','','9486','2000-10-23','','',NULL,'','',NULL,'','','','','','','','DUB','BOS','','','','BOSTON, MA','DUB','','','','DUBLIN','','','','IRELAND','','',NULL,'2000-10-25','',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL.','','','','','','',2865.80,0.00,0.00,0.00,0.00,0.00,0.00,0.00,204.70,0.00,3070.50,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','AS AGENT','MICHELLE O''BRIEN','2000-10-19','BILLERICA, MA','K','',0,'I',366,0,1,1,'','','','','','','','',0,5.00,1,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' ),( '001','','','','H',1,'HFA-2237','001 270','','A','E','I','2000-10-20','','0020003','GENUITY INC','3 VAN DE GRAAF DRIVE','','','BURLINGTON','MA',0,'01803','',0,'','',0,'',0,'',0,'','','TELECITY','UNIT 4027/4029 CITY WEST AVENUE','CITY WEST BUSINESS PARK','DUBLIN D24','ATTN: GARY WATSON','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',' #:HFA-2237','AF','','','','HFA-2237','','057','','','','61822600','','','','HFA-2237','','CDG','DUB','AF','','','','','USD','P','P','NCV','NCV','NIL','','2000-08-31','','2000-08-31','','337','2000-10-21','','9486','2000-10-23','','',NULL,'','',NULL,'','','','','','','','DUB','BOS','','','','BOSTON, MA','DUB','','','','DUBLIN','','','','IRELAND','','',NULL,'2000-10-25','',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL.','','','','','','',2865.80,0.00,0.00,0.00,0.00,0.00,0.00,0.00,204.70,0.00,3070.50,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','AS AGENT','MICHELLE O''BRIEN','2000-10-20','BILLERICA, MA','K','',0,'I',366,0,1,1,'','','','','','','','',0,5.00,1,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' ),( '001','','','','H',1,'HFA-2238','001 271','','A','E','I','2000-10-20','','','ADVANCED DESIGN & MANUFACTURING','350 HERITAGE AVENUE','PORTSMOUTH, NH USA','','','',0,'','',0,'','',0,'',0,'',0,'','','MITSUI ENGINEERING & SHIP BLDG','6-4, TSUKIJI 5-CHOME','CHUO-KU','TOKYO 104-8439','JAPAN','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',' #:HFA-2238','NW','','','','','','012','','','','90872375','','','','HFA-2238','','','TYO','','','','','','USD','P','P','NCV','45,650.','NIL','','2000-10-20','','2000-10-20','','',NULL,'','',NULL,'','',NULL,'','',NULL,'','','LIGHTNING','','NH','','PORTSMOUTH, NH','TYO','BOS','','','','BOSTON, MA','TYO','','','','TOKYO','','','','JAPAN','','',NULL,NULL,'',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL.','','','','','','',965.20,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,965.20,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','AS AGENT','MICHELLE O''BRIEN','2000-10-20','BILLERICA, MA','K','',0,'I',366,0,1,1,'','','','','','','','',0,5.00,1,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' ),( '001','','','','M',0,'HFA-2238M','001 272','','A','E','I','2000-10-20','','HORNI001','HORN INTERNATIONAL FORWARDING.,INC.','44 DUNHAM ROAD','BILLERICA, MA 01821 USA','','','',0,'','',0,'','',0,'',0,'',0,'','','AIR TIGER EXPRESS , JAPAN','TOKYO RYUTSU CENTER AW4-7','6-1-1 HEIWAJIMA','OTA-KU , TOKYO','JAPAN','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',' #:HFA-2238M','NW','','','','HFA-2238M','','012','','','','90872375','','','','','','JFK','TYO','','','','','','USD','P','P','NCV','45,650.','NIL','','2000-10-20','','2000-10-20','','907','2000-10-23','','',NULL,'','',NULL,'','',NULL,'','','LIGHTNING','','NH','','PORTSMOUTH, NH','TYO','BOS','','','','BOSTON, MA','TYO','','','','TOKYO','','','','JAPAN','','',NULL,NULL,'',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL.','','','','','','',965.20,0.00,0.00,0.00,0.00,0.00,76.20,0.00,0.00,0.00,1041.40,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','AS AGENT','MICHELLE O''BRIEN','2000-10-20','BILLERICA, MA','K','',0,'I',366,0,1,1,'','','','','','','','',0,5.00,1,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' ),( '001','','','','H',1,'HFA-2243','001 274','','A','E','I','2000-10-26','','0020220','DEC-E-TECH, INC.','5 PROGRESS AVENUE','','','TYNGSBORO','MA',0,'01879','',0,'','',0,'',0,'',0,'','','MEDISENSE INC,','R & D ENGINEERING','14/15 EYSTON WAY','ABINGTON OXON OX14 ITR ENGLAND','','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',' #:HFA-2243','AF','','','','','','057','','','','61822611','','','','HFA-2243','','PIK','HEA','','','','','','USD','P','P','NCV','38,713.','NIL','','2000-10-26','','2000-10-26','','6497','2000-10-29','','638L','2000-10-30','','',NULL,'','',NULL,'','','','','','','','HEA','BOS','','','','BOSTON, MA','HEA','','','','HEATHROW AIRPORT','','','','UNITED KINGDOM','','',NULL,'2000-10-31','0600',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL.','','','','','','',1080.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1080.00,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','AS AGENT','MICHELLE O''BRIEN','2000-10-26','BILLERICA, MA','K','',0,'I',366,0,1,1,'','','','','','','','',0,5.00,1,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' ),( '001','','','','M',0,'HFA-2243M','001 275','','A','E','I','2000-10-26','','HORNI001','HORN INTERNATIONAL FORWARDING.,INC.','44 DUNHAM ROAD','BILLERICA, MA 01821 USA','','','',0,'','',0,'','',0,'',0,'',0,'','0020157','BOSS CARGO LIMITED','UNITS 4/5, THE ALCORNS','CAMBRIDGE ROAD','ESSEX CM24 8DF, STANSTED','UNITED KINGDOM','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','',' ''JFK010274"','','','','','','','','',' #:HFA-2243M','AF','','','','HFA-2243M','','057','','','','61822611','','','','','','PIK','HEA','','','','','','USD','P','P','NCV','38,713.','NIL','','2000-10-26','','2000-10-26','','6497','2000-11-05','','638L','2000-11-06','','',NULL,'','',NULL,'','','','','','','','HEA','BOS','','','','BOSTON, MA','HEA','','','','HEATHROW AIRPORT','','','','UNITED KINGDOM','','',NULL,'2000-11-07','0600',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL.','','','','','','',1346.40,0.00,0.00,0.00,0.00,0.00,135.00,0.00,0.00,0.00,1481.40,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','AS AGENT','MICHELLE O''BRIEN','2000-10-26','BILLERICA, MA','K','',0,'I',366,0,1,1,'','','','','','','','',0,5.00,1,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' ),( '001','','','','H',1,'HFA-2247','001 276','','A','E','I','2000-10-30','','0020213','BATES FINISHING SUPPLY COMPANY','168 AYER ROAD','LITTLETON','','','MA',0,'01460','',0,'','',0,'',0,'',0,'','','ENGINEERING STORES','WYETH MEDICA, IRELAND','LITTLE CINNEKK, NEWBRIDGE','CO. KILDARE IRELAND','','',0,'','ORDER NO.23955OP','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',' #:HFA-2247','VS','','','','','','932','','','','04223660','','','','HFA-2247','','LON','','','','','','','USD','P','P','NCV','250.','NIL','','2000-08-31','','2000-08-31','','12','2000-10-31','','',NULL,'','',NULL,'','',NULL,'','','','','','','','DUB','BOS','','','','BOSTON, MA','DUB','','','','DUBLIN','','','','IRELAND','','',NULL,'2000-11-01','',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL.','','','','','','',908.60,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1117.20,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','AS AGENT','MICHELLE O''BRIEN','2000-10-30','BILLERICA, MA','K','',0,'I',366,0,1,1,'','','','','','','','',0,5.00,1,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' ),( '001','','','','M',0,'HFA-2247M','001 277','','A','E','I','2000-10-30','','HORNI001','HORN INTERNATIONAL FORWARDING.,INC.','44 DUNHAM ROAD','BILLERICA, MA 01821 USA','','','',0,'','',0,'','',0,'',0,'',0,'','','EMERALD FREIGHT EXPRESS','SANTRY HALL INDUSTRIAL ESTATE','DUBLIN 9','DUBLIN, IRELAND','','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',' #:HFA-2247M','VS','','','','HFA-2247','','932','','','','04223660','','','','','','LON','DUB','','','','','','USD','P','P','NCV','NCV','NIL','','2000-08-31','','2000-08-31','','12','2000-10-31','','',NULL,'','',NULL,'','',NULL,'','','','','','','','DUB','BOS','','','','BOSTON, MA','DUB','','','','DUBLIN','','','','IRELAND','','',NULL,'2000-11-01','',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL.','','','','','','',70.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1.60,0.00,24.00,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','AS AGENT','MICHELLE O''BRIEN','2000-10-30','BILLERICA, MA','K','',0,'I',366,0,1,1,'','','','','','','','',0,5.00,1,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' ),( '001','','','','H',1,'HFA-2244','001 279','','A','E','I','2000-11-01','','SHIRT','THE SHIRT FACTORY','47A NORTHWESTERN','','','SALEM','NH',0,'03079','',0,'','',0,'',0,'',0,'','','CARIBBEAN BOTTLERS JAMAICA LTD','695 SPANISH TOWN ROAD','KINGSTON II','JAMAICA','','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',' #:HFA-2244','JM','','','','','','201','','','','98130303','','','','HFA-2244','','JFK','KIN','','','','','','USD','P','P','NCV','7750.','NIL','','2000-11-01','','2000-11-01','','010','2000-11-04','','',NULL,'','',NULL,'','',NULL,'','','','','','','','KIN','BOS','','','','BOSTON, MA','KIN','','','','KINGSTON','','','','JAMAICA','','',NULL,NULL,'',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL.','TEL: 1898 6624410 X 288','','','','','',429.19,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,429.19,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','AS AGENT','MICHELLE O''BRIEN','2000-11-01','BILLERICA, MA','K','',0,'I',366,0,1,1,'','','','','','','','',0,5.00,1,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' ),( '001','','','','M',0,'HFA-2244M','001 280','','A','E','I','2000-11-01','','HORNI001','HORN INTERNATIONAL FORWARDING.,INC.','44 DUNHAM ROAD','BILLERICA, MA 01821 USA','','','',0,'','',0,'','',0,'',0,'',0,'','','CARIBBEAN BOTTLERS JAMAICA LTD','695 SPANISH TOWN ROAD','KINGSTON II','JAMAICA','','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',' #:HFA-2244M','JM','','','','HFA-2244M','','201','','','','98130303','','','','','','JFK','KIN','','','','','','USD','P','P','NCV','','NIL','','2000-11-01','','2000-11-01','','010','2000-11-04','','',NULL,'','',NULL,'','',NULL,'','','','','','','','KIN','BOS','','','','BOSTON, MA','KIN','','','','KINGSTON','','','','JAMAICA','','',NULL,NULL,'',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL.','TEL: 1898 6624410 X 288','','','','','',429.19,0.00,0.00,0.00,0.00,0.00,25.70,0.00,0.00,0.00,454.89,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','AS AGENT','MICHELLE O''BRIEN','2000-11-01','BILLERICA, MA','K','',0,'I',366,0,1,1,'','','','','','','','',0,5.00,1,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' ),( '001','','','','H',1,'HFA-2252','001 282','','A','E','I','2000-11-03','',' RNI001','HEIDELBERG WEB PRESS','121 BROADWAY','DOVER','NH','','',0,'','',0,'','',0,'',0,'',0,'','BECHTRANS','OFFSET ALPINE PRTG','42 BOOREA STREET','LIDCOMBE, NSW','AUSTRALIA','','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','CSOOP2399','',' #:HFA-2252','QF','','','','HFA2278','','081','','','','90150270','','','','HFA-2252','','SYD','','','','','','','USD','P','P','NCV','679.32','NIL','','2000-07-07','','2000-07-07','','7554','2000-11-04','','',NULL,'','',NULL,'','',NULL,'','','','','N.H.','','N.H.','SYD','BOS','','','','BOSTON, MA','SYD','','','','SDNEY, AUSTRALIA','','AUSTRALIA','','AUSTRALIA','','',NULL,'2000-11-06','',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL.','TEL: 61293169500 FAX:61293166585','','','','','',328.60,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,328.60,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','MICHELLE O''BRIEN','AS AGENTS','2000-11-03','BILLERICA, MA','K','',0,'I',166,0,1,1,'','','','','','','','',0,5.00,0,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' ),( '001','','','','M',0,'HFA-2252M','001 283','','A','E','I','2000-11-03','','HORNI001','HORN INTERNATIONAL FORWARDING.,INC.','44 DUNHAM ROAD','BILLERICA, MA 01821 USA','','','',0,'','',0,'','',0,'',0,'',0,'','0020164','BECHTRANS INTL PTY LTD','31 PEMBERTON STREET','BOTANY, N.S.W. 2019','AUSTRALIA','','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',' #:HFA-2252M','QF','','','','HFA2252','','081','','','','90150270','','','','','','SYD','','','','','','','USD','P','P','NCV','NCV','NIL','','2000-07-07','','2000-07-07','','7554','2000-11-04','','',NULL,'','',NULL,'','',NULL,'','','','','N.H.','','N.H.','SYD','BOS','','','','BOSTON, MA','SYD','','','','SYDNEY AUSTRALIA','','AUSTRALIA','','AUSTRALIA','','',NULL,'2000-11-06','',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL.','TEL: 61293169500 FAX:61293166585','','','','','',328.60,0.00,0.00,0.00,0.00,0.00,0.00,0.00,26.50,0.00,355.10,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','MICHELLE O''BRIEN','AS AGENTS','2000-11-03','BILLERICA, MA','K','',0,'I',166,0,1,1,'','','','','','','','',0,5.00,0,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' ),( '001','','','','H',1,'HFA-2258','001 284','','A','E','I','2000-11-08','','SHIRT','THE SHIRT FACTORY','47A NORTHWESTERN','','','SALEM','NH',0,'03079','',0,'','',0,'',0,'',0,'','','SUNNY SIDE UP','23 AIZIMUCHU CANYON PLAZA 9F','SHINJUKU-KU TOKYO 160-0005','JAPAN','','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',' #:HFA-2258','NW','','','','','','012','','','','90872390','','','','HFA-2258','','NRT','','','','','','','USD','P','P','NCV','380.','NIL','','2000-11-01','','2000-11-01','','907','2000-11-09','','',NULL,'','',NULL,'','',NULL,'','','','','','','','TYO','BOS','','','','BOSTON, MA','TYO','','','','TOKYO','','','','JAMAICA','','',NULL,NULL,'',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL.','TEL:81333588864','','','','','',28.39,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,28.39,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','AS AGENT','MICHELLE O''BRIEN','2000-11-08','BILLERICA, MA','K','',0,'I',366,0,1,1,'','','','','','','','',0,5.00,1,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' ),( '001','','','','M',0,'HFA-2258M','001 285','','A','E','I','2000-11-08','','HORNI001','HORN INTERNATIONAL FORWARDING.,INC.','44 DUNHAM ROAD','BILLERICA, MA 01821 USA','','','',0,'','',0,'','',0,'',0,'',0,'','','AIR TIGER EXPRESS , JAPAN','TOKYO RYUTSU CENTER AW4-7','6-1-1 HEIWAJIMA','OTA-KU , TOKYO','JAPAN','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',' #:HFA-2258M','NW','','','','HFA-2258M','','012','','','','90872390','','','','','','NRT','','','','','','','USD','P','P','NCV','NCV','NIL','','2000-10-20','','2000-10-20','','907','2000-11-09','','',NULL,'','',NULL,'','',NULL,'','','LIGHTNING','','NH','','SALEM,NH','TYO','BOS','','','','BOSTON, MA','TYO','','','','TOKYO','','','','JAPAN','','',NULL,NULL,'',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL.','','','','','','',101.15,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1.70,0.00,102.85,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','AS AGENT','MICHELLE O''BRIEN','2000-11-08','BILLERICA, MA','K','',0,'I',366,0,1,1,'','','','','','','','',0,5.00,1,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' ),( '001','','','','H',1,'HFA-2259','001 286','','A','E','I','2000-11-09','','HEIDELD','HEIDELBERG WEB PRESS INC','121 BROADWAY','','','DOVER','NH',0,'03820-3290','',0,'','',0,'',0,'',0,'','HANNANPRI','HANNANPRINT VICTORIA','NOBLE PARK','VICTORIA 3174','AUSTRALIA','','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','NOTIFY HEIDELBERG AUSTRALIA','STUART KEAM / MIKE NORMAN','UPON ARRIVAL','','','','','','HFA-2259','',' #:HFA-2259','QF','','','','HFA-2259','','081','','','','90150266','','','','HFA-2259','','MEL','','','','','','','USD','P','P','NCV','905.76','NIL','','2000-07-07','','2000-07-07','','7556','2000-11-11','','',NULL,'','',NULL,'','',NULL,'','','','','NH','','N.H.','MEL','BOS','','','','BOSTON, MA','MEL','','','','MELBOURNE, AUSTRALIA','','AUSTRALIA','','AUSTRALIA','','',NULL,'0200-11-13','',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL :','','','','','','',331.70,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,331.70,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','MICHELLE O''BRIEN','AS AGENTS','2000-11-09','BILLERICA, MA','K','',0,'I',166,0,1,1,'','','','','','','','',0,5.00,0,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' ),( '001','','','','M',0,'HFA-2259M','001 287','','A','E','I','2000-11-09','','HORNI001','HORN INTERNATIONAL FORWARDING.,INC.','44 DUNHAM ROAD','BILLERICA, MA 01821 USA','','','',0,'','',0,'','',0,'',0,'',0,'','BECH-MEL','BECHTRANS INTL PTY, LTD','UNITS 33/34 MIAC BLDING','INTERNATIONAL DRIVE','TULLAMARINE, VICTORIA, 3043','','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','HFA-2259','',' #:HFA-2259M','QF','','','','HFA-2259','','081','','','','90150266','','','','','','MEL','','','','','','','USD','P','P','NCV','NCV','NIL','','2000-07-07','','2000-07-07','','7556','2000-11-11','','',NULL,'','',NULL,'','',NULL,'','','','','N.H.','','N.H.','MEL','BOS','','','','BOSTON, MA','MEL','','','','MELBOURNE, AUSTRALIA','','AUSTRALIA','','AUSTRALIA','','',NULL,'2000-11-13','',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL.','TEL: 61393354411 FAX:61393352612','','','','','',331.70,0.00,0.00,0.00,0.00,0.00,0.00,0.00,26.75,0.00,358.45,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','MICHELLE O''BRIEN','AS AGENTS','2000-11-09','BILLERICA, MA','K','',0,'I',166,0,1,1,'','','','','','','','',0,5.00,0,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' )"
Local 8: N 20
Local 9: U
Local 10: A Len: 279
Local 11: B {|| ... }
Local 12: A Len: 279
Local 13: A Len: 279
Local 14: C " "
Local 15: U
Local 16: C "..."
Local 17: U
Local 18: U
Local 19: C "DBFCDX"
Local 20: L .F.
Local 21: L .F.
Local 22: L .F.
_SQLIMPORT
Param 1: O Class: TSAY
Param 2: O Class: TSAY
Local 1: L .F.
Local 2: C ""
Local 3: O Class: TOLEAUTO
Local 4: U
Local 5: A Len: 182
Local 6: N 1
Local 7: C ""
Local 8: C ""
Local 9: A Len: 0
Local 10: C "winfrt_import.sql"
(b)MAIN
Param 1: O Class: TMENUITEM
TMENU:COMMAND
Param 1: N 20003
Local 1: O Class: TMENU
Local 2: O Class: TMENUITEM
TWINDOW:COMMAND
Param 1: N 20003
Param 2: N 0
Local 1: O Class: TWINDOW
Local 2: N 0
Local 3: N 20003
Local 4: N 0
TWINDOW:HANDLEEVENT
Param 1: N 273
Param 2: N 20003
Param 3: N 0
_FWH
Param 1: N 0
Param 2: N 273
Param 3: N 20003
Param 4: N 0
Param 5: N 1
Local 1: O Class: TWINDOW
WINRUN
Param 1: N 984246
TWINDOW:ACTIVATE
Param 1: C "NORMAL"
Param 2: U
Param 3: U
Param 4: U
Param 5: U
Param 6: U
Param 7: U
Param 8: U
Param 9: U
Param 10: U
Param 11: U
Param 12: U
Param 13: U
Param 14: U
Param 15: U
Param 16: U
Param 17: U
Param 18: U
Param 19: U
Local 1: O Class: TWINDOW
Local 2: U
Local 3: U
MAIN
Local 1: O Class: TSAY
Local 2: O Class: TSAY
Local 3: C "1."
Local 4: C "2."
Local 5: O Class: TFONT
Local 6: O Class: TMENU
Local 7: O Class: TICON

Linked RDDs
===========
DBF
DBFFPT
DBFBLOB
DBFCDX
DBFNTX

DataBases in use
================

1: => SRC RddName: DBFCDX
==============================
RecNo RecCount BOF EOF
126 3945 .F. .F.

Indexes in use TagName

Relations in use

Classes in use:
===============
1 ERROR
2 HASHENTRY
3 HBCLASS
4 HBOBJECT
5 TWINDOW
6 TCONTROL
7 TICON
8 TBRUSH
9 TFONT
10 TMENU
11 TMENUITEM
12 TSAY
13 TMSGBAR
14 TRECT
15 TMSGITEM
16 TTIMER
17 TOLEAUTO
18 TREG32

Memory Analysis
===============
218 Static variables

Dynamic memory consume:
Actual Value: 0 bytes
Highest Value: 0 bytes
*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
User avatar
cdmmaui
 
Posts: 689
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong

Re: DBF to SQL script tool

Postby nageswaragunupudi » Thu Jul 03, 2014 11:59 pm

Please try
FW_AdoImportFromDBF( oCn, "AIR.DBF", "AIR", nil, 1 )
with 5th parameter as 1 to force export 1 row by row instead of 21 rows at a time, which is the default.

This enables us to know which particular record is giving an error.
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10646
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: DBF to SQL script tool

Postby cdmmaui » Fri Jul 04, 2014 12:46 pm

Dear Mr. Rao,

I believe I see the problem. There is a field value with a ' character which is causing a problem with the string, MICHELLE O'BRIEN. How can we handle this scenario?

Application
===========
Path and name: C:\cdm\winsql\cdmsql.exe (32 bits)
Size: 2,547,712 bytes
Compiler version: xHarbour 1.2.3 Intl. (SimpLex) (Build 20130422)
FiveWin Version: FWHX 14.06
Windows version: 6.2, Build 9200

Time from start: 0 hours 0 mins 7 secs
Error occurred at: 07/04/2014, 08:43:52
Error description: Error ADODB.Connection/0 S_OK: EXECUTE
Args:
[ 1] = C INSERT INTO [air] ( [COMPANY],[QUOTENO],[STATION],[DSTSTAT],[HSE],[HOUSE],[FILE],[SERIAL],[BOOKNO],[MODE],[TRANS],[MOVE],[DATE],[STATUS],[SHIPID],[SHIPNAME],[SHIPADD1],[SHIPADD2],[SHIPADD3],[SHIPCITY],[SHIPST],[SHIPSTE],[SHIPZIP],[SHIPISO],[SHIPISOP],[REFERENCE],[SHIPCONT],[SHIPCONTP],[SHIPPH],[SHIPPHP],[SHIPFAX],[SHIPFAXP],[SHIPREP],[CONSID],[CONSNAME],[CONSADD1],[CONSADD2],[CONSADD3],[CONSCITY],[CONSST],[CONSSTE],[CONSZIP],[CONSREF],[CONSISO],[CONSISOP],[CONSCONT],[CONSCONTP],[CONSPH],[CONSPHP],[CONSFAX],[CONSFAXP],[CONSREP],[NOTIID],[NOTINAME],[NOTIADD1],[NOTIADD2],[NOTIADD3],[NOTICITY],[NOTIST],[NOTISTE],[NOTIZIP],[NOTIISO],[NOTIISOP],[NOTICONT],[NOTICONTP],[NOTIPH],[NOTIPHP],[NOTIFAX],[NOTIFAXP],[PICKID],[PICKNAME],[PICKADD1],[PICKADD2],[PICKADD3],[PICKCITY],[PICKST],[PICKZIP],[PICKCONT],[PICKPH],[PICKFAX],[DESTID],[DESTNAME],[DESTADD1],[DESTADD2],[DESTADD3],[DESTCITY],[DESTST],[DESTZIP],[DESTCONT],[DESTPH],[DESTFAX],[ACCTID],[ACCT01],[ACCT02],[ACCT03],[ACCT04],[ACCT05],[ACCT06],[ACCT07],[ACCT08],[EXREF01],[EXREF02],[EXREF03],[CARRIER],[CARRIER2],[CARRIER3],[CARRIER4],[MANIFEST],[SUBMAN],[PFX],[PFX02],[PFX03],[PFX04],[MBILL],[MBILL2],[MBILL3],[MBILL4],[HBILL],[BOOKING],[TO01],[TO02],[BY02],[TO03],[BY03],[TO04],[BY04],[CURRENCY],[WTVAL],[OTHER],[CARVAL],[CUSVAL],[INSVAL],[AIRMIN],[PICKDATE],[PICKTIME],[DELVDATE],[DELVTIME],[FLT01],[DTE01],[TME01],[FLT02],[DTE02],[TME02],[FLT03],[DTE03],[TME03],[FLT04],[DTE04],[TME04],[PRECARRID],[PRECARR],[PRCODE],[PLACEREC],[ORCODE],[ORIGIN],[CONSOL],[POL],[POL02],[POL03],[POL04],[PORTLOAD],[POUL],[POUL02],[POUL03],[POUL04],[PORTDISC],[PDCODE],[PLACEDEL],[ULCODE],[ULTIMATE],[SERVICE],[PRIORITY],[DEPART],[ETA],[ETATIME],[ETA02],[ETATIME2],[ETA03],[ETATIME3],[ETA04],[ETATIME4],[HSECAR],[HANDLE01],[HANDLE02],[HANDLE03],[DELV01],[DELV02],[DELV03],[RATEID],[WTPPD],[WTCOL],[VCPPD],[VCCOL],[TXPPD],[TXCOL],[DAPPD],[DACOL],[DCPPD],[DCCOL],[TOTPPD],[TOTCOL],[WBLINE01],[WBLINE02],[WBLINE03],[WBLINE04],[ISSDATE],[ISSPLACE],[WTCODE],[OFFICIAL],[INVCNT],[INCH],[DIMFACT],[DIMWT],[ZONEF],[ZONET],[ZF01],[ZF02],[ZF03],[ZF04],[ZT01],[ZT02],[ZT03],[ZT04],[AIRCOMM],[AIRPERCENT],[BILLABLE],[READY],[CLOSE],[TRANSMIT],[AWBM],[ADDBY],[ADDDATE],[LASTUSER],[LASTDATE],[LASTTIME],[SITA],[SITAFLAG],[SITADATE],[SITATIME],[SITACODE],[SITALDATE],[SITALTIME],[CLOSED],[CLOSEDATE],[CLOSETIME],[CLOSEUSER],[CUSTID],[CUSTNAME],[CUSTREP],[COONAME],[COOCOUNTRY],[COOBODY],[DOCKBODY],[REP],[ACTUAL],[INVOICED],[INVOICE],[INVDATE],[INVUSER],[TRADELANE],[CUSTOM01],[CUSTOM02],[CUSTOM03],[CUSTOM04],[CUSTOM05],[BLDIVER],[FWBDATE],[FWBTIME],[FWBUSER],[FWBNO],[FHLDATE],[FHLTIME],[FHLUSER],[FHLNO],[ESTREVENUE],[UNKNOWN],[ITEM1],[ITEM2],[ITEM3] ) VALUES ( '001','','','','H',1,'HFA-2259','001 286','','A','E','I','2000-11-09','','HEIDELD','HEIDELBERG WEB PRESS INC','121 BROADWAY','','','DOVER','NH',0,'03820-3290','',0,'','',0,'',0,'',0,'','HANNANPRI','HANNANPRINT VICTORIA','NOBLE PARK','VICTORIA 3174','AUSTRALIA','','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','NOTIFY HEIDELBERG AUSTRALIA','STUART KEAM / MIKE NORMAN','UPON ARRIVAL','','','','','','HFA-2259','',' #:HFA-2259','QF','','','','HFA-2259','','081','','','','90150266','','','','HFA-2259','','MEL','','','','','','','USD','P','P','NCV','905.76','NIL','','2000-07-07','','2000-07-07','','7556','2000-11-11','','',NULL,'','',NULL,'','',NULL,'','','','','NH','','N.H.','MEL','BOS','','','','BOSTON, MA','MEL','','','','MELBOURNE, AUSTRALIA','','AUSTRALIA','','AUSTRALIA','','',NULL,'0200-11-13','',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL :','','','','','','',331.70,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,331.70,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','MICHELLE O''BRIEN','AS AGENTS','2000-11-09','BILLERICA, MA','K','',0,'I',166,0,1,1,'','','','','','','','',0,5.00,0,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' ),( '001','','','','M',0,'HFA-2259M','001 287','','A','E','I','2000-11-09','','HORNI001','HORN INTERNATIONAL FORWARDING.,INC.','44 DUNHAM ROAD','BILLERICA, MA 01821 USA','','','',0,'','',0,'','',0,'',0,'',0,'','BECH-MEL','BECHTRANS INTL PTY, LTD','UNITS 33/34 MIAC BLDING','INTERNATIONAL DRIVE','TULLAMARINE, VICTORIA, 3043','','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','HFA-2259','',' #:HFA-2259M','QF','','','','HFA-2259','','081','','','','90150266','','','','','','MEL','','','','','','','USD','P','P','NCV','NCV','NIL','','2000-07-07','','2000-07-07','','7556','2000-11-11','','',NULL,'','',NULL,'','',NULL,'','','','','N.H.','','N.H.','MEL','BOS','','','','BOSTON, MA','MEL','','','','MELBOURNE, AUSTRALIA','','AUSTRALIA','','AUSTRALIA','','',NULL,'2000-11-13','',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL.','TEL: 61393354411 FAX:61393352612','','','','','',331.70,0.00,0.00,0.00,0.00,0.00,0.00,0.00,26.75,0.00,358.45,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','MICHELLE O''BRIEN','AS AGENTS','2000-11-09','BILLERICA, MA','K','',0,'I',166,0,1,1,'','','','','','','','',0,5.00,0,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' )

Stack Calls
===========
Called from: => TOLEAUTO:EXECUTE( 0 )
Called from: .\source\function\ADOFUNCS.PRG => FW_ADOIMPORTFROMDBF( 1082 )
Called from: cdmsql.prg => _SQLIMPORT( 193 )
Called from: cdmsql.prg => (b)MAIN( 67 )
Called from: .\source\classes\MENU.PRG => TMENU:COMMAND( 463 )
Called from: .\source\classes\WINDOW.PRG => TWINDOW:COMMAND( 1050 )
Called from: => TWINDOW:HANDLEEVENT( 0 )
Called from: .\source\classes\WINDOW.PRG => _FWH( 3279 )
Called from: => WINRUN( 0 )
Called from: .\source\classes\WINDOW.PRG => TWINDOW:ACTIVATE( 1003 )
Called from: cdmsql.prg => MAIN( 83 )

System
======
CPU type: Intel(R) Xeon(R) CPU E5-2407 0 @ 2.20GHz 2200 Mhz
Hardware memory: 12243 megs

Free System resources: 90 %
GDI resources: 90 %
User resources: 90 %

Windows total applications running: 2
1 ,
2 Task Switching, C:\cdm\winsql\cdmsql.exe

Variables in use
================
Procedure Type Value
==========================
TOLEAUTO:EXECUTE
Param 1: C "INSERT INTO [air] ( [COMPANY],[QUOTENO],[STATION],[DSTSTAT],[HSE],[HOUSE],[FILE],[SERIAL],[BOOKNO],[MODE],[TRANS],[MOVE],[DATE],[STATUS],[SHIPID],[SHIPNAME],[SHIPADD1],[SHIPADD2],[SHIPADD3],[SHIPCITY],[SHIPST],[SHIPSTE],[SHIPZIP],[SHIPISO],[SHIPISOP],[REFERENCE],[SHIPCONT],[SHIPCONTP],[SHIPPH],[SHIPPHP],[SHIPFAX],[SHIPFAXP],[SHIPREP],[CONSID],[CONSNAME],[CONSADD1],[CONSADD2],[CONSADD3],[CONSCITY],[CONSST],[CONSSTE],[CONSZIP],[CONSREF],[CONSISO],[CONSISOP],[CONSCONT],[CONSCONTP],[CONSPH],[CONSPHP],[CONSFAX],[CONSFAXP],[CONSREP],[NOTIID],[NOTINAME],[NOTIADD1],[NOTIADD2],[NOTIADD3],[NOTICITY],[NOTIST],[NOTISTE],[NOTIZIP],[NOTIISO],[NOTIISOP],[NOTICONT],[NOTICONTP],[NOTIPH],[NOTIPHP],[NOTIFAX],[NOTIFAXP],[PICKID],[PICKNAME],[PICKADD1],[PICKADD2],[PICKADD3],[PICKCITY],[PICKST],[PICKZIP],[PICKCONT],[PICKPH],[PICKFAX],[DESTID],[DESTNAME],[DESTADD1],[DESTADD2],[DESTADD3],[DESTCITY],[DESTST],[DESTZIP],[DESTCONT],[DESTPH],[DESTFAX],[ACCTID],[ACCT01],[ACCT02],[ACCT03],[ACCT04],[ACCT05],[ACCT06],[ACCT07],[ACCT08],[EXREF01],[EXREF02],[EXREF03],[CARRIER],[CARRIER2],[CARRIER3],[CARRIER4],[MANIFEST],[SUBMAN],[PFX],[PFX02],[PFX03],[PFX04],[MBILL],[MBILL2],[MBILL3],[MBILL4],[HBILL],[BOOKING],[TO01],[TO02],[BY02],[TO03],[BY03],[TO04],[BY04],[CURRENCY],[WTVAL],[OTHER],[CARVAL],[CUSVAL],[INSVAL],[AIRMIN],[PICKDATE],[PICKTIME],[DELVDATE],[DELVTIME],[FLT01],[DTE01],[TME01],[FLT02],[DTE02],[TME02],[FLT03],[DTE03],[TME03],[FLT04],[DTE04],[TME04],[PRECARRID],[PRECARR],[PRCODE],[PLACEREC],[ORCODE],[ORIGIN],[CONSOL],[POL],[POL02],[POL03],[POL04],[PORTLOAD],[POUL],[POUL02],[POUL03],[POUL04],[PORTDISC],[PDCODE],[PLACEDEL],[ULCODE],[ULTIMATE],[SERVICE],[PRIORITY],[DEPART],[ETA],[ETATIME],[ETA02],[ETATIME2],[ETA03],[ETATIME3],[ETA04],[ETATIME4],[HSECAR],[HANDLE01],[HANDLE02],[HANDLE03],[DELV01],[DELV02],[DELV03],[RATEID],[WTPPD],[WTCOL],[VCPPD],[VCCOL],[TXPPD],[TXCOL],[DAPPD],[DACOL],[DCPPD],[DCCOL],[TOTPPD],[TOTCOL],[WBLINE01],[WBLINE02],[WBLINE03],[WBLINE04],[ISSDATE],[ISSPLACE],[WTCODE],[OFFICIAL],[INVCNT],[INCH],[DIMFACT],[DIMWT],[ZONEF],[ZONET],[ZF01],[ZF02],[ZF03],[ZF04],[ZT01],[ZT02],[ZT03],[ZT04],[AIRCOMM],[AIRPERCENT],[BILLABLE],[READY],[CLOSE],[TRANSMIT],[AWBM],[ADDBY],[ADDDATE],[LASTUSER],[LASTDATE],[LASTTIME],[SITA],[SITAFLAG],[SITADATE],[SITATIME],[SITACODE],[SITALDATE],[SITALTIME],[CLOSED],[CLOSEDATE],[CLOSETIME],[CLOSEUSER],[CUSTID],[CUSTNAME],[CUSTREP],[COONAME],[COOCOUNTRY],[COOBODY],[DOCKBODY],[REP],[ACTUAL],[INVOICED],[INVOICE],[INVDATE],[INVUSER],[TRADELANE],[CUSTOM01],[CUSTOM02],[CUSTOM03],[CUSTOM04],[CUSTOM05],[BLDIVER],[FWBDATE],[FWBTIME],[FWBUSER],[FWBNO],[FHLDATE],[FHLTIME],[FHLUSER],[FHLNO],[ESTREVENUE],[UNKNOWN],[ITEM1],[ITEM2],[ITEM3] ) VALUES ( '001','','','','H',1,'HFA-2259','001 286','','A','E','I','2000-11-09','','HEIDELD','HEIDELBERG WEB PRESS INC','121 BROADWAY','','','DOVER','NH',0,'03820-3290','',0,'','',0,'',0,'',0,'','HANNANPRI','HANNANPRINT VICTORIA','NOBLE PARK','VICTORIA 3174','AUSTRALIA','','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','NOTIFY HEIDELBERG AUSTRALIA','STUART KEAM / MIKE NORMAN','UPON ARRIVAL','','','','','','HFA-2259','',' #:HFA-2259','QF','','','','HFA-2259','','081','','','','90150266','','','','HFA-2259','','MEL','','','','','','','USD','P','P','NCV','905.76','NIL','','2000-07-07','','2000-07-07','','7556','2000-11-11','','',NULL,'','',NULL,'','',NULL,'','','','','NH','','N.H.','MEL','BOS','','','','BOSTON, MA','MEL','','','','MELBOURNE, AUSTRALIA','','AUSTRALIA','','AUSTRALIA','','',NULL,'0200-11-13','',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL :','','','','','','',331.70,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,331.70,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','MICHELLE O''BRIEN','AS AGENTS','2000-11-09','BILLERICA, MA','K','',0,'I',166,0,1,1,'','','','','','','','',0,5.00,0,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' ),( '001','','','','M',0,'HFA-2259M','001 287','','A','E','I','2000-11-09','','HORNI001','HORN INTERNATIONAL FORWARDING.,INC.','44 DUNHAM ROAD','BILLERICA, MA 01821 USA','','','',0,'','',0,'','',0,'',0,'',0,'','BECH-MEL','BECHTRANS INTL PTY, LTD','UNITS 33/34 MIAC BLDING','INTERNATIONAL DRIVE','TULLAMARINE, VICTORIA, 3043','','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','HFA-2259','',' #:HFA-2259M','QF','','','','HFA-2259','','081','','','','90150266','','','','','','MEL','','','','','','','USD','P','P','NCV','NCV','NIL','','2000-07-07','','2000-07-07','','7556','2000-11-11','','',NULL,'','',NULL,'','',NULL,'','','','','N.H.','','N.H.','MEL','BOS','','','','BOSTON, MA','MEL','','','','MELBOURNE, AUSTRALIA','','AUSTRALIA','','AUSTRALIA','','',NULL,'2000-11-13','',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL.','TEL: 61393354411 FAX:61393352612','','','','','',331.70,0.00,0.00,0.00,0.00,0.00,0.00,0.00,26.75,0.00,358.45,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','MICHELLE O''BRIEN','AS AGENTS','2000-11-09','BILLERICA, MA','K','',0,'I',166,0,1,1,'','','','','','','','',0,5.00,0,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' )"
Local 1: U
Local 2: C "ADODB.Connection"
FW_ADOIMPORTFROMDBF
Param 1: O Class: TOLEAUTO
Param 2: C "AIR.dbf"
Param 3: C "air"
Param 4: U
Param 5: N 1
Local 1: U
Local 2: C "SRC"
Local 3: A Len: 280
Local 4: C "INSERT INTO [air] ( [COMPANY],[QUOTENO],[STATION],[DSTSTAT],[HSE],[HOUSE],[FILE],[SERIAL],[BOOKNO],[MODE],[TRANS],[MOVE],[DATE],[STATUS],[SHIPID],[SHIPNAME],[SHIPADD1],[SHIPADD2],[SHIPADD3],[SHIPCITY],[SHIPST],[SHIPSTE],[SHIPZIP],[SHIPISO],[SHIPISOP],[REFERENCE],[SHIPCONT],[SHIPCONTP],[SHIPPH],[SHIPPHP],[SHIPFAX],[SHIPFAXP],[SHIPREP],[CONSID],[CONSNAME],[CONSADD1],[CONSADD2],[CONSADD3],[CONSCITY],[CONSST],[CONSSTE],[CONSZIP],[CONSREF],[CONSISO],[CONSISOP],[CONSCONT],[CONSCONTP],[CONSPH],[CONSPHP],[CONSFAX],[CONSFAXP],[CONSREP],[NOTIID],[NOTINAME],[NOTIADD1],[NOTIADD2],[NOTIADD3],[NOTICITY],[NOTIST],[NOTISTE],[NOTIZIP],[NOTIISO],[NOTIISOP],[NOTICONT],[NOTICONTP],[NOTIPH],[NOTIPHP],[NOTIFAX],[NOTIFAXP],[PICKID],[PICKNAME],[PICKADD1],[PICKADD2],[PICKADD3],[PICKCITY],[PICKST],[PICKZIP],[PICKCONT],[PICKPH],[PICKFAX],[DESTID],[DESTNAME],[DESTADD1],[DESTADD2],[DESTADD3],[DESTCITY],[DESTST],[DESTZIP],[DESTCONT],[DESTPH],[DESTFAX],[ACCTID],[ACCT01],[ACCT02],[ACCT03],[ACCT04],[ACCT05],[ACCT06],[ACCT07],[ACCT08],[EXREF01],[EXREF02],[EXREF03],[CARRIER],[CARRIER2],[CARRIER3],[CARRIER4],[MANIFEST],[SUBMAN],[PFX],[PFX02],[PFX03],[PFX04],[MBILL],[MBILL2],[MBILL3],[MBILL4],[HBILL],[BOOKING],[TO01],[TO02],[BY02],[TO03],[BY03],[TO04],[BY04],[CURRENCY],[WTVAL],[OTHER],[CARVAL],[CUSVAL],[INSVAL],[AIRMIN],[PICKDATE],[PICKTIME],[DELVDATE],[DELVTIME],[FLT01],[DTE01],[TME01],[FLT02],[DTE02],[TME02],[FLT03],[DTE03],[TME03],[FLT04],[DTE04],[TME04],[PRECARRID],[PRECARR],[PRCODE],[PLACEREC],[ORCODE],[ORIGIN],[CONSOL],[POL],[POL02],[POL03],[POL04],[PORTLOAD],[POUL],[POUL02],[POUL03],[POUL04],[PORTDISC],[PDCODE],[PLACEDEL],[ULCODE],[ULTIMATE],[SERVICE],[PRIORITY],[DEPART],[ETA],[ETATIME],[ETA02],[ETATIME2],[ETA03],[ETATIME3],[ETA04],[ETATIME4],[HSECAR],[HANDLE01],[HANDLE02],[HANDLE03],[DELV01],[DELV02],[DELV03],[RATEID],[WTPPD],[WTCOL],[VCPPD],[VCCOL],[TXPPD],[TXCOL],[DAPPD],[DACOL],[DCPPD],[DCCOL],[TOTPPD],[TOTCOL],[WBLINE01],[WBLINE02],[WBLINE03],[WBLINE04],[ISSDATE],[ISSPLACE],[WTCODE],[OFFICIAL],[INVCNT],[INCH],[DIMFACT],[DIMWT],[ZONEF],[ZONET],[ZF01],[ZF02],[ZF03],[ZF04],[ZT01],[ZT02],[ZT03],[ZT04],[AIRCOMM],[AIRPERCENT],[BILLABLE],[READY],[CLOSE],[TRANSMIT],[AWBM],[ADDBY],[ADDDATE],[LASTUSER],[LASTDATE],[LASTTIME],[SITA],[SITAFLAG],[SITADATE],[SITATIME],[SITACODE],[SITALDATE],[SITALTIME],[CLOSED],[CLOSEDATE],[CLOSETIME],[CLOSEUSER],[CUSTID],[CUSTNAME],[CUSTREP],[COONAME],[COOCOUNTRY],[COOBODY],[DOCKBODY],[REP],[ACTUAL],[INVOICED],[INVOICE],[INVDATE],[INVUSER],[TRADELANE],[CUSTOM01],[CUSTOM02],[CUSTOM03],[CUSTOM04],[CUSTOM05],[BLDIVER],[FWBDATE],[FWBTIME],[FWBUSER],[FWBNO],[FHLDATE],[FHLTIME],[FHLUSER],[FHLNO],[ESTREVENUE],[UNKNOWN],[ITEM1],[ITEM2],[ITEM3] ) VALUES "
Local 5: C "INSERT INTO [air] ( [COMPANY],[QUOTENO],[STATION],[DSTSTAT],[HSE],[HOUSE],[FILE],[SERIAL],[BOOKNO],[MODE],[TRANS],[MOVE],[DATE],[STATUS],[SHIPID],[SHIPNAME],[SHIPADD1],[SHIPADD2],[SHIPADD3],[SHIPCITY],[SHIPST],[SHIPSTE],[SHIPZIP],[SHIPISO],[SHIPISOP],[REFERENCE],[SHIPCONT],[SHIPCONTP],[SHIPPH],[SHIPPHP],[SHIPFAX],[SHIPFAXP],[SHIPREP],[CONSID],[CONSNAME],[CONSADD1],[CONSADD2],[CONSADD3],[CONSCITY],[CONSST],[CONSSTE],[CONSZIP],[CONSREF],[CONSISO],[CONSISOP],[CONSCONT],[CONSCONTP],[CONSPH],[CONSPHP],[CONSFAX],[CONSFAXP],[CONSREP],[NOTIID],[NOTINAME],[NOTIADD1],[NOTIADD2],[NOTIADD3],[NOTICITY],[NOTIST],[NOTISTE],[NOTIZIP],[NOTIISO],[NOTIISOP],[NOTICONT],[NOTICONTP],[NOTIPH],[NOTIPHP],[NOTIFAX],[NOTIFAXP],[PICKID],[PICKNAME],[PICKADD1],[PICKADD2],[PICKADD3],[PICKCITY],[PICKST],[PICKZIP],[PICKCONT],[PICKPH],[PICKFAX],[DESTID],[DESTNAME],[DESTADD1],[DESTADD2],[DESTADD3],[DESTCITY],[DESTST],[DESTZIP],[DESTCONT],[DESTPH],[DESTFAX],[ACCTID],[ACCT01],[ACCT02],[ACCT03],[ACCT04],[ACCT05],[ACCT06],[ACCT07],[ACCT08],[EXREF01],[EXREF02],[EXREF03],[CARRIER],[CARRIER2],[CARRIER3],[CARRIER4],[MANIFEST],[SUBMAN],[PFX],[PFX02],[PFX03],[PFX04],[MBILL],[MBILL2],[MBILL3],[MBILL4],[HBILL],[BOOKING],[TO01],[TO02],[BY02],[TO03],[BY03],[TO04],[BY04],[CURRENCY],[WTVAL],[OTHER],[CARVAL],[CUSVAL],[INSVAL],[AIRMIN],[PICKDATE],[PICKTIME],[DELVDATE],[DELVTIME],[FLT01],[DTE01],[TME01],[FLT02],[DTE02],[TME02],[FLT03],[DTE03],[TME03],[FLT04],[DTE04],[TME04],[PRECARRID],[PRECARR],[PRCODE],[PLACEREC],[ORCODE],[ORIGIN],[CONSOL],[POL],[POL02],[POL03],[POL04],[PORTLOAD],[POUL],[POUL02],[POUL03],[POUL04],[PORTDISC],[PDCODE],[PLACEDEL],[ULCODE],[ULTIMATE],[SERVICE],[PRIORITY],[DEPART],[ETA],[ETATIME],[ETA02],[ETATIME2],[ETA03],[ETATIME3],[ETA04],[ETATIME4],[HSECAR],[HANDLE01],[HANDLE02],[HANDLE03],[DELV01],[DELV02],[DELV03],[RATEID],[WTPPD],[WTCOL],[VCPPD],[VCCOL],[TXPPD],[TXCOL],[DAPPD],[DACOL],[DCPPD],[DCCOL],[TOTPPD],[TOTCOL],[WBLINE01],[WBLINE02],[WBLINE03],[WBLINE04],[ISSDATE],[ISSPLACE],[WTCODE],[OFFICIAL],[INVCNT],[INCH],[DIMFACT],[DIMWT],[ZONEF],[ZONET],[ZF01],[ZF02],[ZF03],[ZF04],[ZT01],[ZT02],[ZT03],[ZT04],[AIRCOMM],[AIRPERCENT],[BILLABLE],[READY],[CLOSE],[TRANSMIT],[AWBM],[ADDBY],[ADDDATE],[LASTUSER],[LASTDATE],[LASTTIME],[SITA],[SITAFLAG],[SITADATE],[SITATIME],[SITACODE],[SITALDATE],[SITALTIME],[CLOSED],[CLOSEDATE],[CLOSETIME],[CLOSEUSER],[CUSTID],[CUSTNAME],[CUSTREP],[COONAME],[COOCOUNTRY],[COOBODY],[DOCKBODY],[REP],[ACTUAL],[INVOICED],[INVOICE],[INVDATE],[INVUSER],[TRADELANE],[CUSTOM01],[CUSTOM02],[CUSTOM03],[CUSTOM04],[CUSTOM05],[BLDIVER],[FWBDATE],[FWBTIME],[FWBUSER],[FWBNO],[FHLDATE],[FHLTIME],[FHLUSER],[FHLNO],[ESTREVENUE],[UNKNOWN],[ITEM1],[ITEM2],[ITEM3] ) VALUES ( '001','','','','H',1,'HFA-2259','001 286','','A','E','I','2000-11-09','','HEIDELD','HEIDELBERG WEB PRESS INC','121 BROADWAY','','','DOVER','NH',0,'03820-3290','',0,'','',0,'',0,'',0,'','HANNANPRI','HANNANPRINT VICTORIA','NOBLE PARK','VICTORIA 3174','AUSTRALIA','','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','NOTIFY HEIDELBERG AUSTRALIA','STUART KEAM / MIKE NORMAN','UPON ARRIVAL','','','','','','HFA-2259','',' #:HFA-2259','QF','','','','HFA-2259','','081','','','','90150266','','','','HFA-2259','','MEL','','','','','','','USD','P','P','NCV','905.76','NIL','','2000-07-07','','2000-07-07','','7556','2000-11-11','','',NULL,'','',NULL,'','',NULL,'','','','','NH','','N.H.','MEL','BOS','','','','BOSTON, MA','MEL','','','','MELBOURNE, AUSTRALIA','','AUSTRALIA','','AUSTRALIA','','',NULL,'0200-11-13','',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL :','','','','','','',331.70,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,331.70,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','MICHELLE O''BRIEN','AS AGENTS','2000-11-09','BILLERICA, MA','K','',0,'I',166,0,1,1,'','','','','','','','',0,5.00,0,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' ),( '001','','','','M',0,'HFA-2259M','001 287','','A','E','I','2000-11-09','','HORNI001','HORN INTERNATIONAL FORWARDING.,INC.','44 DUNHAM ROAD','BILLERICA, MA 01821 USA','','','',0,'','',0,'','',0,'',0,'',0,'','BECH-MEL','BECHTRANS INTL PTY, LTD','UNITS 33/34 MIAC BLDING','INTERNATIONAL DRIVE','TULLAMARINE, VICTORIA, 3043','','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','HFA-2259','',' #:HFA-2259M','QF','','','','HFA-2259','','081','','','','90150266','','','','','','MEL','','','','','','','USD','P','P','NCV','NCV','NIL','','2000-07-07','','2000-07-07','','7556','2000-11-11','','',NULL,'','',NULL,'','',NULL,'','','','','N.H.','','N.H.','MEL','BOS','','','','BOSTON, MA','MEL','','','','MELBOURNE, AUSTRALIA','','AUSTRALIA','','AUSTRALIA','','',NULL,'2000-11-13','',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL.','TEL: 61393354411 FAX:61393352612','','','','','',331.70,0.00,0.00,0.00,0.00,0.00,0.00,0.00,26.75,0.00,358.45,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','MICHELLE O''BRIEN','AS AGENTS','2000-11-09','BILLERICA, MA','K','',0,'I',166,0,1,1,'','','','','','','','',0,5.00,0,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' )"
Local 6: N 1
Local 7: U
Local 8: A Len: 279
Local 9: B {|| ... }
Local 10: A Len: 279
Local 11: A Len: 279
Local 12: C " "
Local 13: U
Local 14: C "( '001','','','','M',0,'HFA-2259M','001 287','','A','E','I','2000-11-09','','HORNI001','HORN INTERNATIONAL FORWARDING.,INC.','44 DUNHAM ROAD','BILLERICA, MA 01821 USA','','','',0,'','',0,'','',0,'',0,'',0,'','BECH-MEL','BECHTRANS INTL PTY, LTD','UNITS 33/34 MIAC BLDING','INTERNATIONAL DRIVE','TULLAMARINE, VICTORIA, 3043','','',0,'','','',0,'',0,'',0,'',0,'','','','','','','','',0,'','',0,'',0,'',0,'',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','HFA-2259','',' #:HFA-2259M','QF','','','','HFA-2259','','081','','','','90150266','','','','','','MEL','','','','','','','USD','P','P','NCV','NCV','NIL','','2000-07-07','','2000-07-07','','7556','2000-11-11','','',NULL,'','',NULL,'','',NULL,'','','','','N.H.','','N.H.','MEL','BOS','','','','BOSTON, MA','MEL','','','','MELBOURNE, AUSTRALIA','','AUSTRALIA','','AUSTRALIA','','',NULL,'2000-11-13','',NULL,'',NULL,'',NULL,'','','PLEASE NOTIFY CONSIGNEE UPON ARRIVAL.','TEL: 61393354411 FAX:61393352612','','','','','',331.70,0.00,0.00,0.00,0.00,0.00,0.00,0.00,26.75,0.00,358.45,0.00,'HORN INTERNATIONAL FORWARDING, INC.','MICHELLE O''BRIEN','MICHELLE O''BRIEN','AS AGENTS','2000-11-09','BILLERICA, MA','K','',0,'I',166,0,1,1,'','','','','','','','',0,5.00,0,'','',0,'','',NULL,'',NULL,'',0,'',NULL,'','',NULL,'',0,NULL,'','','','','','','','','','',NULL,0,'',NULL,'','','','','','','',0,NULL,'','','',NULL,'','','',0.00,'','','','' )"
Local 15: U
Local 16: U
Local 17: C "DBFCDX"
Local 18: L .F.
Local 19: L .F.
Local 20: L .F.
_SQLIMPORT
Param 1: O Class: TSAY
Param 2: O Class: TSAY
Local 1: L .F.
Local 2: C ""
Local 3: O Class: TOLEAUTO
Local 4: U
Local 5: A Len: 182
Local 6: N 1
Local 7: C ""
Local 8: C ""
Local 9: A Len: 0
Local 10: C "winfrt_import.sql"
(b)MAIN
Param 1: O Class: TMENUITEM
TMENU:COMMAND
Param 1: N 20003
Local 1: O Class: TMENU
Local 2: O Class: TMENUITEM
TWINDOW:COMMAND
Param 1: N 20003
Param 2: N 0
Local 1: O Class: TWINDOW
Local 2: N 0
Local 3: N 20003
Local 4: N 0
TWINDOW:HANDLEEVENT
Param 1: N 273
Param 2: N 20003
Param 3: N 0
_FWH
Param 1: N 0
Param 2: N 273
Param 3: N 20003
Param 4: N 0
Param 5: N 1
Local 1: O Class: TWINDOW
WINRUN
Param 1: N 263158
TWINDOW:ACTIVATE
Param 1: C "NORMAL"
Param 2: U
Param 3: U
Param 4: U
Param 5: U
Param 6: U
Param 7: U
Param 8: U
Param 9: U
Param 10: U
Param 11: U
Param 12: U
Param 13: U
Param 14: U
Param 15: U
Param 16: U
Param 17: U
Param 18: U
Param 19: U
Local 1: O Class: TWINDOW
Local 2: U
Local 3: U
MAIN
Local 1: O Class: TSAY
Local 2: O Class: TSAY
Local 3: C "1."
Local 4: C "2."
Local 5: O Class: TFONT
Local 6: O Class: TMENU
Local 7: O Class: TICON

Linked RDDs
===========
DBF
DBFFPT
DBFBLOB
DBFCDX
DBFNTX

DataBases in use
================

1: => SRC RddName: DBFCDX
==============================
RecNo RecCount BOF EOF
126 3945 .F. .F.

Indexes in use TagName

Relations in use

Classes in use:
===============
1 ERROR
2 HASHENTRY
3 HBCLASS
4 HBOBJECT
5 TWINDOW
6 TCONTROL
7 TICON
8 TBRUSH
9 TFONT
10 TMENU
11 TMENUITEM
12 TSAY
13 TMSGBAR
14 TRECT
15 TMSGITEM
16 TTIMER
17 TOLEAUTO
18 TREG32

Memory Analysis
===============
218 Static variables

Dynamic memory consume:
Actual Value: 0 bytes
Highest Value: 0 bytes
*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
User avatar
cdmmaui
 
Posts: 689
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong

Re: DBF to SQL script tool

Postby nageswaragunupudi » Fri Jul 04, 2014 1:10 pm

Single quotes are to be escaped as two single quotes in the sql statement.
Example: O'NEIL should be written as 'O''NEIL'
This appears to be done right.

Can you please send me a DBF containing only this one record? I shall test on my PC ( sqlexpress )

my mail
nageswaragunupudi@gmail.com

Please zip and send.
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10646
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: DBF to SQL script tool

Postby cdmmaui » Sat Jul 05, 2014 4:31 pm

Dear Mr. Rao,

I have sent cdmsql.cdm, please rename to cdmsql.zip. I have included the source, buildx.bat, EXE, error log and air.dbf / air.fpt.

I noticed in the error log there is an extra set of parenthesis.

I received error importing for MS SQL 2008 and MS SQL 2012.

Thanks for your assistance.
*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
User avatar
cdmmaui
 
Posts: 689
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong

Re: DBF to SQL script tool

Postby TimStone » Wed Jul 09, 2014 12:39 am

I see a lot of posts that are fragmented. Each addresses a single issue.

I would like to see a single sample of the following:

1) Connect to a MsSQL server
2) Create a new database
3) Create a new table
4) Append from an existing DBF database.


Perhaps if this was all in one code section, I could move on. I tried pasting together some of the different posts, but it's not working ...

Thanks.

Tim
Tim Stone
http://www.MasterLinkSoftware.com
http://www.autoshopwriter.com
timstone@masterlinksoftware.com
Using: FWH 23.10 with Harbour 3.2.0 / Microsoft Visual Studio Community 2022-24 32/64 bit
User avatar
TimStone
 
Posts: 2944
Joined: Fri Oct 07, 2005 1:45 pm
Location: Trabuco Canyon, CA USA

Re: DBF to SQL script tool

Postby nageswaragunupudi » Wed Jul 09, 2014 5:47 am

This example shows
1. Connect to MS Sql server
2. Create a new Database (Catalog) by name FWH
3. Export c:\fwh\samples\customer.dbf to the Server in the Catalog (database) FWH
4. Open CUSTOMER table and browse.

Code: Select all  Expand view  RUN
#include "fivewin.ch"
#include "adofuncs.ch"

//----------------------------------------------------------------------------//

function Main()

   local oCn, oRs

   //----------------------------------------------------------------------------//
   // Check if Database cInitCat exists on the server
   // and create if does not exist
   //----------------------------------------------------------------------------//

   ? "Connect to Server"
   oCn   := FW_OpenAdoConnection( "MSSQL,SQLEXPRESS,,SA,Secret", .t. )
   if oCn == nil
      ? "Connect Fail"
      QUIT
   endif
   ? "Check and create database " + cInitCat + " if needed"
   oRs   := oCn:OpenSchema( 1, cInitCat )
   if oRs == nil
      ? "Error"
      QUIT
   endif
   if oRs:RecordCount() > 0
      ? "DataBase " + cInitCat + "Exists"
   else
      oCn:Execute( "CREATE DATABASE " + cInitCat )
      ? "Database " + cInitCat + " Created"
   endif
   oRs:Close()
   oCn:Close()

   //----------------------------------------------------------------------------//
   // Connect to the sever / Database, Export Data and Browse exported data
   //----------------------------------------------------------------------------//

   ? "Connect to Server Database " + cInitCat
   oCn   := FW_OpenAdoConnection( "MSSQL,SQLEXPRESS,FWH,SA,Secret", .t. )
   if oCn == nil
      ? "Connect Fail"
      QUIT
   endif

   ? "Importing Customer.dbf"
   FW_AdoImportFromDBF( oCn, "c:\fwh\samples\customer.dbf", "CUSTOMER" )

   ? "Imported. Opening CUSTOMER table on the MSSQL server"
   oRs      := FW_OpenRecordSet( oCn, "CUSTOMER" )
   XBROWSER oRs

   oRs:Close()
   oCn:Close()
   ? "Done"

return nil
 

In the function FW_OpenAdoConnection:
Please replace
SQLEXPRES with your Server name
FWH with the Database name you want
Secret with your password

Next release of FWH includes TRecSet class.
This will be fully compatible with ADO syntax and also TData/TDatabase syntax.
Existing applications will run without any change. Just replace
oRs := TOleAuto():New( "ADODB.RecordSet" )
with
oRs := TRecSet():New()
Advantages are :
a) We can use oRs:Fields( "HireDate" ):Value or oRs:HireDate
b) We need not check if record set is empty before using MoveFirst(), etc.
We can safely use MoveFirst() or GoTop() etc everywhere. Error checking is builtin
c) Field Access and Assign provide for padding/trimming/null values/ and other necessary conversions and error checking. Also takes care of differences between different databases.
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10646
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: DBF to SQL script tool

Postby TimStone » Wed Jul 09, 2014 7:15 pm

Thank you. I modified the .prg and ran it without any problem. I'm now going to add in the rest of my files to see if that works out.

One important note. You stated #include "adofuncs.ch" That file does not exist in the current distribution so I changed it to "adoref.ch" and the build was OK.

I look forward to the next release and to testing the new capabilities.

In another thread, there is discussion on locking / updating issues with databases in a multi-user setting. Do you deal with any of that with your new recordset ?

Tim
Tim Stone
http://www.MasterLinkSoftware.com
http://www.autoshopwriter.com
timstone@masterlinksoftware.com
Using: FWH 23.10 with Harbour 3.2.0 / Microsoft Visual Studio Community 2022-24 32/64 bit
User avatar
TimStone
 
Posts: 2944
Joined: Fri Oct 07, 2005 1:45 pm
Location: Trabuco Canyon, CA USA

Re: DBF to SQL script tool

Postby nageswaragunupudi » Wed Jul 09, 2014 8:06 pm

Sorry. that was adodef.ch.

In another thread, there is discussion on locking / updating issues with databases in a multi-user setting. Do you deal with any of that with your new recordset ?

Mostly we work with optimistic locking. This is automatic. You must be knowing about it in ADS.
We can also use pessimistic locking like in our traditional dbf, but nobody uses it.
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10646
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: DBF to SQL script tool

Postby TimStone » Wed Jul 09, 2014 8:19 pm

Take a look at the comments in the tData / SQL thread I started a couple of days ago. I would like to see you input on the last couple of observations that were made.
Tim Stone
http://www.MasterLinkSoftware.com
http://www.autoshopwriter.com
timstone@masterlinksoftware.com
Using: FWH 23.10 with Harbour 3.2.0 / Microsoft Visual Studio Community 2022-24 32/64 bit
User avatar
TimStone
 
Posts: 2944
Joined: Fri Oct 07, 2005 1:45 pm
Location: Trabuco Canyon, CA USA

Re: DBF to SQL script tool

Postby TimStone » Wed Jul 09, 2014 10:17 pm

Running into a problem with FW_AdoImportFromDBF( ... ) at line 1082 ( FWH 14.06 ) oCn:Execute( cExecSql ).

The problem occurs on files with memo fields.

In the SQL database, the length of that field is defined as 16 by this function. However, there can be many lines in a memo, and certainly far more than 16 characters.

The program fails with an error :
Error description: Error ADODB.Connection/0 S_OK: EXECUTE
Args:
[ 1] = C INSERT INTO [EPRLAB] ( [WRKORD],[WRKDAT],[LABMEC],[LABCOD],[LABDES],[FILNUM],[LABDTM],[LABTIM],[LABRAT],[LABTOT],[COMPLE],[LABTXF],[SUBLET],[LABCST],[LABVEN],[LABEST],[STATUS],[DEPART],[SRVHRS],[PSTPAY],[WRKCOM],[LABTXT] ) VALUES ( '000019','2009-12-15','LEE','BRDBFP','SERVICE FRONT DISK BRAKES',0,0.00,1.25,80.00,100.00,0,0,0,37.50,'',0.00,'I','B',-4.28,0,0,'SERVICE FRONT DISK BRAKES
- Remove old pads and clean caliper housing
- Inspect rotor for scoring / out of round
- Inspect cylinder / boot for leaks and cracks
- Install new disk pads
- Top up master cylinder reservoir
- Perform system check for correct operation by road test
- Run over some broken glass.
' ),( '000019','2011-07-25','LEE','ACPMIN','AIR CONDITIONING INSPECTION',0,0.00,0.75,80.00,60.00,0,0,0,22.50,'',0.00,'I','',0.00,0,0,'AIR CONDITIONING INSPECTION
- Check/adjust drive belts
- Check/clean condenser

( and on for many more lines ).
Tim Stone
http://www.MasterLinkSoftware.com
http://www.autoshopwriter.com
timstone@masterlinksoftware.com
Using: FWH 23.10 with Harbour 3.2.0 / Microsoft Visual Studio Community 2022-24 32/64 bit
User avatar
TimStone
 
Posts: 2944
Joined: Fri Oct 07, 2005 1:45 pm
Location: Trabuco Canyon, CA USA

Re: DBF to SQL script tool

Postby cdmmaui » Thu Jul 10, 2014 1:15 pm

Hi Tim,

Give me your e-mail address and I will send you ADOFUNCS.PRG Mr. Rao updated for me.
*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
User avatar
cdmmaui
 
Posts: 689
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong

PreviousNext

Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 41 guests