OraFAQ Forum: Forms » Selective reords per page

Home » Developer & Programmer » Forms » Selective reords per page (Forms6i)

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

Selective reords per page [message #447291]

Sat, 13 March 2010 01:00

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

Dear All,

I have one query based(Execute_query) tabular form where i pass input parameters and the query results will be displayed.I have around 100 records and i want to display like 15 records per page once i click the button it will go to the next 15th record and theron if i click on that it should move to 30th and i dont want to use scroll bar.Is there any way.I am attaching the fmb.

Attachment: SHIPSCH.fmb
(Size: 864.00KB, Downloaded 1227 times)

Report message to a moderator

Re: Selective reords per page [message #447339 is a reply to message #447291]

Sat, 13 March 2010 14:50

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

GO_RECORD

Report message to a moderator

Re: Selective reords per page [message #447366 is a reply to message #447339]

Sat, 13 March 2010 23:35

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

But how implement as a standard 10 records per page.

Report message to a moderator

Re: Selective reords per page [message #447370 is a reply to message #447339]

Sun, 14 March 2010 04:30

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Find current record. Then go to the "current record + 10" or "current record - 10". Check system variables (":system...") to see which would be the most appropriate for finding your current position.

Report message to a moderator

Re: Selective reords per page [message #447798 is a reply to message #447291]

Thu, 18 March 2010 00:22

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

What's wrong with 'scroll_down' and 'scroll_up'?

David

Report message to a moderator

Re: Selective reords per page [message #447800 is a reply to message #447798]

Thu, 18 March 2010 00:23

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

no martin our users are requesting for this like they want to go to 30th record and then they will click twice as 15 records per page.

Report message to a moderator

Re: Selective reords per page [message #448745 is a reply to message #447800]

Thu, 25 March 2010 01:45

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Then program your own 'key-scrup' and 'key-scrdown' triggers. You will have to handle 'top' and 'bottom'. Use 'get_block_property(records_displayed)' to determine how many rows to 'scroll' each time.

David

Report message to a moderator

Re: Selective reords per page [message #448784 is a reply to message #447291]

Thu, 25 March 2010 03:42

gregor
Messages: 86
Registered: March 2010
Location: Germany

Member

hi arif_md2009,

a) if you want create a Query-only application,
it is a nice technik to built the forms based on
transactional-triggers.
In When-new-form-instance Trigger fill a PL/SQL-Table
with your 100 records.
In Pre-query,
( after a Button [next][previous][>>] pressed ),
fill a second PL/SQL-Tabelle with the 15 Records
taht should be displayed. Handle the Counter in
-> on-select ->on-fetch-Trigger.

b)If your application is not query only it is more complicated.
You could put the PL/SQL-Tables in a Database-package
or
built a FORM for INSERT update.

Report message to a moderator

Previous Topic:	Finger prints in Forms 6i (plus rant from user) and OCX object problem (merged by DJM)
Next Topic:	Client_ole2 + OpenOffice

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 22:58:13 CDT 2024