returning a sequence no in a select statement

Article View: borland.public.interbase.opensource

Article #279

Back to borland.public.interbase.opensource Previous Next

#279

From: FrankW
Date: Wed, 29 Jun 2005 01:58

18 lines
1174 bytes

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?

Thanks,

Frank

Technical Details

Message-ID: <42c2003f@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 106772,8556ea0b80df3559,start
X-Google-Attributes: gid106772,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "FrankW" <nospam@nospam.com>
Newsgroups: borland.public.interbase.opensource
Subject: returning a sequence no in a select statement
Date: Tue, 28 Jun 2005 18:58:22 -0700
Lines: 20
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: 222.126.66.71
Message-ID: <42c2003f@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1120010303 222.126.66.71 (28 Jun 2005 18:58:23 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail