Re: Filter and two wildcars error

Hi,

You need to put wildcards into single quotes inside the string

Recordset.Filter := "FIELD LIKE '**'"


--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"Demian" <demian.procopio@xxxxxxxxx> wrote in message
news:1124812948.903248.209710@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi
>
> I have de following problem:
>
> I need to filter a recordset, but when execute the following code I
> obtein an error
>
> Recordset.Filter := 'FIELD LIKE **'
>
> any idea???
>
> Thanks
>


.

Relevant Pages

  • Re: Insert empty value in Datefield (MS Access and ADO.NET)
    ... Arjan ... >>> Val Mazur ... >>> Microsoft MVP ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Mandis Quotes (aka retiring """ and )
    ... > surround the string by a pair of doubled single quotes. ... > an arbitrary string in-between the single quotes which does NOT ... > of ASCII or Unicode characters, but instead as a sequence of lines ...
    (comp.lang.python)
  • Re: quotes from form input + MySQL insert query
    ... string mysql_escape_string ... > same way, but a textarea string full of single quotes is handled fine, while ... I've checked the POSTed data by echoing ... > backslashes, in case the single ones generated by magic_quotes weren't ...
    (alt.php)
  • Re: Whats wrong
    ... local machine user, ... Microsoft MVP ... > FileShare share, Int32 bufferSize, Boolean useAsync, String msgPath, ... > sourceControl, String eventArgument) ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: FP2000 VBA: objects, methods for graphics, links?
    ... > Thomas A. Rowe (Microsoft MVP - FrontPage) ... >> capital letters, and this may be causing me problems (got a thread on ... I thought if I could write every name to a string, ... >>> What you want to do is already built into FrontPage. ...
    (microsoft.public.frontpage.programming)