Welcome, Guest
Username: Password: Remember me

TOPIC: Change ID primary key name

Change ID primary key name 07 Feb 2012 21:09 #1194

  • M4d3L
  • M4d3L's Avatar
  • Offline
  • Senior Member
  • Posts: 45
  • Thank you received: 7
  • Karma: 3
is it possible to be able to change the name of the incremental field (ID)?

for some project, I have to integrate an admin to an already done database. and sometime, bad developper give some weird name to the incremented field and most of time we cant refactor the database for X raison.

So it will be nice to be able to choose the name to give to that field.
The administrator has disabled public write access.

Change ID primary key name 13 Jun 2012 16:13 #2556

  • dares
  • dares's Avatar
  • Offline
  • Junior Member
  • Posts: 37
  • Thank you received: 4
  • Karma: 2
It is not possible to change name of ID field in the database.
73,
Miro

Cook saves your time and make your life easier.
The administrator has disabled public write access.

Change ID primary key name 15 Jun 2012 05:01 #2565

  • admin
  • admin's Avatar
  • Online
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 984
  • Karma: 140
It will be possible in future.
I am currently working on this.

V2.0 will maybe handle this. (not sure yet, but the structure is almost ready)
Coding is now a piece of cake
The administrator has disabled public write access.

Re: Change ID primary key name 25 Jul 2012 12:51 #2883

  • ipagan
  • ipagan's Avatar
  • Offline
  • New Member
  • Posts: 5
  • Karma: 0
Great!! When version 2.0 is available?
The administrator has disabled public write access.

Re: Change ID primary key name 25 Jul 2012 19:57 #2893

  • ipagan
  • ipagan's Avatar
  • Offline
  • New Member
  • Posts: 5
  • Karma: 0
And too... If it is posible, allow column field name in capital letters, for example "ArtistName", cook, change to "artistname" automatically. I'm trying to make a proyect in cook, and connect this to external Db using the identical fields and properties to tables.

It is possible? I can't rename my table fields, is a project in production. But when I make a copy of individual table and rename fields to make a test, the cook component work fine! Only I need to wait to Cook allow a rename id field, and capital letters in all fields.

Thanks, and I hope :whistle:
The administrator has disabled public write access.

Re: Change ID primary key name 29 Jul 2012 09:40 #2922

  • BTB300
  • BTB300's Avatar
  • Offline
  • Moderator
  • Posts: 414
  • Thank you received: 130
  • Karma: 46
I thought you can change the field name to include capitals after it is saved for the first time
as for the ArtistName im sure in the the past i have done it this way

- create field name
- save the field
- cook changes it to lowercase
- edit the field name
- adjust field name using upper case where needed
- save the field again
Last Edit: 29 Jul 2012 09:40 by BTB300.
The administrator has disabled public write access.
The following user(s) said Thank You: ipagan

Re: Change ID primary key name 04 Aug 2012 07:13 #2977

  • ipagan
  • ipagan's Avatar
  • Offline
  • New Member
  • Posts: 5
  • Karma: 0
Thanks!!!! I hope the j-cook update to rename primary key Id now.

:)
The administrator has disabled public write access.
Time to create page: 0.107 seconds

Get Started