looking at this from a database perspective, a browser window represents a given recordset. in applications such as Access, you can easily click on a column and 'sort' the data, what's actually happening behind the scenes is that the base UNSORTED data is being requested into a NEW recordset, with the parameter of "SORT BY BLAH ASCENDING" or whatever.
if you werk with recordsets in code a lot, you'll know how annoying this is when you first start because you think, "hell, i've got the data i want, why can't i just sort it instead of making a new recordset." but that's the point, a sort-order is part of the DEFINITION of a recordset. the way this relates to MapInfo, is that a browser is a representation of a recordset which has been returned through an SQL statement, in order to modify the sort order, you'd need to rewrite the SQL with that inclusion. i dare say on the next version of MI there should probably be an option for this so it becomes more transparent to the user, like Access whereby a newly sorted recordset just re-uses the existing browser window. hope that clears a couple thing up. -----Original Message----- From: Phillips, Frank [mailto:[EMAIL PROTECTED] Sent: Friday, 19 March 2004 3:52 AM To: [EMAIL PROTECTED] Subject: RE: MI-L sorting tables Hi, Carri. I am also a former ArcView user, and I'm shocked by MapInfo's inability to do "on the fly" sorting of browser fields. Yes, there is a way to do this, but you have to do a new SQL query to get your sort. I have not yet found a way to do what I "think" you want to do (that is, the easy way that ArcView can do it on the fly simply by rearranging the order of the rows in a browser window). There must be some technical limitation inside of MapInfo... Frank Phillips Manager of Marketing GIS Vulcan Materials Company (NYSE:VMC) Birmingham, AL, USA -----Original Message----- From: Carri Heisler [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 11:12 AM To: [EMAIL PROTECTED] Subject: MI-L sorting tables Hello all! I am new to MapInfo, so this may sound like a no-brainer. Is it possible to sort tables according to their rows? This is easy is ArcView/ArcMap, but I can't seem to figure it out in MapInfo. Any help would be great! Thanks! Carri --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10935 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10955
