exsample:procedure TfrmMain.CreateNewTable(const strTableName: string;
var NewTable : TTable);
var
i : Integer;
begin
NewTable := TTable.Create(self);
with NewTable do
begin
Active := false;
DataBaseName := 'MyDataBase';
TableType := ttDefault;
TableName := strTableName; if not NewTable.Exists then
begin
with FieldDefs do
begin
Clear;
with AddFieldDef do
begin
Name := 'TreatID';
DataType := ftInteger;
Required := True;
end;
with AddFieldDef do
begin
Name := 'Time';
DataType := ftInteger;
Required := True;
end;
for i := 0 to High(cnTemps) do
with AddFieldDef do
begin
Name := cnTemps[i];
DataType := ftFloat;
Required := true;
end;
end;
CreateTable;
end;
Close();
end;
end;
var NewTable : TTable);
var
i : Integer;
begin
NewTable := TTable.Create(self);
with NewTable do
begin
Active := false;
DataBaseName := 'MyDataBase';
TableType := ttDefault;
TableName := strTableName; if not NewTable.Exists then
begin
with FieldDefs do
begin
Clear;
with AddFieldDef do
begin
Name := 'TreatID';
DataType := ftInteger;
Required := True;
end;
with AddFieldDef do
begin
Name := 'Time';
DataType := ftInteger;
Required := True;
end;
for i := 0 to High(cnTemps) do
with AddFieldDef do
begin
Name := cnTemps[i];
DataType := ftFloat;
Required := true;
end;
end;
CreateTable;
end;
Close();
end;
end;
解决方案 »
- 子窗口修改父窗口
- FastReport4forCodeGearRADStudioDelphiCBuilder2009.exe 安装出错,如何处理?
- 求教 关于delphi软件日期保护的问题。如何维护软件开发者的权益?
- dbedit
- 在 弹出新窗口后怎么处理cookie?
- 如何在程序中设置某个字段的默认值Access 2000?对于字符串型的允许空字符串?
- 请问如何获得给定值(@a , @b , ...)的最大值(存储过程中)
- 怎样用delphi编程,读取dwg文件中的图签的内容.
- 急为什么连不上CORBA server?
- 关于ADODataSet的cursorType 属性设置
- ADO 组件查询
- 请问nmsmtp:=TNMSMTP(NMSMTP)在执行中为何报错?在线等,谢谢
into table2
from table1 a
where ...
TABLE是建好了,要添加记录是件难事
TABLE1
Date |Money | SUM_ID
-------------------------
2002-06-25 | 2000 | A0001
2002-06-25 | 3000 | A0002
2002-06-25 | 4000 | A0003
2002-06-26 | 5000 | A0001
2002-06-27 | 2000 | A0002TABLE2
-------------------------------
2002-06-25 | 2000 | 3000 | 4000
2002-06-26 | 5000 | |
2002-06-27 | | 2000 |