I feel I'm going round in circles and getting no where. Can anyone come up with a working suggestion. What I want to do is actually very simple. I want to create a simple in memory database that I can index to enable me to do either a quick lookup or a sql select to return one row of data that I can use to complete my task.
Current state of affairs
Tbufdataset and all decendants : Broken (numerous reports in bug tracking
SQLLite : I'm stuck. Can create database and store data without a problem, Locate is extremely slow and if I try a SQL statement then all data lost as need to activae select sql using "SQL.open" to get returned dataset
I'm out of Ideas!
HELP!