Using a text box for dynamic query

[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

 

[Alex Dybenko]

Hi,
you can place entered product codes into array using Split() and then make a
loop through it adding quotes and OR between.
Or just replace vbCrLf to ' OR '
something like this

there add select, etc

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com