Compact?

[Robert Brenstein]

>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.

Robert