I really do not understand the usefulness of such a procedure and I will not discuss. But I am sure of one thing: there is no "blank row" in MI; there might be rows with only "" or 0, but all the variables have a value that is defined. Any use of the whole table would give erroneous results (counts, labels, thematics...) as these "blank" cases cannot be differentiated from the regular ones with the use of "undefined" values.
Jacques Paris e-mail [EMAIL PROTECTED] MapBasic-MapInfo support http://www.paris-pc-gis.com -----Original Message----- From: Steve McArthur [mailto:[EMAIL PROTECTED] Sent: 2-Apr-04 07:22 To: [EMAIL PROTECTED] Subject: RE: MI-L editing rows Hi All One trick I use to get a 'row back' is to number a column with the rowid and then add a blank row. The new row is given a number that is between the two rows where the deleted row would have been (eg 10.5) and the whole table is then reordered by this field. You then end up with a blank row where the deleted row was. Steve McArthur LLPG Manager London Borough of Hackney -----Original Message----- From: Peter Horsb�ll M�ller [mailto:[EMAIL PROTECTED] Sent: 02 April 2004 13:17 To: Kiersten Taylor; [EMAIL PROTECTED] Subject: RE: MI-L editing rows Hi Kiersten You can't. The grey row indicates that there once was a record here, but it has now been marked as deleted. This means that the record still exists, and that it will not be removed until you pack your table. And you are right that packing the table might result in a relabling. A big problem is that if you have userdefined labels - that is labels that have been positioned manually - they are stored in the workspace with only a connection to the rowid. So if you delete one or several records and pack the table. Every record below the deleted record(s) have had their ROWID recalculated. This will also result in the problem that the ROWID in the workspace will link to wrong records, and therefor lable with wrong values. Userdefined labels are not to be trusted, and should be used as little as possible. I know this is no help ofr you, just information. Sorry that I have no good news this time Peter Horsb�ll M�ller GIS Developer Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk -----Original Message----- From: Kiersten Taylor [mailto:[EMAIL PROTECTED] Sent: Friday, April 02, 2004 1:50 PM To: [EMAIL PROTECTED] Subject: MI-L editing rows Thank you for all your quick responses, but I am concerned that packing the table will re-label everything. How do I re-enter data into these spaces? LONDON BOROUGH OF REDBRIDGE DISCLAIMER This e-mail contains proprietary confidential information some or all of which may be legally privileged and/or subject to the provisions of privacy legislation. It is intended solely for the addressee. If you are not the intended recipient, an addressing or transmission error has misdirected this e-mail; you must not use, disclose, copy, print or disseminate the information contained within this e-mail. Please notify the author immediately by replying to this e-mail. Any views expressed in this e-mail are those of the individual sender, except where the sender specifically states these to be the views of the London Borough of Redbridge. This e-mail has been scanned for all viruses and all reasonable precautions have been taken to ensure that no viruses are present. The London Borough of Redbridge cannot accept responsibility for any loss or damage arising from the use of this e-mail or attachments. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11243 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11245 London Borough of Hackney may exercise its right to intercept any communication on its networks - for more information see http://www.hackney.gov.uk/council/data/email_disclaimer.htm --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11246 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11248
