I created an Grid where insert/update/delete is allowed. The Problem is, the primary key column is not displayed in the grid although I had set the option "show".
Does anyone know whats wrong here?
Kind Regards, Christian
Ok, I´ll do so. Thank you
I'm using a grid for a table that has defined a varchar PK, the user should be able to set the value for new records. What would be the way to do this?
In this case you will need to add an extra column in the grid SQL query and set it to say a text field and user a pre processing procedure to set the primary key value in the CRUD request record type using the value from this new column.
In this new column that is added you should put a PLSQL expression condition on it so it is excluded from the inbuilt processing: NOT fx_p_grid.processing
This way you can re-use the inbuilt processing rather than having to code your own routine. Alternatively you could just use a custom processing procedure to do exactly what you want.
The grid primary key column is always included and hidden. If you would like to show the value please include the column twice with a separate alias. e,g,
, my_pk_column my_pk_column_display