🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.sql
Article #11005

Re: Learning Interbase "style"

#11005
From: Wayne Niddery [TeamB]
Date: Sun, 22 Dec 2002 17:22
20 lines
2017 bytes
"Bradley J. Bell" <bradleyjbell@attb3i.c1o2m> wrote in message
news:3e04bb98$1@newsgroups.borland.com...
>
> Another thing I miss about Sybase is temporary tables. Maybe someday in
> IB...

Maybe.

However, depending on what you need to do, the FOR SELECT construct in
stored procs can very often take the place of temp tables needed in other
products - it is a cursor that allows you to perform any needed logic within
the body of the For loop including performing other queries, deciding to
return a row or not, etc.


--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
RADBooks: http://www.logicfundamentals.com/RADBooks/delphibooks.html
"The only reason some people get lost in thought is because it's unfamiliar
territory." - Paul Fix
Technical Details
Message-ID: <3e05f583@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!fr.clara.net!heighliner.fr.clara.net!213.73.101.75.MISMATCH!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <3e041ac9$1@newsgroups.borland.com> <82v80v8k2rn4e05smr4pgqi56bi4lu37so@4ax.com> <3e0492ad$1@newsgroups.borland.com> <aac90vcdkaj3hossvpluv92honk4mkfahk@4ax.com> <3e04bb98$1@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,8dcbdc28ad264e66
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-22 09:40:04 PST
From: "Wayne Niddery [TeamB]" <wniddery@chaff.aci.on.ca>
Newsgroups: borland.public.interbase.sql
References: <3e041ac9$1@newsgroups.borland.com> <82v80v8k2rn4e05smr4pgqi56bi4lu37so@4ax.com> <3e0492ad$1@newsgroups.borland.com> <aac90vcdkaj3hossvpluv92honk4mkfahk@4ax.com> <3e04bb98$1@newsgroups.borland.com>
Subject: Re: Learning Interbase "style"
Date: Sun, 22 Dec 2002 12:22:46 -0500
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 209.50.82.158
Message-ID: <3e05f583@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1040577923 209.50.82.158 (22 Dec 2002 09:25:23 -0800)
X-Authenticated-User: wniddery
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!fr.clara.net!heighliner.fr.clara.net!213.73.101.75.MISMATCH!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail