Article View: borland.public.interbase.opensource
Article #251Re: Is there something equivalent to a "Find nearest" in SQL, IB 6.0.2.0?
From: Aage Johansen
Date: Tue, 17 May 2005 21:23
Date: Tue, 17 May 2005 21:23
23 lines
1867 bytes
1867 bytes
Red wrote: > This seems a lonely part of the Borland NG scene. Thanks to the > people who cruise it once in a while and answer the guys like me who > are still working quite happily with IB 6.0.2.0. I find it fast, > robust, and simple to use. > > Sowanyway... anyone got an answer to my Q? > > I want the one single nearest record, whether it be just above or just > below an imaginary record that *would* have been the exact match. > > <=, >=, even "between" won't really do the trick. Hmmm..... > > Thanks in advance. b.p.i.general and b.p.i.sql (and others) are open, IB/6 is OnTopic (AFAIU), and with healthy traffic. As for your question, could you give some examples of what you want. -- Aage J.
Technical Details
Message-ID:
<428a60f3$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!border1.nntp.dca.giganews.com!nntp.giganews.com!pd7cy2so!shaw.ca!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mailReferences:
<428a5b61.71058216@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 Date: Tue, 17 May 2005 23:23:52 +0200 From: Aage Johansen <aagjohan@offline.no> Organization: Marching and Chowder Society User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: borland.public.interbase.opensource Subject: Re: Is there something equivalent to a "Find nearest" in SQL, IB 6.0.2.0? References: <428a5b61.71058216@newsgroups.borland.com> In-Reply-To: <428a5b61.71058216@newsgroups.borland.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 85.165.14.88 Message-ID: <428a60f3$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1116365043 85.165.14.88 (17 May 2005 14:24:03 -0700) Lines: 23 Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!border1.nntp.dca.giganews.com!nntp.giganews.com!pd7cy2so!shaw.ca!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail