Darren DICK
darrend at nimble.com.au
Mon Jan 8 17:39:54 CST 2007
Hi Stuart The batch file works fine if I double click it by the way Just not if I issue the Shell Command to it from Access - the batch file and its path are not the issue - I don't think >> What are in strFileName and the batch file? String File name is the path to the batch file - it is all cool Again - the batch file works fine and as desired if double clicked but not when Shelled to by Access The batch file is full of repetitive lines like... (xml_creation.rb is a Ruby App we wrote ourselves) xml_creation.rb -t TA -a sqlserver -h SERVERNAMEHERE -d DBNamehere-u sa -p PASSWORDHERE -i 10113 xml_creation.rb -t TA -a sqlserver -h SERVERNAMEHERE -d DBNamehere-u sa -p PASSWORDHERE -i 10114 xml_creation.rb -t TA -a sqlserver -h SERVERNAMEHERE -d DBNamehere-u sa -p PASSWORDHERE -i 10115 xml_creation.rb -t TA -a sqlserver -h SERVERNAMEHERE -d DBNamehere-u sa -p PASSWORDHERE -i 10116 xml_creation.rb -t TA -a sqlserver -h SERVERNAMEHERE -d DBNamehere-u sa -p PASSWORDHERE -i 10117 xml_creation.rb -t TA -a sqlserver -h SERVERNAMEHERE -d DBNamehere-u sa -p PASSWORDHERE -i 10118 xml_creation.rb -t TA -a sqlserver -h SERVERNAMEHERE -d DBNamehere-u sa -p PASSWORDHERE -i 10119 xml_creation.rb -t TA -a sqlserver -h SERVERNAMEHERE -d DBNamehere-u sa -p PASSWORDHERE -i 10120 xml_creation.rb -t TA -a sqlserver -h SERVERNAMEHERE -d DBNamehere-u sa -p PASSWORDHERE -i 10121 xml_creation.rb -t TA -a sqlserver -h SERVERNAMEHERE -d DBNamehere-u sa -p PASSWORDHERE -i 10122 xml_creation.rb -t TA -a sqlserver -h SERVERNAMEHERE -d DBNamehere-u sa -p PASSWORDHERE -i 10123 echo **10123 done** xml_creation.rb -t TA -a sqlserver -h SERVERNAMEHERE -d DBNamehere-u sa -p PASSWORDHERE -i 10124 Many thanks Have a great day Darren ------------------ T: 0424 696 433 -----Original Message----- From: Stuart McLachlan [mailto:stuart at lexacorp.com.pg] Sent: Monday, 8 January 2007 8:48 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] A2003:Shell opens 2 DOS windows Wjhat are in strFileName and the batch file? On 8 Jan 2007 at 8:35, Darren DICK wrote: > I use the line below to open and 'run' a batch file > > Call Shell(strFileName) > > Can anyone tell me why 2 dos (Command) windows open? > > The syntax is valid - everything is cool - but 2 of them open up and then > start trying to process the lines in the batch file > > And no. There is not some second call buried elsewhere in the code -- Stuart -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com