I noticed that when creating records in a table, if a different datasource is used (for example using the datasource "table1" to i/u/d and "vw_table1" to list), only the datasource involved in the creation is updated. This caused me a problem as the combobox list was outdated. In order to solve it, I created an action to refresh the listDatasource of the combobox, called on the focusGain of the combobox. But there is no api function to get it.

I created my own function by directly querying the formspider schema :

function getComboboxDatasource(pCombobox in varchar2) return varchar2 as cursor c1 is select a.name_tx from formspider.t_bdf_applicationsession s, formspider.t_bdf_panel p, formspider.t_bdf_paneldtl d, formspider.t_bdf_dbobjectaccess a where s.bdf_applicationsession_oid = api_application.getID and p.bdf_application_oid = s.bdf_application_oid and p.name_tx = substr(pComboName, 1, instr(pComboName, '.')-1) and d.bdf_panel_oid = p.bdf_panel_oid and d.name_tx = substr(pComboName, instr(pComboName, '.')+1) and a.bdf_dbobjectaccess_oid = d.bdf_dbobjectaccessusg_oid; fDS varchar2(100); begin open c1; fetch c1 into fRet; close c1; return fRet; end;

Is this query correct?

asked 06 Sep '12, 03:43

Vlisidis%20Akis's gravatar image

Vlisidis Akis
163119
accept rate: 5%


Hi Vlisidis,

Yes, your query is correct. You may use it. We will also add new API in next release(1.2) to get listDataSource property of the component.

Regards

link

answered 06 Sep '12, 04:18

Samet%20Basaran's gravatar image

Samet Basaran
1372
accept rate: 24%

Hi Vlisidis,

Since version 1.2, you can use api_component.getListDatasource API to get the listDataSource property of the component.

Regards, Ibrahim

(21 Dec '12, 09:22) Ibrahim Sand... ♦♦
Your answer
toggle preview

Follow this question

By Email:

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

By RSS:

Answers

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

Tags:

×30
×6

Asked: 06 Sep '12, 03:43

Seen: 1,300 times

Last updated: 21 Dec '12, 09:22


© Copyright Gerger 2017