Re: returning a sequence no in a select statement

Article View: borland.public.interbase.opensource

Article #280

Back to borland.public.interbase.opensource Previous Next

#280

From: Dan Palley
Date: Wed, 29 Jun 2005 18:47

22 lines
1603 bytes

"FrankW" <nospam@nospam.com> wrote in message 
news:42c2003f@newsgroups.borland.com...
> Hi,
>
> is there way to return a seq in a select, like this:
>
> select  name from doc where docno = ?docno
>
> I like to have a seq number indicating the row number so that i can 
> display it in a grid:
>
> 1   Angel
> 2   Frank
>
> I know it can be done using a stored procedure, but is this possible with 
> select?

I don't know of a way to do it in a select, but can't you simply do it 
client-side?  If you're using a clientdataset to hold the query results, 
simply look at clientdataset.recno as the sequence number.

Dan

Technical Details

Message-ID: <42c2ecce$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!newshub.sdsu.edu!peer01.west.cox.net!cox.net!pd7cy1no!shaw.ca!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

References: <42c2003f@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 106772,8556ea0b80df3559
X-Google-Attributes: gid106772,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Dan Palley" <dan@trams.com>
Newsgroups: borland.public.interbase.opensource
References: <42c2003f@newsgroups.borland.com>
Subject: Re: returning a sequence no in a select statement
Date: Wed, 29 Jun 2005 11:47:43 -0700
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 157.238.54.69
Message-ID: <42c2ecce$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1120070862 157.238.54.69 (29 Jun 2005 11:47:42 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!newshub.sdsu.edu!peer01.west.cox.net!cox.net!pd7cy1no!shaw.ca!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Reply to Parent Message