关于Master/detail 的一个简单问题
sql.add(' select ordinal as 编码,total as 价值,manufacturer as 供应 商,operator as 操作人,op_datetime as 入库时间,beizhu as 备注 from goods_in where op_datetime>=:date_from and op_datetime<=:date_to and ordinal like ''i%'' order by ordinal');
parameters.ParamByName('date_from').Value:=datetostr(DateTimePicker1.date);
parameters.ParamByName('date_to').Value:=datetostr(DateTimePicker2.date);
open;
data.tbGoods_info.MasterSource:=dsInfo;
//data.tbGoods_info.IndexName:='ordinal'; //子表要有索引
data.tbGoods_info.MasterFields:='ordinal';
DBGrid2.DataSource:=data.dsGoods_info;
data.tbGoods_info.Open;
总是报错:
QueryInfo:Field 'ordinal' not found
错在哪里??