ado query vs ado table filter

Article View: borland.public.cppbuilder.database.ado

Article #238

Back to borland.public.cppbuilder.database.ado Previous Next

#238

From: basilis
Date: Fri, 29 Dec 2006 03:14

13 lines
1269 bytes

hi all

i want to view some specific data from a table in a database.there are 2 
ways:
a)pass an sql query in an adoquery component and get the results
b)make a adotable that connects to the table of the database and then use 
the filter property to get the specific results

is there any diffrence in the 2 ways?which one is faster?
should i use the second one if i need to make many queries in the same 
table?

thks

Technical Details

Message-ID: <459487e5@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news2.volia.net!newsfeed01.sul.t-online.de!t-online.de!news.belwue.de!LF.net!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,8b22b1d65c1c333d,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "basilis" <billaras1234@hotmail.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: ado query vs ado table filter
Date: Fri, 29 Dec 2006 03:14:04 -0000
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: 131.227.231.174
Message-ID: <459487e5@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1167362021 131.227.231.174 (28 Dec 2006 19:13:41 -0800)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news2.volia.net!newsfeed01.sul.t-online.de!t-online.de!news.belwue.de!LF.net!newsgroups.borland.com!not-for-mail