Article View: borland.public.interbase.sql
Article #11018Re: Learning Interbase "style"
From: Bradley J. Bell
Date: Tue, 24 Dec 2002 03:00
Date: Tue, 24 Dec 2002 03:00
40 lines
2584 bytes
2584 bytes
Wayne, This is my point. The Sybase way of doing things is different than the IB's way. There are a lot of books about Sybase, none about IB. I've been learning a lot from groups like this and seaching Google, but it is time consuming. And yes, I'm starting to learn the For Select construct in IB can be very powerful. I've still have lots to learn. Thanks for the input. Bradley "Wayne Niddery [TeamB]" <wniddery@chaff.aci.on.ca> wrote in message news:3e05f583@newsgroups.borland.com... > "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:
<3e07cdea$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3e041ac9$1@newsgroups.borland.com> <82v80v8k2rn4e05smr4pgqi56bi4lu37so@4ax.com> <3e0492ad$1@newsgroups.borland.com> <aac90vcdkaj3hossvpluv92honk4mkfahk@4ax.com> <3e04bb98$1@newsgroups.borland.com> <3e05f583@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-23 19:09:10 PST From: "Bradley J. Bell" <bradleyjbell@attb3i.c1o2m> 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> <3e05f583@newsgroups.borland.com> Subject: Re: Learning Interbase "style" Date: Mon, 23 Dec 2002 21:00:59 -0600 Lines: 42 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: 12.249.164.138 Message-ID: <3e07cdea$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1040698858 12.249.164.138 (23 Dec 2002 19:00:58 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail