Re: DBF to SQL script tool
![Post Post](./styles/prosilver/imageset/icon_post_target.gif)
Posted:
Fri Jun 27, 2014 4:00 am
by cdmmaui
Mr. Rao,
I am having a problem with script. The function is return the following SQL script. However, the syntax is not correct for MS SQL, `ID` should be [ID]. I see a function (FW_RDBMSName)is called to determine DBMS type but it does not seem to be working. Can you tell me what I am doing wrong?
CREATE TABLE `air` ( `ID` INT AUTO_INCREMENT PRIMARY KEY, `COMPANY` VARCHAR ( 3 ), `QUOTENO` VARCHAR ( 15 ), `STATION` VARCHAR ( 3 ), `DSTSTAT` VARCHAR ( 3 ), `HSE` VARCHAR ( 1 ), `HOUSE` BIT DEFAULT 0, `FILE` VARCHAR ( 20 ), `SERIAL` VARCHAR ( 10 ), `BOOKNO` VARCHAR ( 20 ), `MODE` VARCHAR ( 1 ), `TRANS` VARCHAR ( 1 ), `MOVE` VARCHAR ( 1 ), `DATE` DATE, `STATUS` VARCHAR ( 1 ), `SHIPID` VARCHAR ( 10 ), `SHIPNAME` VARCHAR ( 50 ), `SHIPADD1` VARCHAR ( 50 ), `SHIPADD2` VARCHAR ( 50 ), `SHIPADD3` VARCHAR ( 50 ), `SHIPCITY` VARCHAR ( 50 ), `SHIPST` VARCHAR ( 5 ), `SHIPSTE` BIT DEFAULT 0, `SHIPZIP` VARCHAR ( 10 ), `SHIPISO` VARCHAR ( 2 ), `SHIPISOP` BIT DEFAULT 0, `REFERENCE` VARCHAR ( 35 ), `SHIPCONT` VARCHAR ( 35 ), `SHIPCONTP` BIT DEFAULT 0, `SHIPPH` VARCHAR ( 20 ), `SHIPPHP` BIT DEFAULT 0, `SHIPFAX` VARCHAR ( 20 ), `SHIPFAXP` BIT DEFAULT 0, `SHIPREP` VARCHAR ( 10 ), `CONSID` VARCHAR ( 10 ), `CONSNAME` VARCHAR ( 50 ), `CONSADD1` VARCHAR ( 50 ), `CONSADD2` VARCHAR ( 50 ), `CONSADD3` VARCHAR ( 50 ), `CONSCITY` VARCHAR ( 50 ), `CONSST` VARCHAR ( 5 ), `CONSSTE` BIT DEFAULT 0, `CONSZIP` VARCHAR ( 10 ), `CONSREF` VARCHAR ( 35 ), `CONSISO` VARCHAR ( 2 ), `CONSISOP` BIT DEFAULT 0, `CONSCONT` VARCHAR ( 35 ), `CONSCONTP` BIT DEFAULT 0, `CONSPH` VARCHAR ( 20 ), `CONSPHP` BIT DEFAULT 0, `CONSFAX` VARCHAR ( 20 ), `CONSFAXP` BIT DEFAULT 0, `CONSREP` VARCHAR ( 10 ), `NOTIID` VARCHAR ( 10 ), `NOTINAME` VARCHAR ( 50 ), `NOTIADD1` VARCHAR ( 50 ), `NOTIADD2` VARCHAR ( 50 ), `NOTIADD3` VARCHAR ( 50 ), `NOTICITY` VARCHAR ( 50 ), `NOTIST` VARCHAR ( 5 ), `NOTISTE` BIT DEFAULT 0, `NOTIZIP` VARCHAR ( 10 ), `NOTIISO` VARCHAR ( 2 ), `NOTIISOP` BIT DEFAULT 0, `NOTICONT` VARCHAR ( 30 ), `NOTICONTP` BIT DEFAULT 0, `NOTIPH` VARCHAR ( 20 ), `NOTIPHP` BIT DEFAULT 0, `NOTIFAX` VARCHAR ( 20 ), `NOTIFAXP` BIT DEFAULT 0, `PICKID` VARCHAR ( 10 ), `PICKNAME` VARCHAR ( 50 ), `PICKADD1` VARCHAR ( 50 ), `PICKADD2` VARCHAR ( 50 ), `PICKADD3` VARCHAR ( 50 ), `PICKCITY` VARCHAR ( 50 ), `PICKST` VARCHAR ( 5 ), `PICKZIP` VARCHAR ( 10 ), `PICKCONT` VARCHAR ( 30 ), `PICKPH` VARCHAR ( 20 ), `PICKFAX` VARCHAR ( 20 ), `DESTID` VARCHAR ( 10 ), `DESTNAME` VARCHAR ( 50 ), `DESTADD1` VARCHAR ( 50 ), `DESTADD2` VARCHAR ( 50 ), `DESTADD3` VARCHAR ( 50 ), `DESTCITY` VARCHAR ( 50 ), `DESTST` VARCHAR ( 5 ), `DESTZIP` VARCHAR ( 10 ), `DESTCONT` VARCHAR ( 30 ), `DESTPH` VARCHAR ( 20 ), `DESTFAX` VARCHAR ( 20 ), `ACCTID` VARCHAR ( 10 ), `ACCT01` VARCHAR ( 50 ), `ACCT02` VARCHAR ( 50 ), `ACCT03` VARCHAR ( 50 ), `ACCT04` VARCHAR ( 50 ), `ACCT05` VARCHAR ( 50 ), `ACCT06` VARCHAR ( 50 ), `ACCT07` VARCHAR ( 50 ), `ACCT08` VARCHAR ( 50 ), `EXREF01` VARCHAR ( 45 ), `EXREF02` VARCHAR ( 45 ), `EXREF03` VARCHAR ( 45 ), `CARRIER` VARCHAR ( 20 ), `CARRIER2` VARCHAR ( 20 ), `CARRIER3` VARCHAR ( 20 ), `CARRIER4` VARCHAR ( 20 ), `MANIFEST` VARCHAR ( 20 ), `SUBMAN` VARCHAR ( 20 ), `PFX` VARCHAR ( 3 ), `PFX02` VARCHAR ( 3 ), `PFX03` VARCHAR ( 3 ), `PFX04` VARCHAR ( 3 ), `MBILL` VARCHAR ( 20 ), `MBILL2` VARCHAR ( 20 ), `MBILL3` VARCHAR ( 20 ), `MBILL4` VARCHAR ( 20 ), `HBILL` VARCHAR ( 20 ), `BOOKING` VARCHAR ( 20 ), `TO01` VARCHAR ( 4 ), `TO02` VARCHAR ( 4 ), `BY02` VARCHAR ( 3 ), `TO03` VARCHAR ( 4 ), `BY03` VARCHAR ( 3 ), `TO04` VARCHAR ( 4 ), `BY04` VARCHAR ( 4 ), `CURRENCY` VARCHAR ( 10 ), `WTVAL` VARCHAR ( 1 ), `OTHER` VARCHAR ( 1 ), `CARVAL` VARCHAR ( 15 ), `CUSVAL` VARCHAR ( 15 ), `INSVAL` VARCHAR ( 15 ), `AIRMIN` VARCHAR ( 1 ), `PICKDATE` DATE, `PICKTIME` VARCHAR ( 10 ), `DELVDATE` DATE, `DELVTIME` VARCHAR ( 10 ), `FLT01` VARCHAR ( 10 ), `DTE01` DATE, `TME01` VARCHAR ( 5 ), `FLT02` VARCHAR ( 10 ), `DTE02` DATE, `TME02` VARCHAR ( 5 ), `FLT03` VARCHAR ( 10 ), `DTE03` DATE, `TME03` VARCHAR ( 5 ), `FLT04` VARCHAR ( 10 ), `DTE04` DATE, `TME04` VARCHAR ( 5 ), `PRECARRID` VARCHAR ( 10 ), `PRECARR` VARCHAR ( 50 ), `PRCODE` VARCHAR ( 3 ), `PLACEREC` VARCHAR ( 50 ), `ORCODE` VARCHAR ( 3 ), `ORIGIN` VARCHAR ( 50 ), `CONSOL` VARCHAR ( 3 ), `POL` VARCHAR ( 3 ), `POL02` VARCHAR ( 3 ), `POL03` VARCHAR ( 3 ), `POL04` VARCHAR ( 3 ), `PORTLOAD` VARCHAR ( 50 ), `POUL` VARCHAR ( 3 ), `POUL02` VARCHAR ( 3 ), `POUL03` VARCHAR ( 3 ), `POUL04` VARCHAR ( 3 ), `PORTDISC` VARCHAR ( 50 ), `PDCODE` VARCHAR ( 3 ), `PLACEDEL` VARCHAR ( 50 ), `ULCODE` VARCHAR ( 3 ), `ULTIMATE` VARCHAR ( 50 ), `SERVICE` VARCHAR ( 20 ), `PRIORITY` VARCHAR ( 1 ), `DEPART` DATE, `ETA` DATE, `ETATIME` VARCHAR ( 8 ), `ETA02` DATE, `ETATIME2` VARCHAR ( 8 ), `ETA03` DATE, `ETATIME3` VARCHAR ( 8 ), `ETA04` DATE, `ETATIME4` VARCHAR ( 8 ), `HSECAR` VARCHAR ( 10 ), `HANDLE01` VARCHAR ( 105 ), `HANDLE02` VARCHAR ( 105 ), `HANDLE03` VARCHAR ( 105 ), `DELV01` VARCHAR ( 75 ), `DELV02` VARCHAR ( 75 ), `DELV03` VARCHAR ( 75 ), `RATEID` VARCHAR ( 15 ), `WTPPD` DECIMAL( 15, 2 ), `WTCOL` DECIMAL( 15, 2 ), `VCPPD` DECIMAL( 15, 2 ), `VCCOL` DECIMAL( 15, 2 ), `TXPPD` DECIMAL( 15, 2 ), `TXCOL` DECIMAL( 15, 2 ), `DAPPD` DECIMAL( 15, 2 ), `DACOL` DECIMAL( 15, 2 ), `DCPPD` DECIMAL( 15, 2 ), `DCCOL` DECIMAL( 15, 2 ), `TOTPPD` DECIMAL( 15, 2 ), `TOTCOL` DECIMAL( 15, 2 ), `WBLINE01` VARCHAR ( 125 ), `WBLINE02` VARCHAR ( 125 ), `WBLINE03` VARCHAR ( 125 ), `WBLINE04` VARCHAR ( 125 ), `ISSDATE` DATE, `ISSPLACE` VARCHAR ( 30 ), `WTCODE` VARCHAR ( 1 ), `OFFICIAL` VARCHAR ( 15 ), `INVCNT` BIGINT, `INCH` VARCHAR ( 1 ), `DIMFACT` BIGINT, `DIMWT` BIGINT, `ZONEF` TINYINT, `ZONET` TINYINT, `ZF01` VARCHAR ( 1 ), `ZF02` VARCHAR ( 1 ), `ZF03` VARCHAR ( 1 ), `ZF04` VARCHAR ( 1 ), `ZT01` VARCHAR ( 1 ), `ZT02` VARCHAR ( 1 ), `ZT03` VARCHAR ( 1 ), `ZT04` VARCHAR ( 1 ), `AIRCOMM` BIT DEFAULT 0, `AIRPERCENT` DECIMAL( 11, 2 ), `BILLABLE` BIT DEFAULT 0, `READY` VARCHAR ( 5 ), `CLOSE` VARCHAR ( 5 ), `TRANSMIT` BIT DEFAULT 0, `AWBM` VARCHAR ( 30 ), `ADDBY` VARCHAR ( 20 ), `ADDDATE` DATE, `LASTUSER` VARCHAR ( 20 ), `LASTDATE` DATE, `LASTTIME` VARCHAR ( 8 ), `SITA` BIT DEFAULT 0, `SITAFLAG` VARCHAR ( 1 ), `SITADATE` DATE, `SITATIME` VARCHAR ( 4 ), `SITACODE` VARCHAR ( 3 ), `SITALDATE` DATE, `SITALTIME` VARCHAR ( 4 ), `CLOSED` BIT DEFAULT 0, `CLOSEDATE` DATE, `CLOSETIME` VARCHAR ( 5 ), `CLOSEUSER` VARCHAR ( 15 ), `CUSTID` VARCHAR ( 10 ), `CUSTNAME` VARCHAR ( 45 ), `CUSTREP` VARCHAR ( 10 ), `COONAME` VARCHAR ( 75 ), `COOCOUNTRY` VARCHAR ( 75 ), `COOBODY` TEXT, `DOCKBODY` TEXT, `REP` VARCHAR ( 10 ), `ACTUAL` DATE, `INVOICED` BIT DEFAULT 0, `INVOICE` VARCHAR ( 20 ), `INVDATE` DATE, `INVUSER` VARCHAR ( 15 ), `TRADELANE` VARCHAR ( 10 ), `CUSTOM01` VARCHAR ( 20 ), `CUSTOM02` VARCHAR ( 20 ), `CUSTOM03` VARCHAR ( 20 ), `CUSTOM04` VARCHAR ( 20 ), `CUSTOM05` VARCHAR ( 20 ), `BLDIVER` BIT DEFAULT 0, `FWBDATE` DATE, `FWBTIME` VARCHAR ( 8 ), `FWBUSER` VARCHAR ( 15 ), `FWBNO` VARCHAR ( 10 ), `FHLDATE` DATE, `FHLTIME` VARCHAR ( 8 ), `FHLUSER` VARCHAR ( 15 ), `FHLNO` VARCHAR ( 10 ), `ESTREVENUE` DECIMAL( 13, 2 ), `UNKNOWN` VARCHAR ( 75 ), `ITEM1` VARCHAR ( 75 ), `ITEM2` VARCHAR ( 75 ), `ITEM3` VARCHAR ( 75 ) )