How to get user input for queries?
To prompt for user input you can use inline Visual
Basic .Net code (available in v 2.1 or above). For instance, this query will prompt for input of
EventID:
select top
100 * from Application where
EventID=<% return
Microsoft
.VisualBasic.Interaction.InputBox("Please enter Event
ID","Event ID","1053") %>