-
Notifications
You must be signed in to change notification settings - Fork 2
Open
Description
these are master-detail codes:
those relations fields only B2_DESC = :B2_DESC dose work.
otheres B2_SPEC = :B2_SPEC and B3_GRD = :B3_GRD and B3_SZE = :B3_SZE do not
work.
xQuery := TxQuery.Create(nil);
with xQuery do
begin
DataSource := MasterSrc;
AddDataSet(C3, 'C3');
cSQL := ' select * from C3 ';
cWhere := ' where B2_DESC = :B2_DESC and B2_SPEC = :B2_SPEC and B3_GRD = :B3_GRD and B3_SZE = :B3_SZE ';
cOrder := ' Order by B2_DESC, B2_SPEC, B3_GRD, B3_SZE ';
cSQL := cSQL + cWhere + cOrder ;
SQL.SetText(PChar(cSQL));
Open;
end;
delphi 2006 winxp.
Original issue reported on code.google.com by t...@ms9.url.com.tw on 7 Jun 2013 at 3:36