|
Most of the comments I have seen on Temporary Tables in FB
say that you shouldn't really need them in FB... Not sure on the justification
on this, but it has been mentioned by people 'In the
Know'...
Can a stored procedure be used instead? Stored procedures
can be used to return data like a table, and people often comment when moving
from SQL Server to FB that they use (or are recommended to use) Stored
Procs instead of Temp Tables.
Regards
Colin From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Vowles Sent: Monday, 31 May 2004 4:37 p.m. To: NZ Borland Developers Group - Delphi List Subject: 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 martin Sent: Monday, 31 May 2004 4:26 p.m. To: [EMAIL PROTECTED] org. nz Subject: [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 polluting our database with these temporary
tables. Any suggestions greatly appreciated :)
Attention: The information in this email and in any attachments is confidential. If you are not the intended recipient then please do not distribute, copy or use this information. Please notify us immediately by return email and then delete the message from your computer. Any views or opinions presented are solely those of the author. |
_______________________________________________ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
