Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread RowID or other counter
Wed, Aug 5 2009 11:54 AMPermanent Link

Is there a way to get the index of the row in DBISAM SQL? I've tried RecordID, but
it is giving me values of 85,86,87 etc, but I need this to be the 1,2,3 or 0,1,2
sequence.

If this is not possible, is there a function or something that will give me a
sequential index?

Many thanks,

/Matthew Jones/
Wed, Aug 5 2009 12:41 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Matthew


I think RUNSUM(1) in the query should generate what you want, but its been so long and its from memory

Roy Lambert [Team Elevate]
Wed, Aug 5 2009 1:02 PMPermanent Link

"Robert"

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:B9E1BB3A-021A-4BC6-9EA0-660312AB45F8@news.elevatesoft.com...
> Matthew
>
>
> I think RUNSUM(1) in the query should generate what you want, but its been
> so long and its from memory

   select any_unique_field, runsum(1) from atable group by any_unique_field

Robert

Thu, Aug 6 2009 9:10 AMPermanent Link

And if there is no "RowID" column, is it possible to add a calculated field to the
result of a query, and work out something in that?

My purpose is to feed data into a TeeChart graph, but the Y values need to be in a
simple sequence. I'll maybe remove that parameter and see if it manages without!

[later]

Hmm, indeed, that seems to solve it. I think I'd still like to know how to do it
properly though. Or even if ElevateDB does this.

/Matthew Jones/
Thu, Aug 6 2009 10:02 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Matthew

DIdn't you try RUNSUM?


Roy Lambert
Thu, Aug 6 2009 1:23 PMPermanent Link

For some reason I didn't get your message when I downloaded messages today. Only
just got it now - will experiment with that.

/Matthew Jones/
Image