Not getting view and edit links on a duplicated table

PHPMaker General Discussion (PHPMaker)
1

I am making a duplicate table for archiving data using

CREATE TABLE `new_table` AS
SELECT * FROM `original_table` WHERE `some condition exists`;

ALTER TABLE `new_table`
ADD PRIMARY KEY (`id`),
MODIFY COLUMN `id` INT NOT NULL AUTO_INCREMENT;

the problem is that when I sync my project and generate the code I don't get any of the normal view, edit, delete links.

Any idea why? And how to fix?

TIA - Greg

2

After you sync your project with your database, check if the primary key of the new table is detected (it should be), if not, make sure you select the primary key in Field Setup page yourself. If no primary key, there are no view/edit/delete pages (because the record cannot be retrieved).

3

I did check that the ID was the Primary Key (it was). I restarted the program, and ran the script from scratch and now it works. Thanks