Hi,

I was wondering if (how) it is possible to re-order my DB fields without having to delete and re-add (thus losing data).

Thanks.

This has been discussed several times.

The _ONLY_ way is to export the data, recreate the table, and re-import it. You just can't move fields around. (In most databases this makes no difference, in Links, because of the default order of the .def file for presenting the fields, it does. There may be a fix for this in the next version, if not, I know Jerry was interested in making one.)

http://www.gossamer-threads.com/...=&vc=1#Post68276

i did end up making one.. i added another field in the hash inside of the .def files and in DBSQL.pm i added some code that allowed it to be sorted in the build_html_record_form subroutines.. it doesn't actually do anything to the database.. just it changes the sort for the forms.. also.. there is a couple of mods in editor.cgi so you can edit the order..

if your interested.. email me..

also.. the new username is cause i probably won't be going by widgetz much longer and i want to get this account past 'stranger' status..

Jerry Su
email@jerrysu.com
http://www.jerrysu.com/