Claudine, There is an article on www.razzak.com/fte by Razzak written on August 3, 2008 called "Creating Virtual Auto-Number in Views" that should help you resolve what you are trying to do.
Take a look and let us know. Jan -----Original Message----- From: "Claudine Robbins" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 21 Apr 2009 12:39:39 -0500 Subject: [RBASE-L] - Re: Create Sequence Numbering on the fly Bill, I don’t know. I’m just trying to make a list easier to refer to. The view is a sub-report in a sub-report. When my user sees the list, he might want to say: “Can you check on item 5?” instead of having to physically count the rows manually. Your variable idea gets me to thinking that I could make that view into a temp table, add a field and autonum so I’ll try that. Claudine From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: Tuesday, April 21, 2009 12:30 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Create Sequence Numbering on the fly 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
