Connecting Tech Pros Worldwide Help | Site Map

call a query by macro with parameters

  #1  
Old May 16th, 2006, 10:35 AM
Andy
Guest
 
Posts: n/a
Hello,

I have a question about macros and querys. I call a macro from a extern
application with some parameters... i.e. ID. Everything works fine. My
question is, how to get this ID into the query.
The query is already created but I want to add a "WHERE mytable.id =
ID" statement into the query and then run it. Can you help me pls ?

thx in advance.

Bye, Andy

  #2  
Old May 16th, 2006, 08:05 PM
Arno R
Guest
 
Posts: n/a

re: call a query by macro with parameters


Try to put something like [Enter the needed ID] as the criterion for your ID-field.
When you run the query you will see a popup where you can enter the ID.
Is that what you are looking for?

Arno R

"Andy" <andreas.blenk@blenk-software.de> schreef in bericht news:1147771641.911299.254630@j55g2000cwa.googlegr oups.com...[color=blue]
> Hello,
>
> I have a question about macros and querys. I call a macro from a extern
> application with some parameters... i.e. ID. Everything works fine. My
> question is, how to get this ID into the query.
> The query is already created but I want to add a "WHERE mytable.id =
> ID" statement into the query and then run it. Can you help me pls ?
>
> thx in advance.
>
> Bye, Andy
>[/color]
Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
comp.lang.c Answers to Frequently Asked Questions (FAQ List) Steve Summit answers 0 November 14th, 2005 04:15 AM
comp.lang.c Answers to Frequently Asked Questions (FAQ List) Steve Summit answers 0 November 13th, 2005 11:37 PM
comp.lang.c Answers to Frequently Asked Questions (FAQ List) Steve Summit answers 0 November 13th, 2005 09:56 PM
comp.lang.c Answers to Frequently Asked Questions (FAQ List) Steve Summit answers 0 November 13th, 2005 03:15 AM