Just remember that the rowid is unique in each table as well as queries, so there is no easy way to convert a rowid from a query/selection to the corresponding rowid in the base table.
But as I remember this issue has been discussed some time ago on this list and a solution using SelChangedHandler was proposed. Anyway selecting records by their rowid is a fast way to select certain records in a table, and it's easy to use as shown below. Peter Horsb�ll M�ller GIS Developer COWI A/S - Geografisk Information & IT Rug�rdsvej 55 DK 5000 Odense C Tel +45 6313 5013 Direct +45 6313 5008 Mobil +45 2270 4308 Fax +45 6313 5090 -----Original Message----- From: Simmonds, Ashley (PTB) To: 'MapInfo-L (E-mail) Sent: 04-02-03 00:47 Subject: RE: MI-L select by row number easy, selecting row numbers 2 through 8: ################### Select * from YourTable where RowID > 1 and RowID < 10 ################### ash -----Original Message----- From: Windeler, David [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 4 February 2003 6:19 AM To: 'MapInfo-L (E-mail) Subject: MI-L select by row number To whom it may concern: I am wondering if it is possible to select items from a table based on their row numbers? I am aware that you can retrieve the row-ID value of a selected object but I wish to write an SQL statement that selects a series of items based on a row number range. Is this possible? David Windeler Hons. BSc. Geo, GIS Apps. Specialist GIS Technician / Applications Specialist City Of Vaughan Engineering Department 2141 Major Mackenzie Drive Vaughan, Ontario L6A 1T1 Tel. (905) 832-8525 Ext. 8747 Fax (905) 832-6145 E-mail [EMAIL PROTECTED] http://www.city.vaughan.on.ca --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5341 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5345
