Article View: borland.public.cppbuilder.database.ado
Article #1039TADOQuery and filter problem...
From: Eduardo Jauch
Date: Fri, 17 Dec 2004 20:56
Date: Fri, 17 Dec 2004 20:56
19 lines
1450 bytes
1450 bytes
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:
<41c346fc@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!border1.nntp.dca.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-mailShow Full Headers
Complete Article Headers
X-Google-Thread: 10698b,3cc227323da1cc76,start X-Google-Attributes: gid10698b,public X-Google-Language: ENGLISH,ASCII-7-bit Date: Fri, 17 Dec 2004 18:56:31 -0200 From: Eduardo Jauch <sistemas@palletbrasil.com.br> User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: pt-br, pt MIME-Version: 1.0 Newsgroups: borland.public.cppbuilder.database.ado Subject: TADOQuery and filter problem... Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 200.146.84.188 Message-ID: <41c346fc@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1103316732 200.146.84.188 (17 Dec 2004 12:52:12 -0800) Lines: 19 Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!border1.nntp.dca.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