Querying every table in a DB

Article View: comp.lang.pascal.delphi.databases

Article #15

Back to comp.lang.pascal.delphi.databases Previous Next

#15

From: Jeff Speed
Date: Fri, 28 Jul 2000 00:00

8 lines
1424 bytes

Hello,
I was wondering if there is anyway to query every table in an Access DB.
The result of the query would consist of the table name and a sum field  Is
there a way to do this?  I am using ADO connection with Access and using D5.
I would like to create a temp table to store all of this in, too.  Thanks
for all your help.

Jeff

Technical Details

Message-ID: <Ovig5.1972$Rz1.3353@east2.usenetserver.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffff5,4778dd3a4c3b79b6,start
X-Google-Attributes: gidffff5,public
X-Google-Thread: 10baee,4778dd3a4c3b79b6,start
X-Google-Attributes: gid10baee,public
X-Google-Thread: f5cad,4778dd3a4c3b79b6,start
X-Google-Attributes: gidf5cad,public
X-Google-Thread: 115d96,4778dd3a4c3b79b6,start
X-Google-Attributes: gid115d96,public
From: "Jeff Speed" <speedjk@hotmail.com>
Subject: Querying every table in a DB
Date: 2000/07/28
Message-ID: <Ovig5.1972$Rz1.3353@east2.usenetserver.com>
X-Deja-AN: 651863339
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
X-Abuse-Info: Otherwise we will be unable to process your complaint properly
X-Complaints-To: support@usenetserver.com
Organization: WebUseNet Corp  http://www.usenetserver.com - Home of the fastest NNTP servers on the Net.
X-MSMail-Priority: Normal
NNTP-Posting-Date: Fri, 28 Jul 2000 12:27:26 EDT
Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database,borland.public.delphi.database.ado,comp.lang.pascal.delphi.misc