Vista - open a file, wait for user to amend file, close & process

Hi all,

I'm creating a 'run ad hoc' sql file. It runs file.sql against a list of
servers. I want the user to be able to amend the contents of file.sql before
running it.

I need to get my script to open the file:
( notepad file.sql )
let the user amend & save the contents. then carry on & run the file.
( osql . . . -i file.sql )

I can get it to open file.sql but the rest of the script just plays on in
the background. It doesn't wait until the file is changed and closed.

If you help, I will be eternally grateful!

Pipe the notepad statement to Out-Null, this will cause the script to wait until notepad is closed by the user.

# create a test file
Set-Content qt.txt 'line 1'

# copy this script and run it
# -< script.ps1 >-
'start!'
notepad .\qt.txt | Out-Null
cmd /c type qt.txt
'done!'

--
Robert

Rob, you rock! This works like a dream. Thank you for taking the time to
answer.

"Robert Robelo" wrote: