Hi, 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. Regards. George |
Hi George, You can change your datasource query at runtime using 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, |