Macro - RunSQL

[GW]

HI,
Appreciate it if someone could help me.

1) Execution failed to RunSQL action for SQL Statement
ALTER TABLE Table1 ADD Column1 NULL
2) Confirmation Box (Yes/No) still appear even I created
Action SendKeys Y before and after 1 item of RunSQL
(Update) Action, but it looks fine to other RunSQL Action.

TQ.

 

[Steve Schapel]

TQ

1) You left out the word COLUMN. And I am not aware of the usage of
the keyword NULL in this context. NOT NULL means something, but I can't
make sense of what you are trying to achieve here. Try it like this...
ALTER TABLE Table1 ADD COLUMN Column1

2) Using SendKeys macro action in this context is generally regarded as
unwise. In any case, I think the key to send would be ~ (Enter), rather
than Y.

 

[GW]

Hi,

1) ALTER TABLE curr ADD COLUMN test
Is this a correct statement ? I still got this "Action
Failed"

2) How to send keystroke <enter>. U mean i have to type
the word enter in the keystroke column?

 

[Steve Schapel]

Hi,

1) ALTER TABLE curr ADD COLUMN test
Is this a correct statement ? I still got this "Action
Failed"

Ok, it might require the data type, for example...
ALTER TABLE curr ADD COLUMN test TEXT

2) How to send keystroke <enter>. U mean i have to type
the word enter in the keystroke column?

~ is the keystroke for Enter