|
|
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)
HXTT DBF
|
SQLException: Syntax error on CREATE TABLE statement |
Natalie Tzukrel |
2018-02-18 05:27:49 |
Hello.
I am using the demo version of com.hxtt.sql.dbf.DBFDriver.
I am trying to create a DBF table with the sql statement:
"CREATE TABLE DATA_PENSIONERS_DBF_TEMP (recordno int(10) NOT NULL , KlatimKey int(10) NOT NULL , valn_date char(6) NOT NULL , idno char(18) NOT NULL , Mn char(18) NOT NULL , fund char(10) , idnoKey char(19) NOT NULL , "GROUP" char(20) , mgtfee_ann char(22) , gender char(1) , sug_pnsn char(25) , sug_pnsnr char(9) , dob_1 char(18) , netopay char(22) , dpw char(22) , date_end_p char(18) , gender_2 char(1) , dob_2 char(18) , marital_st char(9) , spouse_pc char(15) , guar_p char(9) , date_ret char(18) , accrued_ba char(22) , sal_kov_di char(22) , sherim_pct char(15) , widow_pct char(15) , guar_p_she char(9) , age_ret char(9) , mth_res_tr char(18) , netpay_pod char(22) , date_pod char(18) , dis_pct char(15) , fund_inv char(9) , gender_3 char(1) , dob_3 char(18) , orphan_pc char(15) , product char(25) , cover_sts char(25) , qod_incl char(1) )"
and get the next error:
java.sql.SQLException: Syntax error: Stopped parse at ((id16)
at com.hxtt.b.am.a(Unknown Source) ~[DBF_JDBC42.jar:na]
at com.hxtt.a.b.a(Unknown Source) ~[DBF_JDBC42.jar:na]
at com.hxtt.a.b.a(Unknown Source) ~[DBF_JDBC42.jar:na]
at com.hxtt.a.b.g(Unknown Source) ~[DBF_JDBC42.jar:na]
at com.hxtt.sql.b0.I(Unknown Source) ~[DBF_JDBC42.jar:na]
at com.hxtt.sql.b0.int(Unknown Source) ~[DBF_JDBC42.jar:na]
at com.hxtt.sql.an.a(Unknown Source) ~[DBF_JDBC42.jar:na]
at com.hxtt.sql.an.if(Unknown Source) ~[DBF_JDBC42.jar:na]
at com.hxtt.sql.an.executeUpdate(Unknown Source) ~[DBF_JDBC42.jar:na]
on executeUpdate(createStmt);
What is wrong? What can i do?
|
Re:SQLException: Syntax error on CREATE TABLE statement |
HXTT Support |
2018-02-18 05:59:51 |
> int(10)
It should be int.
CREATE TABLE DATA_PENSIONERS_DBF_TEMP (recordno int NOT NULL , KlatimKey int NOT NULL , valn_date char(6) NOT NULL , idno char(18) NOT NULL , Mn char(18) NOT NULL , fund char(10) , idnoKey char(19) NOT NULL , "GROUP" char(20) , mgtfee_ann char(22) , gender char(1) , sug_pnsn char(25) , sug_pnsnr char(9) , dob_1 char(18) , netopay char(22) , dpw char(22) , date_end_p char(18) , gender_2 char(1) , dob_2 char(18) , marital_st char(9) , spouse_pc char(15) , guar_p char(9) , date_ret char(18) , accrued_ba char(22) , sal_kov_di char(22) , sherim_pct char(15) , widow_pct char(15) , guar_p_she char(9) , age_ret char(9) , mth_res_tr char(18) , netpay_pod char(22) , date_pod char(18) , dis_pct char(15) , fund_inv char(9) , gender_3 char(1) , dob_3 char(18) , orphan_pc char(15) , product char(25) , cover_sts char(25) , qod_incl char(1) )"
|
|
|
Main
webmaster@hxtt.com