I want to build a form based on a view.
I’ve created the view and verified that it works in plain old SQL*Plus.
I’ve marked a single column in the view as the ‘identity’ column in Servoy so it will be able to use the view without complaining about ‘no primary key’.
I create a form (a simple list) and put the columns from the view on the form.
I mark the columns as editable (so the user can key in something when they place the form into find mode).
In the ‘onShow’ event for the form I set the controller.readOnly to true (as this is a view only form - there is no data entry or editing done here at all - just viewing and searching).
When I put the form into ‘find’ mode I can’t type anything into any of the fields on the form.
If I comment out the ‘controller.readOnly = true’ in the ‘onShow’ event, run the form and place it into ‘find’ mode I can type into the fields just fine but this also means the fields are now open for editing. I don’t want people editing… just viewing but with the ability to place the form into find mode, specify some search criteria, then search for it.
What am I missing here ?
Any thoughts?
EDIT… a little more information… the button that invokes the ‘find’ mode is on my ‘main’ form (my list is in a tab contained on the ‘main’ form). The ‘find’ button invokes a global method that interrogates which form it came from and places that form’s controller into find mode. In this case the form that invoked the find is my ‘main’ form - that form’s controller gets put into ‘find’ mode which then causes my ‘list’ to go into find mode as well since the ‘main’ form and ‘list’ form source the same view - there is no relation between the ‘main’ form and the ‘list’ form.
Note… If I place the find/search logic in the ‘list’ form locally and place the ‘list’ controller into find/search everything works just fine.
Note… If I place the find/search logic in the list’ form locally and place the ‘main’ controller into find/search it does not work (‘list’ looks like its in find mode but I can’t type into the columns)