OraFAQ Forum: Forms » Cursor in Oracle Forms

Home » Developer & Programmer » Forms » Cursor in Oracle Forms

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

Cursor in Oracle Forms [message #377249]

Mon, 22 December 2008 02:24

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

Report message to a moderator

Re: Cursor in Oracle Forms [message #377272 is a reply to message #377249]

Mon, 22 December 2008 03:26

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

Report message to a moderator

Re: Cursor in Oracle Forms [message #377375 is a reply to message #377272]

Mon, 22 December 2008 10:20

Littlefoot
Messages: 21823
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).

Report message to a moderator

Re: Cursor in Oracle Forms [message #377414 is a reply to message #377375]

Mon, 22 December 2008 22:44

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 17:50:37 CST 2025