我用如下代码建立了一个临时表
self.DS := tclientdataset.Create(nil);
self.DS.FieldDefs.Add('No',ftAutoInc);
self.DS.FieldDefs.Add('ProductID',ftString,20);
self.DS.FieldDefs.Add('Name',ftstring,40);
self.DS.FieldDefs.Add('Price',ftCurrency);
self.DS.FieldDefs.Add('Total',ftsmallint);
self.DS.FieldDefs.Add('Discount',ftsmallint);
self.DS.FieldDefs.Add('Money',ftCurrency);
self.DS.IndexDefs.Add('No','No',[ixPrimary]);
self.DS.CreateDataSet;
self.dataTemp.DataSet := self.DS;
self.DS.Open;我想对 Price, Total, Discount, Money 设置默认值及取值范围,该在哪里 添加什么语句?
self.DS := tclientdataset.Create(nil);
self.DS.FieldDefs.Add('No',ftAutoInc);
self.DS.FieldDefs.Add('ProductID',ftString,20);
self.DS.FieldDefs.Add('Name',ftstring,40);
self.DS.FieldDefs.Add('Price',ftCurrency);
self.DS.FieldDefs.Add('Total',ftsmallint);
self.DS.FieldDefs.Add('Discount',ftsmallint);
self.DS.FieldDefs.Add('Money',ftCurrency);
self.DS.IndexDefs.Add('No','No',[ixPrimary]);
self.DS.CreateDataSet;
self.dataTemp.DataSet := self.DS;
self.DS.Open;我想对 Price, Total, Discount, Money 设置默认值及取值范围,该在哪里 添加什么语句?
begin
with FieldDefs.AddFieldDef do
begin
DataType := ftBoolean;
Name := 'CheckB';
end;
with FieldDefs.AddFieldDef do
begin
DataType := ftString;
Size := 20;
Name := 'WareName';
end;
with FieldDefs.AddFieldDef do
begin
DataType := ftCurrency;
Name := 'UnitPrice';
end;
with FieldDefs.AddFieldDef do
begin
DataType :=ftFloat;
Name := 'Quantity';
end;
with FieldDefs.AddFieldDef do
begin
DataType := ftString;
Size :=15 ;
Name := 'ProductPlace';
end;
end;
取值范围在 CDS 的 BeforePost 中设置