我的这段话为何出问题?

xldxform.ADOQuery2.Filtered:=false;
xldxform.ADOQuery2.Filter:='bdsm=listview1.Selected.Caption';
xldxform.ADOQuery2.Filtered:=true;
这段程序为何报错,难道我的句子有问题吗?

解决方案 »

  1.   

    xldxform.ADOQuery2.Filtered:=false;
    xldxform.ADOQuery2.Filter:='bdsm='+quotedstr(listview1.Selected.Caption);
    xldxform.ADOQuery2.Filtered:=true;
      

  2.   

    xldxform.ADOQuery2.Filtered:=false;
    xldxform.ADOQuery2.Filter:='bdsm='+quotedstr(listview1.Selected.Caption);
    xldxform.ADOQuery2.Filtered:=true;
      

  3.   

    xldxform.ADOQuery2.Filtered:=false
    ;
    //你那bdsm是字符類型的寫成這樣:
    xldxform.ADOQuery2.Filter:='bdsm='+''''+listview1.Selected.Caption+'''';
    //如果不是寫成這樣:
    xldxform.ADOQuery2.Filter:='bdsm='+listview1.Selected.Caption;xldxform.ADOQuery2.Filtered:=true;