Question

下面语句提示“定义字段语法错误”，到底是哪里出问题了

q.sql.clear;
q.sql.add('CREATE TABLE JHD1 (DJBH TEXT(50) NULL ,DWBH TEXT(50) NULL ,DWMC TEXT(50) NULL,');
q.sql.add('CZY TEXT(50) NULL, RQ Date NULL, BZ TEXT(250) NULL, JSJE Double NULL, feiyong TEXT(50) NULL ,');
q.sql.add('feiyongje Double NULL,huoyun TEXT(50) NULL ,huoyunje Double NULL,ckbhckmc TEXT(50) NULL ,fph TEXT(50) NULL ,');
q.sql.add('fanchong YesNo NULL DEFAULT FALSE,wcbz fanchong YesNo NULL DEFAULT FALSE,cwcount Integer NULL,djlx TEXT(50) NULL )');
q.execsql;
wcbz fanchong 我黏贴的时候错了

Answer 1

q.sql.add('CREATE TABLE JHD1 (DJBH TEXT(50) NULL ,DWBH TEXT(50) NULL ,DWMC TEXT(50) NULL,');
做后一个字段不加逗号‘，’
q.sql.add('CREATE TABLE JHD1 (DJBH TEXT(50) NULL ,DWBH TEXT(50) NULL ,DWMC TEXT(50) NULL');