delphi中报错,大家办我看看

来源:百度知道 编辑:UC知道 时间:2024/05/10 06:06:25
是循环执行的语句,看看引号的错误,老报有没有关闭的引号

if (CustomerData.ADOQuery1.fieldbyna('MaterialType').asstring='')and (CustomerData.ADOQuery1.fieldbyname('MaterialSpec').asstring<>'') then
begin
CustomerData.ADOQuery2.SQL.Add('SELECT * from TBS_Material where materialid like '+''''+'07'+'%'+''''+' and (MaterialType='+''''+''+''''+' or MaterialType is null) and MaterialSpec='+''''+CustomerData.ADOQuery1.fieldbyname('MaterialSpec').asstring+'''');
end;

if (CustomerData.ADOQuery1.fieldbyname('MaterialType').asstring<>'') and (CustomerData.ADOQuery1.fieldbyname('MaterialSpec').asstring='') then
begin
CustomerData.ADOQuery2.SQL.Add('SELECT * from TBS_Material where materialid like '+''

CustomerData.ADOQuery2.SQL.Add('SELECT * from TBS_Material where materialid like '+''''+'07'+'%'+''''+' and (MaterialSpec='+''''+''+''''+' or MaterialSpec is null) and (MaterialType='+''''+''+''''+' or MaterialType is null');
最后一个NULL的引号是不是要去掉啊。