The Sun documentation at http://java.sun.com/docs/books/tutorial/jdbc/basics/index.html is very useful. If you're using a small Access database it shouldn't be a problem for Java to handle the processing because you can't be working with a huge ResultSet.
If you could send the query you're trying to run and specify what you're wanting to do with the result it would help.
Kind regards,
Antoine
-----Original Message-----
From: [email protected] on behalf of Donavan Daniels
Sent: Thu 9/29/2005 12:45 PM
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 -----
From: Bruce Stewart
To: [email protected]
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
Title: RE: [CTJUG Forum] Re: Re calling a query
- [CTJUG Forum] Re: Re calling a query Bruce Stewart
- [CTJUG Forum] Re: Re calling a query Donavan Daniels
- [CTJUG Forum] Re: Re calling a query Bruce Stewart
- [CTJUG Forum] Re: Re calling a query Antoine Fortuine
- [CTJUG Forum] Re: Re calling a query Donavan Daniels
- [CTJUG Forum] Re: Re calling a query Lin Meiring
- [CTJUG Forum] Re: Re calling a query Antoine Fortuine
