General information
Category:
Coding, syntax & commands
Title:
Build SQL From User Choices & Invoke It
I have a form from which a user is able to select four values, from which I build a SQL.
The intent is to present a report using the parameters choosen by the user.
I have the process of creating the string working fine, but the result is a text string such as SqlTxt = 'Select All From MyData Where Color = "Orange"'.
My question is what is the best way to invoke that SQL statenent, i.e. make it run.
Thanks.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only