macros query prompts

[neeraj]

Please let me know how a macro can me made to skip the prompts associated
with a make table/delete table query

 

[Wolfgang Kais]

neeraj.

Please let me know how a macro can me made to skip the
prompts associated with a make table/delete table query

Use the SetWarnings action.

 

[neeraj]

Thanks, it helped but not entirely. My macro has the following components now:
1st row: make table query
2nd row: set warnings (set to "no")
3rd row: make table query
4th: set warnings (no)
5th: delete query
6th: set warnings (no)
What is happening now is that when I run the macro, it asks me for only one
prompt now, it is associated with the very first make table query and it
says: "the existing table will be deleted...do you want to continue".
Interestingly, it does not issue the same warning for the second make table
query. Is there a way that I can disable this confirmation message

 

[KARL DEWEY]

Set warning No first, only once.

After all of the other steps SetWarnings Yes.

 

[neeraj]

Thanks, I got to know that in the meanwhile too, but why would you want to
set the warnings to Yes in the end. Even without setting the warnings to yes
in the end, the individual make table query when run was generating
confirmation messages.

 

[Steve Schapel]

Neeraj,

There is no need to SetWarnings to Yes at the end.

Make your macro like this...

1. SetWarnings / No
2. OpenQuery / (your 1st make-table)
3. OpenQuery / (your 2nd make-table)
4. OpenQuery / (your delete query)