Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 6 of 6 total |
RowID or other counter |
Wed, Aug 5 2009 11:54 AM | Permanent 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 PM | Permanent Link |
Roy Lambert NLH Associates 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 PM | Permanent 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 AM | Permanent 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 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Matthew
DIdn't you try RUNSUM? Roy Lambert |
Thu, Aug 6 2009 1:23 PM | Permanent 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/ |
This web page was last updated on Friday, March 29, 2024 at 03:30 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |