Re: [DUG] Temporary Tables Interbase / Firebird

2004-05-31 Thread Trevor Jones
ject: [DUG] Temporary Tables Interbase / Firebird Hi As you may have gathered we are moving from Dbase to Firebird. An app we have makes some temporary (dbase) tables and after processing disposes of them. I know we can create tables in FB / IB on the fly but we are reluctant to risk

Re: [DUG] Temporary Tables Interbase / Firebird

2004-05-31 Thread Robert martin
Sent: Monday, May 31, 2004 5:56 PM Subject: Re: [DUG] Temporary Tables Interbase / Firebird Robert, I think IB 7.1 supports temporary tables, but I have never found a good reason to use them in FB. A dBase app is necessarily going to be very different from one that works

RE: [DUG] Temporary Tables Interbase / Firebird

2004-05-31 Thread C Fraser
Group -Delphi ListSubject: Re: [DUG] Temporary Tables Interbase / Firebird Thanks to everyone who replied. There is certainly a lot to think about. We always try to use joins wherever possible and I agree that sub selects are as slow as the plague :). We are using Firebird and hoping

Re: [DUG] Temporary Tables Interbase / Firebird

2004-05-31 Thread Robert martin
Message - From: C Fraser To: 'NZ Borland Developers Group - Delphi List' Sent: Tuesday, June 01, 2004 9:29 AM Subject: RE: [DUG] Temporary Tables Interbase / Firebird Main web sites for FB are www.firebirdsql.com and http://www.ibphoenix.com/. The lists and news

RE: [DUG] Temporary Tables Interbase / Firebird

2004-05-30 Thread C Fraser
Developers Group - Delphi ListSubject: RE: [DUG] Temporary Tables Interbase / Firebird From memory, InterBase 7.1 supports temporary tables. Not sure about firebird. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert martinSent: Monday, 31 May 2004 4:26 p.m.To: [EMAIL

Re: [DUG] Temporary Tables Interbase / Firebird

2004-05-30 Thread Steve Peacocke
At 04:25 p.m. 31/05/2004, you wrote: Hi As you may have gathered we are moving from Dbase to Firebird. An app we have makes some temporary (dbase) tables and after processing disposes of them. I know we can create tables in FB / IB on the fly but we are reluctant to risk polluting our