R. Here is a discussion of roughly what I want to do, it seems that there are not many options, which is why yours should do it, easily :-) http://stackoverflow.com/questions/2364835/how-to-extract-a-set-of-records-with-a-specific-field-from-a-delphi-in-memory-da -----Original Message----- From: yunqa-bounce@xxxxxxxxxxxxx [mailto:yunqa-bounce@xxxxxxxxxxxxx] On Behalf Of Delphi Inspiration Sent: 01 April 2012 14:40 To: yunqa@xxxxxxxxxxxxx Subject: [yunqa.de] Re: Disklite 3 Pro : Temporary table question On 31.03.2012 16:19, Jon Burnham wrote: > I have looked at the dynamic side of DISQLite3, I understand that a > disk based temporary table is probably optimal. What I don’t get is > now not being able to assign a name to the temporary> disk-based > table. Why not, it’s still an object and needs referencing. What makes you believe that you can not name temporary tables in DISQLite3? You can! Here is some example SQL to create and reference a temporary table in DISQLite3: create temp table TempTable (a text); insert into TempTable values ('A named temporary table!'); select * from TempTable; Ralf _______________________________________________ Delphi Inspiration mailing list yunqa@xxxxxxxxxxxxx //www.freelists.org/list/yunqa _______________________________________________ Delphi Inspiration mailing list yunqa@xxxxxxxxxxxxx //www.freelists.org/list/yunqa