Getting an SQL statemnet from a MS Access database

Article View: borland.public.delphi.database

Article #119

Back to borland.public.delphi.database Previous Next

#119

From: Ralph Wesseling
Date: Tue, 18 Nov 2003 21:32

14 lines
1305 bytes

Hello,

I am a bit new to database programming so I may be asking the obvious here.

I have an Access database  (myDatabase) that contains a number of queries
(e.g. Query_Basis_For_TAX_INVOICE). I would like to get the underlying SQL
statement form these queries and use it inside my Delphi App. Can any one
provide me with an example to do this?


Help would be most appreciated


Ralph

Technical Details

Message-ID: <3fba8fab$0$58714$e4fe514c@news.xs4all.nl>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsgate.cistron.nl!transit.news.xs4all.nl!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 115d96,21685b4c9bb0b998,start
X-Google-Attributes: gid115d96,public
X-Google-ArrivalTime: 2003-11-18 13:31:25 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsgate.cistron.nl!transit.news.xs4all.nl!not-for-mail
From: "Ralph Wesseling" <Ralph@REMOVEnumberworks.com>
Newsgroups: borland.public.delphi.database
Subject: Getting an SQL statemnet from a MS Access database
Date: Wed, 19 Nov 2003 10:32:15 +1300
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Lines: 16
Message-ID: <3fba8fab$0$58714$e4fe514c@news.xs4all.nl>
NNTP-Posting-Date: 18 Nov 2003 22:31:24 CET
NNTP-Posting-Host: 210.54.239.129
X-Trace: 1069191084 news.xs4all.nl 58714 pravda/210.54.239.129:2715
X-Complaints-To: abuse@xs4all.nl