General information
Category:
Coding, syntax & commands
Title:
Execute an SQL statement that is stored in a String?
I want to let the users choose from a lot of options in a Form, then, based on that options, my aplication build an SQL statement and store it in a String.
Something like this:
sStatement = "SELECT * FROM " + Combo1.Value + " ORDER BY " + Combo2.Value
Actually I create more complicated Querys, but that´s the idea.
I do not want to create a fixed Query for all the 130 diferent combinatios that the user can choose from, so I need to do something like that.
As you can see, not only the variables values are going to change, also the table names and field names will.
I`m using a local Database
Thanks in advance
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