Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT DBF
create a foxpro database
J
2006-07-06 05:03:15.0
How can i create a foxpro database using hxtt? For example if i'm using mssql server, i can use statement.executeQuery("CREATE DATABASE databaseName"). Can i use hxtt to create a foxpro database?.
Thanks
Re:create a foxpro database
HXTT Support
2006-07-06 05:11:07.0
HXTT DBF supports to create foxpro free table. You can use CREATE TABLE sql.
For instance,

create table if not exists testABC (number1 int,string1 varchar(20),date1 date,time1 timestamp)

CREATE TABLE states (AREA NUMERIC(12, 3), PERIMETER NUMERIC(12, 3), STATE_ INT, STATE_ID INT, STATE_NAME CHAR(25), STATE_FIPS CHAR(2), SUB_REGION CHAR(7), STATE_ABBR CHAR(2), POP1990 INT, POP90_SQMI NUMERIC(8, 2), HOUSEHOLDS INT, MALES INT, FEMALES INT, WHITE INT, BLACK INT, AMERI_ES INT, ASIAN_PI INT, 'OTHER' INT, HISPANIC INT, AGE_UNDER5 INT, AGE_5_17 INT, AGE_18_64 INT, AGE_65_UP INT, NEVERMARRY INT, MARRIED INT, SEPARATED INT, WIDOWED INT, DIVORCED INT, HSEHLD_1_M INT, HSEHLD_1_F INT, MARHH_CHD INT, MARHH_NO_C INT, MHH_CHILD INT, FHH_CHILD INT, HSE_UNITS INT, VACANT INT, OWNER_OCC INT, RENTER_OCC INT, MEDIAN_VAL INT, MEDIANRENT INT, UNITS_1DET INT, UNITS_1ATT INT, UNITS2 INT, UNITS3_9 INT, UNITS10_49 INT, UNITS50_UP INT, MOBILEHOME INT, NO_FARMS87 INT, AVG_SIZE87 INT, CROP_ACR87 INT, AVG_SALE87 INT)

create table if not exists product1 (MODEL_NO varchar(20), MODEL_NM varchar(30), DIGIT8_CD int, COUNTRY_CD varchar(10), CATE_CD varchar(10), GENRE_CD varchar(20), FACTORY_CD varchar(20), UOM_CD varchar(20), RELEASE_DT date, JAPAN_SRP int, APPROVE_NO varchar(20), BAN boolean, DISCONT boolean, BEST boolean, PKG_REMARK varchar(20), REMARK1 varchar(30), REMARK2 varchar(30), INTERFACE boolean, currency1 OTHER (Currency),mem1 blob)

The default table type is VFP free table, you can use versionNumber connection property to create other type table. "30"(Visual FoxPro 3.0~9.0), "02"(FoxBase, dBASE II), "03"(dBASE III), "83", "04"(dBASE IV), "05"(dBASE V), "F5"(FoxPro),"8B", "8E", "7B", or "DB2K"(dbase 2000).


Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap