[yunqa.de] Re: Disklite 3 Pro : Temporary table question

  • From: "Jon Burnham" <jba@xxxxxxxxxxxxxx>
  • To: <yunqa@xxxxxxxxxxxxx>
  • Date: Sun, 1 Apr 2012 16:34:55 +0100

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



Other related posts: