CopyPaste SQL from query doesn't work

[aprentice]

If I copy paste the SQL from a query (View->SQL) to a macro it doesn't work.
Why?
I've tried removing quotes,Caps, adding quotes, parenthesis nothing worked.
Any ideas?

 

[llkhoutx]

I use very few macros. However, if you have any form references, they must be properly concantenated. Of course, it must be an action query too. A select query gets you nothing.

 

[aprentice]

Of course, it must be an action query too. A select query gets you nothing.

Hm, that is the reason I guess. But why is that?
The stupid thing is that the error msg says that it must contain CREATE, SELECT, UPDATE etc

But if u use the same statement (select quey) in a module it works fine.
Strange things happen...

 

[llkhoutx]

Hm, that is the reason I guess. But why is that? A select query in a macro doesn't display any data, it must be an action query. Therefore,
. . . the error msg says that it must contain CREATE, SELECT, UPDATE etc, an action!