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: 21148
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: Mouse doesnt work after scrolling
Next Topic: Problem with list item
Goto Forum:
  


Current Time: Sat Aug 19 20:59:21 CDT 2017

Total time taken to generate the page: 0.35087 seconds