[AccessD] A2003: return records from Stored proc in SQL

Darren D darrend at nimble.com.au
Tue Jun 19 20:37:16 CDT 2007


Hi Arthur 

Excellent - I have a question already (3 actually) :-)

I have SQL queries stored as dot SQL files - cool

How can I run one of these files SAY...C:\MyFolder\SomeCoolQuery.sql from one of
the new ADP forms I intend to create?

Basically I can just 'drag' the dot SQL file over to the Query Analyser (QA)
Grid

Now maybe I can reference the 'path' of the dot SQL file and 'run it' - Is this
possible?

Second Question
Assuming we can get the 'File Name' version of a dot SQL file to run how do I
pass it parameters?

Third Question - I've got a jillion more - but am being reserved :-) - Early
days you see
In QA I see the results - EG it may say 13000 rows updated etc
Is it possible to see anything like that in ADP?

Thanks for this
 
ooooooooohhhhhh this is gonna be fun!!!!!!!

Darren
------------------

-----Original Message-----
From: Arthur Fuller [mailto:fuller.artful at gmail.com] 
Sent: Wednesday, 20 June 2007 10:22 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A2003: return records from Stored proc in SQL

I consider myself one of the earliest adopters of this stuff and I've made a
jillion mistakes in working with it (the essential characteristic of an
expert LOL), so if you have questions -- and you will, for sure -- fire
away.

A.


On 6/19/07, Darren D <darrend at nimble.com.au> wrote:
>
> Oh yeah!!!!!!!!!! - the possibilities - oh my gosh
>
> Many many thanks Arthur
>
> Have a great day
>
> Darren
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.472 / Virus Database: 269.9.1/854 - Release Date: 19/06/2007 1:12
PM
 

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.472 / Virus Database: 269.9.1/854 - Release Date: 19/06/2007 1:12
PM
 




More information about the AccessD mailing list