Using a text box for dynamic query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

can anyone point me in the right direction to be able to use a multi line
text box to generate an SQL statement.

For example, I want a user to be able to manually type in a list of product
codes, click a command button then generate a list of matches. It is
important for the user that they can manually type in a list of codes - or
more likely copy and paste in a list of codes into the text box.

The query I need to generate is very simple bar the list of parameters -
they would all be OR statements, eg:

ProductA OR ProductB OR ProductC etc
 
Back
Top