Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 5 of 5 total |
ElevateDB - RecNo still supported? |
Mon, Mar 17 2008 6:33 PM | Permanent Link |
Bob | Hi, We are using ElevateDB 1.07 Build 3. Is RecNo still Supported? |
Tue, Mar 18 2008 12:04 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Bob,
<< We are using ElevateDB 1.07 Build 3. Is RecNo still Supported? >> No. EDB does not support returning a logical record number via the RecNo property like DBISAM did. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Oct 2 2015 6:15 AM | Permanent Link |
Antonio Marques | Is there a way of getting the current record number on a query?
"Tim Young [Elevate Software]" wrote: Bob, << We are using ElevateDB 1.07 Build 3. Is RecNo still Supported? >> No. EDB does not support returning a logical record number via the RecNo property like DBISAM did. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Oct 2 2015 10:12 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Antonio,
<< Is there a way of getting the current record number on a query? >> I'm not sure what you're asking. Are you looking for just an incrementing number attached to each result set row ? If so, then you can use RUNSUM() for that: SELECT RUNSUM(1), * FROM customer GROUP BY custno The only catch is that you will absolutely need a GROUP BY clause on the primary key columns of the driver table. Tim Young Elevate Software www.elevatesoft.com |
Fri, Oct 2 2015 12:04 PM | Permanent Link |
Antonio Marques | Thank you!
I did it the old fashion way, on query.next, incrementing a variable. Tim Young [Elevate Software] wrote: Antonio, << Is there a way of getting the current record number on a query? >> I'm not sure what you're asking. Are you looking for just an incrementing number attached to each result set row ? If so, then you can use RUNSUM() for that: SELECT RUNSUM(1), * FROM customer GROUP BY custno The only catch is that you will absolutely need a GROUP BY clause on the primary key columns of the driver table. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |