Claudine, How do you know, from the data, what order the sequence numbers should come in? Why not use a report, and increment a variable?
Bill On Tue, Apr 21, 2009 at 10:26 AM, Claudine Robbins < [email protected]> wrote: > Bill, > > > > Thank you for your quick response. > > > > I have a simple view of one text field in a table with a where clause and > I’d like for the result to read > > 1 – The birds are on the feeder > > 2 – The squirrels are chasing each other > > 3 – The cat is sleeping > > Etc… > > > > I seem to remember that you had a select (perhaps even with a union to a > dummy table) in order to do this that’s why I tried to look it up in ADVSQL. > > > > Claudine** > > > ------------------------------ > > *From:* [email protected] [mailto:[email protected]] *On Behalf Of *Bill > Downall > *Sent:* Tuesday, April 21, 2009 12:13 PM > *To:* RBASE-L Mailing List > *Subject:* [RBASE-L] - Re: Create Sequence Numbering on the fly > > > > Claudine, > > > > I'm listening, but not remembering completely. And my ancient copy of that > book is 1500 miles away from me. What exactly do you want to do? See > sequence numbers on a SELECT from a table that doesn't have sequence > numbers? > > > > Bill > > On Tue, Apr 21, 2009 at 9:45 AM, Claudine Robbins < > [email protected]> wrote: > > With a plug for Bill Downall and David Blocker’s excellent “Advanced SQL” > book which, to this day, remains a very valuable resource and is not > routinely included in the resources for R:BASE… I’ve searched for an hour, > both in the book and in my email Rbase-l archives… > > > > I’m looking for that special UNION statement (Bill, are you there?) to > create a sequence numbering on the fly. > > > > TIA, > > > > Claudine > > > > >
