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