通过FlatComboBox做选择条件查询,
为什么在FlatComboBox5.text加引号就出现如下错误,不加又可以通过,这是什么错误提示呢??if FlatComboBox7.Text='包含' then
               term:=term+'sqaddr='+FlatComboBox12.Text+' and wcdate'+' like ''%'+FlatComboBox5.text+'%'''
          else
               term:=term+'sqaddr='+FlatComboBox12.Text+' and wcdate'+FlatComboBox7.text+''''FlatComboBox5.text'''';
[Error] gltj_9.pas(70): Missing operator or semicolon
[Error] gltj_9.pas(70): Missing operator or semicolon
[Fatal Error] Project1.dpr(5): Could not compile used unit 'gltj_9.pas'

解决方案 »

  1.   

    if FlatComboBox7.Text='包含' then 
                   term:=term+'sqaddr='+FlatComboBox12.Text+' and wcdate'+' like ''%'+FlatComboBox5.text+'%''' 
              else 
                   term:=term+'sqaddr='+FlatComboBox12.Text+' and wcdate'+FlatComboBox7.text+''''FlatComboBox5.text''''; //这一句语法有错误,自己修改一下
      

  2.   

    第二句FlatComboBox5.Text两边少了两个加号,你的sqaddr应该是字段,如果是字符型的话,还要多加几个引号
    if FlatComboBox7.Text='包含' then 
                   term:=term+'sqaddr='''+FlatComboBox12.Text+''' and wcdate'+' like ''%'+FlatComboBox5.text+'%''' 
              else 
                   term:=term+'sqaddr='+FlatComboBox12.Text+' and wcdate'+FlatComboBox7.text+''''+FlatComboBox5.text+''''; 
      

  3.   

    if FlatComboBox7.Text='包含' then 
        term:=term+'sqaddr='''+FlatComboBox12.Text+''' and wcdate'+' like ''%'+FlatComboBox5.text+'%''' 
      else 
       term:=term+'sqaddr='''+FlatComboBox12.Text+''' and wcdate'+FlatComboBox7.text+''''+FlatComboBox5.text+'''';
      

  4.   

    谢谢kaikai_kk!!! 帮我解决了问题,分全给你了