I am using an Sqlite database and all is good with the tables and query working well, when not using variables.
Having got it to work my application will now query the database from variables created from combo box or text entry.
It appears that variables cannot be used in the query statement for Sqlite database.
Basic code for clarity....
ttable is a variable table name selected from a combo box.put revQueryDatabase(conID, "SELECT * FROM ttable") into tresult
I will need to add the WHERE bit above to include other variables in the same query to narrow the returned result...
Can variables be used in the query construct? In fact I would think most applications would need to change the query based on user input? The query must alter depending on user selection before the query is run.
Please can someone help me.... how do I use the variable ttable in the query statement?
Thanks for any help