我怎么向一个建好的表CustInfo.db增加字段呢?表CustInfo.db是delphi自带数据库类型的表。
帮我看一下,这样写对吗?
var
ziduan :string ;
tablename :string;
begin
tablename:='D:\delphi-ceshi\CustInfo.db';
ziduan:='alter table '+tablename+' add strName char(10) not null' ;
showmessage(ziduan);
table1.close;
query1.close;
query1.sql.clear;
//query1.SQL.CommaText:=ziduan;
query1.sql.add(ziduan); //try
//query1.open;
//except
query1.execsql;
//end;
//table1.open;
end;
帮我看一下,这样写对吗?
var
ziduan :string ;
tablename :string;
begin
tablename:='D:\delphi-ceshi\CustInfo.db';
ziduan:='alter table '+tablename+' add strName char(10) not null' ;
showmessage(ziduan);
table1.close;
query1.close;
query1.sql.clear;
//query1.SQL.CommaText:=ziduan;
query1.sql.add(ziduan); //try
//query1.open;
//except
query1.execsql;
//end;
//table1.open;
end;
add column a int
Project Project1.ext raised exception class EDBEngineError with message 'Invalid use of keyword '