Wow! That sounds like a cool
Script!
Is it possible that you could use a pause loop that
would look for the window to pop up, and then
take the appropriate action?
And if that doesn't
work, you might trying sending the Ctrl-Key sequence that would clear the
message every time that you pass through the loop. This approach would
only work if the Ctrl-Key sequence just goes off into space if not used, and
might require a "pause" to ensure your where you want to be before
proceeding.
All in all though, I
think the "pauseloop" is the way to go.
I've written a couple of scripts that directly update
the Sql tables through Enterprise Manger, and it's worked
great.
I'd love to get a look at the script that you wrote for
totally selfish reasons, and by doing so, I might be able to see what you're
talking about.
Paul
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Friday, March 12, 2004 9:50 AM
To: [EMAIL PROTECTED]
Subject: [Talk] Prompted for Components During Processing
I have an application that loops through a SQL database and invokes a BWS script to generate PDF documents using MS Word based on each record from the databse. I use ADO to access the database.
Once in a while, I will get prompted to select a component in the middle of running the BWS script and the script will be stopped until I either click "OK" or "Cancel" in the Component popup window. This Component window is the same one that you see in VB when you want to add a component to your project.
<<...OLE_Obj...>>
There doesn't seem to be a pattern when this
window comes up but it does seem to come up before the record gets updated to
the database. Any help will be greatly appreciated.
Thanks, Jennifer
