I've just posted the code for my string based in-memory table into the binaries.

A bit of history. I bought the TMS component suite to pretty up my apps. I'm in the process of removing them. I found their DB grid to be awkward to manage. The rest of their components give me far to much capability for my needs, and also, mainly because of the way they've implemented themes, they add a lot to application size. Removing the DBgrid and pagecontrol has removed about 3Mb from the executable (OK compiled with debug info). I have about 100 AdvStringGrids in the app and I'm guessing I'll slice another couple of meg out by switching them.

Initially I intended to write my own stringgrid. Just after I started I discovered Gerald Nunn's gxBaseDataSet component (its public domain - I asked him) so I went back to an old idea of mine. A lightweight table using DBGrids rather than a stringgrid.

Key facts are:

lightweight
single user
local memory
simple filtering (no brackets, no sql, no functions eg LowerCase)
simple sorting (up to three columns)


When I was using DBISAM I used its in-memory tables and queries a lot, I could have used ElevateDB's but they're a bit heavyweight for what I want, and I can't use queries because I generally had a canned query and with ElevateDB I can't edit them.

Next stage is to enhance my DBGrid (based on Mike Skolnik's) to do what I want. The biggest challenge is going to be getting it to switch indices for ElevateDB tables, alter the sort for nlhSGTables and alter the sql for ElevateDB queries by simply clicking on the title rather than having an OnTitleClick event that I have to respond to in my code.

Any suggestions welcome.


Roy Lambert