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]
