procedure TfrmProSelect.CheckBoxTypeClick(Sender: TObject);
begin
if CheckBoxType.Checked then
begin
DBLookupComboBox1.Enabled:=false;
datamodule2.Q_Product2.Close;
datamodule2.Q_Product2.Parameters[0].Value:=DBCBoxProType.Text;
datamodule2.Q_Product2.Open;
dbgrid1.DataSource:=datamodule2.DS_Product2;
dbgrid1.Columns[0].FieldName:=datamodule2.Q_Product2.DataSource.DataSet.FieldValues['品名'];
dbgrid1.Columns[1].FieldName:=datamodule2.Q_Product2.DataSource.DataSet.FieldValues['生产厂家'];
dbgrid1.Columns[2].FieldName:=datamodule2.Q_Product2.DataSource.DataSet.FieldValues['所属类别'];
dbgrid1.Columns[3].FieldName:=datamodule2.Q_Product2.DataSource.DataSet.FieldValues['库存量'];
dbgrid1.Refresh;
end
else
begin
DBLookupComboBox1.Enabled:=true;
datamodule2.Q_Product1.Close;
datamodule2.Q_Product1.Parameters[0].Value:=DBLookupComboBox1.Text;
datamodule2.Q_Product1.Open;
dbgrid1.DataSource:=datamodule2.DS_Product1;
dbgrid1.DataSource:=datamodule2.DS_Product2;
dbgrid1.Columns[0].FieldName:=datamodule2.Q_Product1.DataSource.DataSet.FieldValues['品名'];
dbgrid1.Columns[1].FieldName:=datamodule2.Q_Product1.DataSource.DataSet.FieldValues['生产厂家'];
dbgrid1.Columns[2].FieldName:=datamodule2.Q_Product1.DataSource.DataSet.FieldValues['所属类别'];
dbgrid1.Columns[3].FieldName:=datamodule2.Q_Product1.DataSource.DataSet.FieldValues['库存量'];
dbgrid1.Refresh;
end;
end;
begin
if CheckBoxType.Checked then
begin
DBLookupComboBox1.Enabled:=false;
datamodule2.Q_Product2.Close;
datamodule2.Q_Product2.Parameters[0].Value:=DBCBoxProType.Text;
datamodule2.Q_Product2.Open;
dbgrid1.DataSource:=datamodule2.DS_Product2;
dbgrid1.Columns[0].FieldName:=datamodule2.Q_Product2.DataSource.DataSet.FieldValues['品名'];
dbgrid1.Columns[1].FieldName:=datamodule2.Q_Product2.DataSource.DataSet.FieldValues['生产厂家'];
dbgrid1.Columns[2].FieldName:=datamodule2.Q_Product2.DataSource.DataSet.FieldValues['所属类别'];
dbgrid1.Columns[3].FieldName:=datamodule2.Q_Product2.DataSource.DataSet.FieldValues['库存量'];
dbgrid1.Refresh;
end
else
begin
DBLookupComboBox1.Enabled:=true;
datamodule2.Q_Product1.Close;
datamodule2.Q_Product1.Parameters[0].Value:=DBLookupComboBox1.Text;
datamodule2.Q_Product1.Open;
dbgrid1.DataSource:=datamodule2.DS_Product1;
dbgrid1.DataSource:=datamodule2.DS_Product2;
dbgrid1.Columns[0].FieldName:=datamodule2.Q_Product1.DataSource.DataSet.FieldValues['品名'];
dbgrid1.Columns[1].FieldName:=datamodule2.Q_Product1.DataSource.DataSet.FieldValues['生产厂家'];
dbgrid1.Columns[2].FieldName:=datamodule2.Q_Product1.DataSource.DataSet.FieldValues['所属类别'];
dbgrid1.Columns[3].FieldName:=datamodule2.Q_Product1.DataSource.DataSet.FieldValues['库存量'];
dbgrid1.Refresh;
end;
end;
.FieldName:=.FieldValues['品名'];
dbgrid1.Columns[0].FieldName:='品名';试试。
如果要改,该怎么改呢?我还试过].FieldName:=datamodule2.Q_Product1.FieldValues['品名'].asstirng;的形式,但还是这个毛病
Feilds[1].AsXXXX看看这样用数字行不行,我估计是数据有问题,你先尝试一下