Auto Confirmation after running update query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mslee65 - 21 Apr 2007 15:56 GMT

I am running the following query through a macro at the end of every day
through the windows scheduler:

UPDATE ItemMaster INNER JOIN AMFLIB_ITEMASA ON
ItemMaster.ITNOIM=AMFLIB_ITEMASA.ITNBR SET ItemMaster.UCDEF =
AMFLIB_ITEMASA.UCDEF;

However, when it finishes, it asks for a confirmation to update xxxx
records. I tried to enter a SendKeys action with the keystroke Y or {ENTER},
but it does not answer the dialog box. How do I answer this dialog box,
which expects you to click on the YES command button?

Reply to this Message

Ed Metcalfe - 21 Apr 2007 22:28 GMT

>I am running the following query through a macro at the end of every day
> through the windows scheduler:
[quoted text clipped - 8 lines]
> but it does not answer the dialog box. How do I answer this dialog box,
> which expects you to click on the YES command button?

Have a look at the SetWarnings action in your macro. You need to turn them
off before running the query, and the turn them back on again.

Be aware that this will also supress any messages about records that have
not been updated (for index/validation violations, for example).

Ed Metcalfe.

Reply to this Message