Re: Filter and two wildcars error
Tech-Archive recommends: Fix windows errors by optimizing your registry
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) |
|