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

asked 18 Jun '13, 10:34

suranga's gravatar image

suranga
218
accept rate: 0%


Hi Suranga,

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

  1. api_datasource.getRow(in_datasourcename_tx IN varchar2, in_row_id IN number DEFAULT null)
  2. 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's gravatar image

Yalim ♦♦
2.8k5
accept rate: 23%

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:

×85
×6

Asked: 18 Jun '13, 10:34

Seen: 832 times

Last updated: 18 Jun '13, 13:24


© Copyright Gerger 2017