Today I tried to create a new application based on Views. But unfortunately formspider do to permit any DML operation in the screen. The datasource becomes a locked query only object.
90% of my forms are based on views. There are many benefits of using views. And of course database gives instead of triggers to save data in a view.
In oracle forms, on-update, on-insert, on-delete triggers are available for the developer to do his own custom update,insert,delete. And of course, oracle forms do not lock the screen. If formspider team could only facility the developer to manage his own DML process he has more freedom working with formspider. Now he is restricted, in my case almost 90%.
Is there any plan to give this freedom to developer in the near future? I am seriously interested to know.
asked 28 Feb '13, 09:00
No worries. Formspider supports DML on Views. Here is what you need to do:
and voila! Formspider can now issue insert update and delete statements to your View.
If your View is updateable by default, this is all you need to do. If your View is not updatable, you can write Instead Of Triggers for your view to make it updateable.
Hope this helps. Best, Yalim