Re: [DUG]: Another SQL poser

[Mark Howard]

Further to my post below: I've found that in the DBD if I Execute the first query (without "into temp") Rename ANSWER.DB to TEMP.DB Execute the second query then I get what I want.   Is there a way in Delphi to create a virtual Temp.db file in memory that can be referenced by the second query?   Or (better) is there a more elegant solution?   Mark ----- Original Message ----- From: Mark Howard To: Multiple recipients of list delphi Sent: Friday, May 25, 2001 4:46 PM Subject: [DUG]: Another SQL poser Hello I'm using Paradox.   I want to achieve the following effect:   Select into temp distinct a.forcode, a.comp from dockets a where a.docketdate > '31/03/2001';   Delete from dockets b where not exists (select c.forcode from temp     where b.forcode = temp.forcode     and b.comp = temp.comp)   BUT with Paradox I can't use the "into temp" syntax   Can someone suggest another way of acheiving the same.   In a nutshell, I want to delete all the rows from the dockets table where the forcode/comp combination is not current (ie been used this financial year)   Any ideas?   TIA   Mark