procedure TCreateDataBaseFrm.Createjxinfwh; var SQL_Str : String; begin SQL_Str := 'CREATE TABLE thrjxinfwh('+ 'ID int IDENTITY (10001, 1) NOT FOR REPLICATION NOT NULL , '+ 'thrname char(20) NULL,thrcode Char(20) NULL,sfbzr char(2) NULL,ksf Int NULL,'+ 'xqpj Varchar(100) NULL,tsqk Varchar(200) NULL,tbrq SmallDateTime NULL ) '; Try DataModuleFrm.xyglxtADOConnection.Connected := True; with DataModuleFrm.CreateDataBaseADOQuery do begin if Active then Active := False; SQL.Clear; SQL.Add(SQL_Str); ExecSQL; end; Except end; end;
classtime 类型,
)
var
SQL_Str : String;
begin
SQL_Str := 'CREATE TABLE thrjxinfwh('+
'ID int IDENTITY (10001, 1) NOT FOR REPLICATION NOT NULL , '+
'thrname char(20) NULL,thrcode Char(20) NULL,sfbzr char(2) NULL,ksf Int NULL,'+
'xqpj Varchar(100) NULL,tsqk Varchar(200) NULL,tbrq SmallDateTime NULL ) ';
Try
DataModuleFrm.xyglxtADOConnection.Connected := True;
with DataModuleFrm.CreateDataBaseADOQuery do
begin
if Active then
Active := False;
SQL.Clear;
SQL.Add(SQL_Str);
ExecSQL;
end;
Except
end;
end;