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
|
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).
|
Main
webmaster@hxtt.com