Hi team, i have a situation with a complex view consisting of two queries with a union all. The view has an instead-of-trigger so i can update columns. In sqlplus this works perfectly. However, in Formspider there is an issue. Because of the union all the Database Dictionary defines all columns as NULL. Even when they are 100% absolutely NOT NULL. Consequence of this is that the Formspider IDE can not create the comboboxes for the primary key and concurrency column. And when there is no primary key, updates are ignored. Is there a work-around to make this view updateable in Formspider? Kind regards, Jan Willem |
Hi, Open FS IDE->datasource definition (your datasource definition), and try check column required. Example : https://www.dropbox.com/s/1kosva6qx4ranho/example.PNG?dl=0 |