I have a question about the repeatPanel in Formspider Mobile. I'm using this to display a number of rows. In each row there is a label displayed and a button the user can click on. Furthermore, each row has a hidden cell in which the ID of the entry is stored. What I want to do is when a user clicks on the button I want to execute a query for which I need the hidden ID as a bind variable and execute the query. I tried it by using a name for the text label of the hidden id in the cell and tried to get the content by m_component.getValueNR. I always get the error: ORA-06502: PL/SQL: numeric or value error: NULL index table key value

Is it a problem because I'm using a repeat panel and each row has the cell with the text-label named the same way for the ID? How could I solve it?

Kind regards, Lisa

asked 04 Feb '14, 03:27

Lisa's gravatar image

accept rate: 0%

Hi Lisa,

The repeat panel datasource's row corresponding to the clicked row in the repeat panel is automatically set as the current row. So you don't need to send secret ID's or anything. Use api_datasource API's to read the current row of Repeat Panel's datasource.

Kind Regards,


answered 04 Feb '14, 04:20

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
accept rate: 15%

Thank you for your anwer. Had a look in the API, but I couldn't find the right function for me. Could you help me?

Kind Regards, Lisa

(04 Feb '14, 05:51) Lisa

Hi Lisa,

api_datasouce API package is the one you are looking for. You can use api_datasource.getColumnValue functions to retrieve values from the current row.

(05 Feb '14, 02:54) Yalim ♦♦
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 Feb '14, 03:27

Seen: 1,691 times

Last updated: 05 Feb '14, 02:54

© Copyright Gerger 2017