OraFAQ Forum: Forms » Fetching Records into Non-Database Block of Forms

Home » Developer & Programmer » Forms » Fetching Records into Non-Database Block of Forms

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Fetching Records into Non-Database Block of Forms [message #163344]

Thu, 16 March 2006 06:12

nirmalnarayan
Messages: 261
Registered: April 2005
Location: India

Senior Member

I have a Form with 10 Fields, this is a non-database block, i am using key-commit and on-insert trigger to insert values into database. While fetching records back i am using a multi-table join view, in a cursor. The problem is only last record fetched by the Cursor is being displayed on 'Key-Exeqry'.

I want to fetch all the records and display the records starting from the first record and then the user has to navigate to the next record. How can i achieve this. the records has to be displayed one record at a time per screen.

Nirmal

[Updated on: Thu, 16 March 2006 06:13]

Report message to a moderator