TOPIC:

Change Primary Key 27 Mar 2012 08:52 #1739

coopdb Topic Author Offline New Member Posts: 5 Thank you received: 0	How can I change the primary key for a table in my component? By default its the "id" field, but I have an existing table from another component where the primay key is not named "id"
	Please Log in or Create an account to join the conversation.

Re: Change Primary Key 29 Mar 2012 02:49 #1774

griiettner Offline Senior Member Posts: 73 Thank you received: 12	I think this is done manually after you build your component... At the moment, Cook does not have integration with 3rd party components Paulo Griiettner
	Please Log in or Create an account to join the conversation.

Re: Change Primary Key 29 Mar 2012 05:24 #1775

coopdb Topic Author Offline New Member Posts: 5 Thank you received: 0	Yes, I know. I have changed all the ID vars to the new ID name in my component, but that does not had an effect. I see the entrys but the checkbox value in the gridview is always empty.
	Please Log in or Create an account to join the conversation.

Re: Change Primary Key 30 Mar 2012 08:56 #1791

admin Offline Administrator Chef Posts: 3711 Thank you received: 986	No, you cannot. Is it a joomla component ? Coding is now a piece of cake
	Please Log in or Create an account to join the conversation.

Re: Change Primary Key 30 Mar 2012 18:37 #1800

coopdb Topic Author Offline New Member Posts: 5 Thank you received: 0	Its the article and category table from Mosets Tree. I have now added the id field in the table and updated the id with the primary key id, when I add a new entry. That works for me, but its not a good solution.
	Please Log in or Create an account to join the conversation.

Re: Change Primary Key 05 Apr 2012 18:41 #1909

admin Offline Administrator Chef Posts: 3711 Thank you received: 986	I think, you can change it in the table file first. And then, change all the joined SQL requests that are based on id. But maybe on other places too. It should be possible properly... Coding is now a piece of cake
	Please Log in or Create an account to join the conversation.

Page:
1

Forum

Support forum

Coding inside your component

Change Primary Key

Time to create page: 0.068 seconds

“

”

I found "cook" two days ago. Played around with it for a day and then within a day got rid of two legacy applications in IBM Lotus Domino Notes and replaced them with "cook". It was really easy. A piece of cake. Actually it was even easier than cooking. Cooking involves more work than developing with "cook". What can I say about "cook"? Great application great price for what it delivers great forum with a lot of information and fast responses active and friendly community fast forward moving development cycle So what should I say "Monsieur Le Cook"? Keep the good work going it will lead to success. Having become a paying member in the words of Edith Piaf may I say ..... non rien de rien ... je ne regrette rien. Vive La France.
FK (JED)