Compact?

[Robert Brenstein]

>on 2/5/04 10:33 PM, Robert Brenstein at rjb at rz.uni-potsdam.de wrote:
>
>>>  When I delete a field from a table and then add a new field, it goes in
>>>  the "slot" taken up from the field I deleted. If I don't want that to
>>>  happen (for example, I want the new field to go "at the end") how would
>>>  I make that happen? Does compacting the DB from VAPP do that?
>>>
>>>  Thanks,
>>>
>>>  Ken Ray
>>>  Sons of Thunder Software
>>>  Email: kray at sonsothunder.com
>>>  Web Site: http://www.sonsothunder.com/
>>>
>>
>>  Ken, if the field type is compatible, you can just rename the field
>>  and change its type. Otherwise, the simplest way is to dump xml,
>>  arrange fields in a desired order, then create a new database from
>>  that dump.
>
>Actually not so simple change order in XML file if records present here
>
>--
>Best regards,
>Ruslan Zasukhin      [ I feel the need...the need for speed ]

In general yes, but in RunRev one can write a script to rearrange all 
as desired. But you are right, Ruslan, that Ken should rethink why he 
needs to depend on specific order. Not a good idea usually.

Robert