Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 5 of 5 total

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