Auto Confirmation after running update query

[Guest]

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?

 

[Ed Metcalfe]

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?

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.