James Corden
Member
Hi
I have posted this issue at the end of a previous thread but not got a response yet so starting a new thread. I really need to resolve this to continue with my application.
I have a "View Projects" menu option that links to a page that is generated from a view in mysql. This view joins information from a main technology table (techid, techname, date created, inventor foreign key, project manager foreign key, organisation foreign key etc.) with information from sub-tables such as the inventor table (inventor name), project manager table (project manager name), organisation table etc..
The "Add Projects" menu option links to a page that enables me to add new information to the technology table. The form used to add new technologies also takes info from other tables via the select single menu options. So for example if I want to add the project manager details to the technology table for a new project, I select the project manager name from the project manager table but only add the project manager foreign key to the technology table.
I would like to add an "Edit Project" menu option. This would bring up all the details that appear in the "View Project" menu option and enable me to modify these details using the same logic as for the "Add Projects" menu option. I don't understand how I can do this given that the information in the "View Projects" menu option is derived from a mysql view (i.e - is read only).
Thanks
You are not running the last release of DaDaBIK, the release you are running might have bugs and security holes, see the official change log for further information. You can upgrade DaDaBIK here.
In case you want to upgrade to a more powerful edition (from Pro to Enterprise/Platinum, from Enteprise to Platinum) please contact us.
mysql version: 5.7.24
Web server: Apache/2.4.33 (Win64) OpenSSL/1.0.2u mod_fcgid/2.3.9 PHP/7.4.16
Client: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.0.0 Safari/537.36
URL installation: http://localhost:81/Dadabik/
I have posted this issue at the end of a previous thread but not got a response yet so starting a new thread. I really need to resolve this to continue with my application.
I have a "View Projects" menu option that links to a page that is generated from a view in mysql. This view joins information from a main technology table (techid, techname, date created, inventor foreign key, project manager foreign key, organisation foreign key etc.) with information from sub-tables such as the inventor table (inventor name), project manager table (project manager name), organisation table etc..
The "Add Projects" menu option links to a page that enables me to add new information to the technology table. The form used to add new technologies also takes info from other tables via the select single menu options. So for example if I want to add the project manager details to the technology table for a new project, I select the project manager name from the project manager table but only add the project manager foreign key to the technology table.
I would like to add an "Edit Project" menu option. This would bring up all the details that appear in the "View Project" menu option and enable me to modify these details using the same logic as for the "Add Projects" menu option. I don't understand how I can do this given that the information in the "View Projects" menu option is derived from a mysql view (i.e - is read only).
Thanks
Your current DaDaBIK version
You are using DaDaBIK version 11.3-Elba pro, installed on 09-03-2022 (installation code: 178066228c557cae36), the latest version of DaDaBIK is 11.6-Elba released on 14-06-2022You are not running the last release of DaDaBIK, the release you are running might have bugs and security holes, see the official change log for further information. You can upgrade DaDaBIK here.
In case you want to upgrade to a more powerful edition (from Pro to Enterprise/Platinum, from Enteprise to Platinum) please contact us.
System info
PHP Version: 7.4.16mysql version: 5.7.24
Web server: Apache/2.4.33 (Win64) OpenSSL/1.0.2u mod_fcgid/2.3.9 PHP/7.4.16
Client: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.0.0 Safari/537.36
URL installation: http://localhost:81/Dadabik/