Hi all,
I’m using Xojo with DBkit on XojoCloud and it’ an amazing timesaver. DBKit’s SearchField with a QueryRowsListBox are great for simple searches.
I’m wondering if there is a way to use DBKit for more complex searches? Specifically the intention is to be able to filter the QueryRowsListBox data by a number of parameters.
I don’t know if there is a way to use the database connection from DBKit - perhaps incorrectly, I’ve resorted to creating a separate database connection, doing a more complex selectSQL, removing all rows from the QueryRowsListBox and adding rows by iterating through the found RowSet.
This works - but seems clunky.
It feels like I should just be able to pass a RowSet to DBKit, but so far I’ve not been able to get this to work (having tried to set the QueryRows properties in TableConnection and QueryRowsListBox).
Is there a better way to do this than manually removing and adding rows?
Many thanks
Stam