We have been developing in Oracle forms. In forms we have a facility to change the source table and target table at runtime. Is there any similar facility in formspider? We have a single form which uses four different tables with the same structure (Quotation, Sales Order, Delivery Order and Invoice). The benefit is that we need to create and maintain only a single form.

In the same way, in formspider, if we can change source and target datasources at runtime, we need to use only a single group of panels to manage these various documents which uses different tables with same structure.

Is there any way we can incorporate this in formspider? Please advice.



asked 04 Jun '15, 00:44

grajan777's gravatar image

accept rate: 10%

Hi George,

You can change your datasource query at runtime using api_datasource.setDefaultQuery API, which enables you to change the source table.

To change the target table, you can create a datasource definition based on a "proxy" view and make DMLs for desired target table in the instead of triggers of this view based on some custom parameters that you will set before your commit statement.

Hope this helps,


answered 06 Jun '15, 09:50

Ibrahim%20Sandalli's gravatar image

Ibrahim Sand... ♦♦
accept rate: 25%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 04 Jun '15, 00:44

Seen: 1,816 times

Last updated: 06 Jun '15, 09:50

© Copyright Gerger 2017