| page wise displaying data [message #452796] |
Sat, 24 April 2010 12:20  |
kalpataru
Messages: 72
Registered: January 2010
Location: INDIA
|
Member |
|
|
hi all,
i want displaying the query data page wise.
i want place 4 buttons
1 for 1st page, 2nd for next page, 3rd nxt page and 4th for last page.
how can i do this through programming in oracle forms 10g.
please give me the entire process of doing this.
i am waiting for your response.
|
|
|
|
|
|
|
|
| Re: page wise displaying data [message #453757 is a reply to message #453430] |
Fri, 30 April 2010 12:01  |
kalpataru
Messages: 72
Registered: January 2010
Location: INDIA
|
Member |
|
|
i think you don't understand my question
i have oracle query of 100 records and i have a grid in oracle 10g forms number of record displayed is 50.
how can display the query data into grid by page wise means
50 records per gid means/50 records per page without scroll bar.
i have four button
please tell me through programming.
|
|
|
|
|
|
| Re: page wise displaying data [message #453795 is a reply to message #453772] |
Sat, 01 May 2010 05:12 |
kalpataru
Messages: 72
Registered: January 2010
Location: INDIA
|
Member |
|
|
thanks for your quick replay
Use GO_RECORD built-in. Calculate target record number as "current record" +/- 50 records.
i don't understand what to do from the above line.
please give me the details about the procedure for doing
page wise display...
can you give me sample copy without using the block level...
only through programming....
|
|
|
|
| Re: page wise displaying data [message #453810 is a reply to message #453795] |
Sat, 01 May 2010 13:23 |
 |
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Misunderstanding is mutual.
I'm afraid that nobody understands what you are talking about. I tried twice, David once - we failed. Either we are incapable of imagining your problem, or you didn't explain it well.
I thought that, as there are "4 pages" (logica pages, as far as I understood), you want to jump 50 records up or down. So, find out where you are now (:system.trigger_record). If going up for 50 records, GO_RECORD(current record - 50). If going down for 50 records, GO_RECORD(current_record + 50).
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
