Article View: borland.public.interbase.opensource
Article #254Re: Is there something equivalent to a "Find nearest" in SQL, IB6.0.2.0?
From: Dan Palley
Date: Wed, 18 May 2005 16:41
Date: Wed, 18 May 2005 16:41
25 lines
1745 bytes
1745 bytes
Sorry, I missed the part of your email where you said you were on 6.0.2.0. You can simulate the ROWS construct using a stored procedure. Dan "Red" <nospam_kandw321@icrossroads.com> wrote in message news:428b4e07.133176667@newsgroups.borland.com... > Dan, there's no "rows" qualifier for the SELECT command in IB 6.0.2.0 > > ...hmm... > > >> >>Select * from table1 where fld_1 <=2.99999999 order by fld_1 desc rows 1 >> >>and >> >>Select * from table1 where fld_1>=2.9999999 order by fld_1 asc rows 1 >> >>Dan > > > > >
Technical Details
Message-ID:
<428b704f$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!newshub.sdsu.edu!elnk-nf2-pas!elnk-pas-nf1!newsfeed.earthlink.net!pd7cy1no!shaw.ca!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!news-in.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mailReferences:
<428a5b61.71058216@newsgroups.borland.com> <428a60f3$1@newsgroups.borland.com> <428a630b.73020187@newsgroups.borland.com> <428a6d3e$1@newsgroups.borland.com> <428b4e07.133176667@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 106772,8899b8536c5e6b11 X-Google-Attributes: gid106772,public X-Google-Language: ENGLISH,ASCII-7-bit From: "Dan Palley" <dan@trams.com> Newsgroups: borland.public.interbase.opensource References: <428a5b61.71058216@newsgroups.borland.com> <428a60f3$1@newsgroups.borland.com> <428a630b.73020187@newsgroups.borland.com> <428a6d3e$1@newsgroups.borland.com> <428b4e07.133176667@newsgroups.borland.com> Subject: Re: Is there something equivalent to a "Find nearest" in SQL, IB6.0.2.0? Date: Wed, 18 May 2005 09:41:53 -0700 Lines: 27 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Original NNTP-Posting-Host: 157.238.54.69 Message-ID: <428b704f$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1116434511 157.238.54.69 (18 May 2005 09:41:51 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!newshub.sdsu.edu!elnk-nf2-pas!elnk-pas-nf1!newsfeed.earthlink.net!pd7cy1no!shaw.ca!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!news-in.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail