I am still a bit confused on how to make rowsets with different criterias:
I have a SQLite database with a table called contracts. In that table, I have a few fields and two of them are called name and active.
Name has the customer name and Active has either an “x” (no quotes) or blank. I want to populate a listbox with those that only have an x as active. I wrote the following code but I check an error when it goes to open the listbox.
var rs2 as RowSet
Var sql as string
Var Act as string
Act = “x”
sql = "select * from Contracts ORDER by Name Where Active = ? "
rs2 = app.db.SelectSQL(sql,Act)