Article View: borland.public.cppbuilder.database.ado
Article #1090Re: TADOQuery and filter problem...
From: Viatcheslav V. Vassiliev
Date: Sat, 18 Dec 2004 09:52
Date: Sat, 18 Dec 2004 09:52
31 lines
1970 bytes
1970 bytes
Try "city like 'sometext%'" //------------------------------------------ Regards, Vassiliev V. V. http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + ADO.Net http://www.oledbdirect.com - The fastest way to access MS SQL Server, MS Jet (Access) and Interbase (through OLEDB) "Eduardo Jauch" <sistemas@palletbrasil.com.br> ???????/???????? ? ???????? ?????????: news:41c346fc@newsgroups.borland.com... > I use this type of code to filter my table: > > query1->Filtered = false //query1 is a TADOQuery > query1->Filter = "city = " + QuotedStr(Edit1->Text + "*"); > query1->Filtered = true; > > query1->Refresh(); > > When i use a TQuery that point to a PARADOX table, this work and > i retrieve the registers that begin with the text in the edit box. > > But the TADOQuery and a MSAccess table this code don't work. > I get always an empty table. > > What i'm doing wrong? > > Thanks. > > Eduardo Jauch.
Technical Details
Message-ID:
<41c3fde3$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!news.netcologne.de!newsfeed-fusi.netcologne.de!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mailReferences:
<41c346fc@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,3cc227323da1cc76 X-Google-Attributes: gid10698b,public X-Google-Language: ENGLISH,ASCII-7-bit From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com> Newsgroups: borland.public.cppbuilder.database.ado References: <41c346fc@newsgroups.borland.com> Subject: Re: TADOQuery and filter problem... Date: Sat, 18 Dec 2004 12:52:34 +0300 Lines: 33 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 NNTP-Posting-Host: 217.73.240.99 Message-ID: <41c3fde3$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1103363555 217.73.240.99 (18 Dec 2004 01:52:35 -0800) Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!news.netcologne.de!newsfeed-fusi.netcologne.de!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail