What you are asking to do is to be able to execute an Access Query from
Delphi. That's outside the BDE model because in the BDE you use TTables and
TQueries which use the BDE's own SQL and code to execute the query, which is
quite different from telling the Jet Engine to execute a query stored in the
Access database. All the stuff I can see in BDE is to do with BDE tables and
queries.
My guess is you need to use DAO. Either by OLE (which in my experience to
date, late-bound, is very slow), or by using some other method such as Opus
Direct Access's Programmed Access units, which let you write DAO code in
your Delphi program - this is very fast. It's possible also that one of the
other third-party products will also let you do DAO, I'm not aware of any
mechanism in the Borland native access stuff that will allow it, unless
low-level stuff like the BDE unit provides some implementation of it but
then this is likely to be in BDE terms anyway.
============================================
Views contained in this post are my personal opinions and unless otherwise
stated not those of any organisation I am associated with.
----------------------------------------------------------------------------
----------
Vote Future New Zealand - for the FUTURE of NEW ZEALAND.
Temporary site: http://www.geocities.com/CapitolHill/Senate/9789/fnz/
=================================================
Patrick Dunford, ChristChurch, NZ
http://www.geocities.com/Heartland/Village/3405/
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of [EMAIL PROTECTED]
> Sent: Monday, 7 December 1998 16:23
> To: Multiple recipients of list delphi
> Subject: [DUG]: Access Queries
>
>
>
> Sorry Guys - I failed to make myself clear
> I need to get the list in Delphi using the BDE (Native
> Access Driver).
>
> Original Message
> Is there a method to obtain a list of Access Queries?
> I would like the user to be able to select a specific Query from a
> dropdown list Thanks Jim Quickenden
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
