Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Re: [yogi] Changing Field Order in Links SQL???

Quote Reply
Re: [yogi] Changing Field Order in Links SQL??? In reply to
I read a lot of forum threads about this some time ago and it did seem that you can't change the position by editing the def file - it would be very nice if you could! You could always add a new column where you want it and copy all the info from the old column into it using something like

UPDATE Links SET New_Column_Name = Old_Column_Name

in the SQL Monitor. My SQL knowledge isn't very good so someone may need to correct this. Also, you won't be able to give it exactly the same name as the existing column using this method.

Laura.
The UK High Street
Subject Author Views Date
Thread Changing Field Order in Links SQL??? Jonze 3106 Jul 31, 2002, 1:34 PM
Thread Re: [Jonze] Changing Field Order in Links SQL???
afinlr 3045 Jul 31, 2002, 3:42 PM
Thread Re: [afinlr] Changing Field Order in Links SQL???
Jonze 3036 Jul 31, 2002, 4:16 PM
Thread Re: [Jonze] Changing Field Order in Links SQL???
Jonze 3030 Jul 31, 2002, 4:38 PM
Thread Re: [Jonze] Changing Field Order in Links SQL???
pugdog 3028 Jul 31, 2002, 11:34 PM
Thread Re: [pugdog] Changing Field Order in Links SQL???
yogi 3071 Aug 1, 2002, 12:17 AM
Thread Re: [yogi] Changing Field Order in Links SQL???
afinlr 3012 Aug 1, 2002, 1:15 PM
Post Re: [afinlr] Changing Field Order in Links SQL???
Jonze 3069 Aug 2, 2002, 3:44 PM
Post Re: [afinlr] Changing Field Order in Links SQL???
yogi 3034 Aug 2, 2002, 9:46 PM
Post Re: [yogi] Changing Field Order in Links SQL???
pugdog 2980 Aug 4, 2002, 8:19 PM