Home » Developer & Programmer » Forms » Selective reords per page (Forms6i)
Selective reords per page [message #447291] Sat, 13 March 2010 01:00 Go to next message
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 210 times)
Re: Selective reords per page [message #447339 is a reply to message #447291] Sat, 13 March 2010 14:50 Go to previous messageGo to next message
Littlefoot
Messages: 20827
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
GO_RECORD
Re: Selective reords per page [message #447366 is a reply to message #447339] Sat, 13 March 2010 23:35 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

But how implement as a standard 10 records per page.
Re: Selective reords per page [message #447370 is a reply to message #447339] Sun, 14 March 2010 04:30 Go to previous messageGo to next message
Littlefoot
Messages: 20827
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.
Re: Selective reords per page [message #447798 is a reply to message #447291] Thu, 18 March 2010 00:22 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What's wrong with 'scroll_down' and 'scroll_up'?

David
Re: Selective reords per page [message #447800 is a reply to message #447798] Thu, 18 March 2010 00:23 Go to previous messageGo to next message
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.
Re: Selective reords per page [message #448745 is a reply to message #447800] Thu, 25 March 2010 01:45 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Selective reords per page [message #448784 is a reply to message #447291] Thu, 25 March 2010 03:42 Go to previous message
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.
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:
  


Current Time: Wed Sep 28 00:37:32 CDT 2016

Total time taken to generate the page: 0.11257 seconds