locked
VC+VFP+ADO+filter RRS feed

  • Question

  • why "filter "attribute not support wildcard "%" in the front,but it is ok for those not prefix with"%":

     

    str.Replace(' ','_!');
              str.Insert(0,'%');
      sqlStr.Format("comment like '%s'",str);

       m_pRecordset->Filter=(_bstr_t)sqlStr;

    Wednesday, January 24, 2007 1:18 PM

Answers

  • It's an ADO specification not VFP - for numerics(documented in ADO). Maybe it's a numerics filter?

    Filter is applied on ADO rs.

     

    Wednesday, January 24, 2007 6:33 PM