Darren DICK
darrend at nimble.com.au
Mon Jan 8 20:05:28 CST 2007
Hi Stuart Thanks for the reply But like I replied to Jim - I have the IQ of cloth - too tricky for me Thanks Darren ------------------ T: 0424 696 433 -----Original Message----- From: Stuart McLachlan [mailto:stuart at lexacorp.com.pg] Sent: Tuesday, 9 January 2007 12:49 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] A2003:Shell opens 2 DOS windows Ah, god old Debug - haven't used that one for years. Have a look at http://www.armory.com/~rstevew/Public/Tutor/Debug/debug-manual.html On 9 Jan 2007 at 11:51, Darren DICK wrote: > Hi Jim > > This looks really interesting > > When I went to a DOS window (In the same folder I created the return.txt > file) and typed 'debug return.txt' (without the quotes) the DOS window > changed size and I was presented with a new line and what looked like a > hyphen ( - ) at the beginning o the new line. I was able to type stuff there > but hitting 'enter' yielded an error and after typing in 0D there was no way > to save this and I did not see the expected Hex 41 > > Did I do something wrong? > > Many thanks > > Have a great day > > Darren > ------------------ > T: 0424 696 433 > -----Original Message----- > From: Jim Lawrence [mailto:accessd at shaw.ca] > Sent: Tuesday, 9 January 2007 11:19 AM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] A2003:Shell opens 2 DOS windows > > Hi Darren: > > This is an old suggestion from the DOS days but I was wondering if the batch > file needed a carriage return to start it running. > > The old method worked something as follows: > Given your batch file name is Darren.bat then a file named return.txt would > be created. > > First create a txt file named return.txt with one letter/number in it, like > a capital 'A' and save it. Then edit the file using the DOS debug command: > > 'Debug return.txt', at the command prompt and edit the 'A' now shown as hex > '41' to a Return hex value of '0D'. Then save the return.txt file and exit. > > Now the return.txt file can be used as a Return value provider, at the > command prompt like: > > Darren.bat < return.txt > > The previous is a simple sample but very complex value provider files can be > created as well > > HTH > Jim > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren DICK > Sent: Monday, January 08, 2007 3:40 PM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] A2003:Shell opens 2 DOS windows > > 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 > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- Stuart -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com