| View previous topic :: View next topic |
| Author |
Message |
maxou33
Newbie
Joined: 29 Jul 2010
Posts: 2
|
 Posted: Thu Jul 29, 2010 3:32 pm Post subject: Modify Table [SOLVED] |
 |
|
Hi,
I am trying to alter a table (Tables pane > right click on the table > modify) and rearrange the different fields.
The problem is that I cannot add a field between 2 others. When I do this, the new field is added at the bottom of the fileds list.
Is there any way to add a field between 2 others ?
(I know it's completely irrelevant to have a field before another , but it's just for my table to be clearer when I add records manually.)
Many Thanks
MAx
Last edited by maxou33 on Thu Jul 29, 2010 4:03 pm; edited 1 time in total |
|
| Back to top |
|
 |
Sliderule
Super User
Joined: 29 May 2004
Posts: 2474
Location: 3rd Rock From The Sun
|
| Posted: Thu Jul 29, 2010 3:53 pm Post subject: |
|
|
MAx:
You asked:
| MAx wrote: | | Is there any way to add a field between 2 others ? |
Please see / read the link below:
http://www.oooforum.org/forum/viewtopic.phtml?t=70021
I hope this helps, please be sure to let me / us know.
Sliderule
Thanks to add [Solved] in your first post title ( edit button ) if your issue has been fixed / resolved. |
|
| Back to top |
|
|
maxou33
Newbie
Joined: 29 Jul 2010
Posts: 2
|
| Posted: Thu Jul 29, 2010 4:02 pm Post subject: |
|
|
oh I see
I didn't know i needed to write SQL to do this.
(well i can no longer write SQL queries anyway as I've become a casual user years ago..: ) )
Many thanks for the tip |
|
| Back to top |
|
|
|
