adoquery1.SQL.Clear;
adoquery1.SQL.Add('create table ncord(c_mid varchar(8) primary key not null,'
+'c_pay float unsigned not null,c_dou float unsigned not null,'
+'c_leve varchar(4),c_name varchar(12),'
+'c_bm varchar(8),c_job varchar(12))');
adoquery1.ExecSQL;
adoquery1.SQL.Add('create table ncord(c_mid varchar(8) primary key not null,'
+'c_pay float unsigned not null,c_dou float unsigned not null,'
+'c_leve varchar(4),c_name varchar(12),'
+'c_bm varchar(8),c_job varchar(12))');
adoquery1.ExecSQL;
+'c_pay float unsigned not null,c_dou float unsigned not null,'
+'c_leve varchar(4),c_name varchar(12),'
+'c_bm varchar(8),c_job varchar(12))';
adoquery1.ExecSQL;
------------------------
ADOQuery1这个SQL属性是TStrings类型,用Add方法会视逗号','为分割符.
float(9,2)这样就好了..