One point has always been in my mind regarding web programming and databases.
When I have two tables. For example one table 'employee' and another table 'division'. There is a relation between both. Now I want to Edit 'employee'.
There is a textfield for name etc ... and then I want to have a selection field where I can choose the division this employee works for.
But not the name of the Division is stored in the employees table, but the index (primary key) of it. The name is only displayed for the user.
Is this possible with pcg?
Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I don't know, but foreign key constraint support would be very nice. I'm just starting to figure out object oriented programming, so I'm not sure of my ability to implement it well in the generated code.
for a ui I can see extending the right table selection box on the 'PCG Framework Generate All Code' to include the fields of each table, and a drop down box containing the name of all fields from other tables with a matching/compatible type.
Table
<checkbox> tablename
<checkbox> fieldname constrain to <dropdown>
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
One point has always been in my mind regarding web programming and databases.
When I have two tables. For example one table 'employee' and another table 'division'. There is a relation between both. Now I want to Edit 'employee'.
There is a textfield for name etc ... and then I want to have a selection field where I can choose the division this employee works for.
But not the name of the Division is stored in the employees table, but the index (primary key) of it. The name is only displayed for the user.
Is this possible with pcg?
Thanks
I don't know, but foreign key constraint support would be very nice. I'm just starting to figure out object oriented programming, so I'm not sure of my ability to implement it well in the generated code.
for a ui I can see extending the right table selection box on the 'PCG Framework Generate All Code' to include the fields of each table, and a drop down box containing the name of all fields from other tables with a matching/compatible type.
Table
<checkbox> tablename
<checkbox> fieldname constrain to <dropdown>