AdqPublic.Close;
AdqPublic.SQL.Clear;
AdqPublic.SQL.Add(' select * from DCheckLabel2 where model= ');
AdqPublic.SQL.Add(' (select bc_model+'''+' '+'''+substring(bc_part_no,11,2) as model from ');
AdqPublic.SQL.Add(' (select bc_model,bc_part_no from dbcticket where bc_no='''+ BcNo+''')a )');
AdqPublic.Open;
AdqPublic.SQL.Clear;
AdqPublic.SQL.Add(' select * from DCheckLabel2 where model= ');
AdqPublic.SQL.Add(' (select bc_model+'''+' '+'''+substring(bc_part_no,11,2) as model from ');
AdqPublic.SQL.Add(' (select bc_model,bc_part_no from dbcticket where bc_no='''+ BcNo+''')a )');
AdqPublic.Open;
把 以下代码放到AdqPublic.Open之前跟踪下str不就得了
str:=' select * from DCheckLabel2 where model= ';
str:=str+' (select bc_model+'''+' '+'''+substring(bc_part_no,11,2) as model from ';
str:=str+' (select bc_model,bc_part_no from dbcticket where bc_no='''+ BcNo+''')a )'
我想知道的是其中的+号的意思 还有 11,2是什么意思