[CTJUG Forum] Re: Re calling a query

Thu, 29 Sep 2005 04:20:56 -0700

I don't think it will make any difference to performance or efficiency having the query in your code.
I think that M$Access queries might be treated as database "views" and not tables - just a thought - I really have no idea..;-)
-----Original Message-----
From: Donavan Daniels [mailto:[EMAIL PROTECTED]
Sent: 29 September 2005 12:45
To: [email protected]
Subject: [CTJUG Forum] Re: Re calling a query

Thanks for the response!
 
That does work but the SQL statement gets large and I want to leave the processing with access or doesn't it matter?
 
Regards
Donavan
----- Original Message -----
Sent: Thursday, September 29, 2005 12:37 PM
Subject: [CTJUG Forum] Re: Re calling a query

Why not simply place the sql from the query in your app?
-----Original Message-----
From: Donavan Daniels [mailto:[EMAIL PROTECTED]
Sent: 29 September 2005 08:03
To: CTJUG Forum
Subject: [CTJUG Forum] Re calling a query

HI Guys
 
I recently joined this forum and I have a question.
I have written a small app which stores its data in Microsoft access.
I have created a query in access which has the relevant data from various tables.
I need to read the result of the query and display it in my app.
How do I call this query??
I can read tables but not queries??
 
 
I would appreciate any help.
 
Regards
Donavan Daniels

Reply via email to