Use row number to retrieve data

Hi all,

Is it possible to retrieve the data(in a grid) of a column using the row number. Currently it's achieved via the row id but i want to know if its possible to use the row number. The requirement is to copy data of a given row to the immediate row.

Thanks

Suranga

grid datasources

asked 18 Jun '13, 10:34

suranga
21●1●17
accept rate: 0%

One Answer:

oldest newest most voted

Hi Suranga,

No this is not possible. We have two API's that might help you though.

api_datasource.getRow(in_datasourcename_tx IN varchar2, in_row_id IN number DEFAULT null)
api_datasource.getRowByPK(in_datasourcename_tx IN varchar2, in_pk_tx IN varchar2)

So you can either use the Primary Key or the Datasource Row ID (not the Oracle Row_ID) to read a row from the datasource. The datasource API documentation has sample code showing how to use them at http://theformspider.com/API/index.html

Kind Regards, Yalim

link

answered 18 Jun '13, 13:24

Yalim ♦♦
2.8k●5
accept rate: 20%

Your answer

toggle preview

community wiki

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

learn more about Markdown

Tags:

grid ×85
datasources ×6