Home » Developer & Programmer » Forms » Cursor in Oracle Forms
Cursor in Oracle Forms [message #377249] Mon, 22 December 2008 02:24 Go to next message
jolly_makkar
Messages: 63
Registered: March 2008
Member
i am using tabular grid in form to fetch records with the help of cursor.
No doubt cursor is fetching the record ,but records are being overwritten in the grid.
if it fetches 4 rows.it should go into four tabular records.....but for writting 2nd record it overwrites 1st ....like all the rows its fetching in first tabular record in forms.

How to make record fetch with cursor to come all in their respective fetch position?

i changed the block Navigation property to "change record" but cursor is not changing the record....

what could be other reason

Thanks
Re: Cursor in Oracle Forms [message #377272 is a reply to message #377249] Mon, 22 December 2008 03:26 Go to previous messageGo to next message
dhanuka.rajesh
Messages: 49
Registered: March 2008
Location: Mumbai
Member
Kindly fill the data on grid using for loop
and ensure after each loop u create a new record on form and write data.

Dhanuka. Rajesh
Re: Cursor in Oracle Forms [message #377375 is a reply to message #377272] Mon, 22 December 2008 10:20 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Just in case you didn't get it: it is the NEXT_RECORD that is probably missing within the loop (so every "new" record overwrites a previous one).
icon14.gif  Re: Cursor in Oracle Forms [message #377414 is a reply to message #377375] Mon, 22 December 2008 22:44 Go to previous message
jolly_makkar
Messages: 63
Registered: March 2008
Member
Its Solved "Little foot" thanks......

Wht i was doing ...on pre query trigger of A block i was fetching records in B block(with cursor)

now itself in B block i kept push button ..button pressed ...fetch the records...

Thanks Smile
Previous Topic: Changing visual attribute property to a record in a block.
Next Topic: Problem with list item
Goto Forum:
  


Current Time: Sat Dec 10 04:59:21 CST 2016

Total time taken to generate the page: 0.10288 seconds