Dear Ben
... or add 1 to the highest number and sort in reverse order. The
highest will always be at the top and you will not need to demote.
Bob
In message <[EMAIL PROTECTED]>, Jeff
James <[EMAIL PROTECTED]> writes
>Ben,
>
>You could add a Priority column into your table. You could store a default
>value -- something high like 1000 or so, depending on how many records you
>have -- in all the rows. Then, to "promote" a record, drop a 1 in the
>Priority column, and create a query sorting by that column in ascending
>order.
>
>Only trick is, if you only want to have one 1 in the table, you have to
>"demote" the old 1's to 2's or something.
>
>Hope this helps.
>
>Jeff James
>Vice President
>Sage Software, Inc.
>3423 Piedmont Road NE
>Suite 550
>Atlanta, GA 30305
>www.sagesoft.com
>Phone: 404.262.7478 Ext. 12
>Fax: 404.832.3366
>
>-----Original Message-----
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]]On Behalf Of Humphrey, Ben
>Sent: Monday, September 27, 1999 7:48 PM
>To: '[EMAIL PROTECTED]'
>Subject: MI promoting records
>
>
>Anybody know of a way to promote records in a mapbasic table? I want to
>select a specific row and move it so that it is the first row in a table.
>
>thanks,
>Ben
>----------------------------------------------------------------------
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>
>----------------------------------------------------------------------
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
--
Bob Young
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
