SQL组句方法

if(!sQuery.IsEmpty())
   {
      SQL+="where InsCode='"+sQuery+"'";
   }
   if(!sProvider.IsEmpty())
   {
      if(SQL.Pos("where")!=0)
      {
        SQL+=" and Provider='"+sProvider+"'";
      }
      else
      {
        SQL+=" where Provider='"+sProvider+"'";
      }
   }

 AnsiString SQL = "select * from TEV_Stock_In where 1=1 ";
  if(RzComboBox2->ItemIndex==1)
  {
    sQuery = GetInsCodeByHelpSign(sQuery);
  }

  if(!sQuery.IsEmpty())
  {
    SQL+=" and InsCode='"+sQuery+"'";
  }
  if(!sProvider.IsEmpty())
  {
    SQL+=" and Provider='"+sProvider+"'";
  }