Home » Developer & Programmer » Forms » Create Current Record Indicator in Display Item
Create Current Record Indicator in Display Item [message #637780] Mon, 25 May 2015 00:11 Go to next message
tofajjalhnipu66@gmail.com
Messages: 18
Registered: May 2015
Location: Chittagong,Bangladesh
Junior Member
Hi


could u help me please for creating 'Current Record Indicator' using a display item ...


Regards
Re: Create Current Record Indicator in Display Item [message #637781 is a reply to message #637780] Mon, 25 May 2015 00:15 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What is a "current record indicator"?
Re: Create Current Record Indicator in Display Item [message #637783 is a reply to message #637780] Mon, 25 May 2015 00:22 Go to previous messageGo to next message
tofajjalhnipu66@gmail.com
Messages: 18
Registered: May 2015
Location: Chittagong,Bangladesh
Junior Member
Like This one ....

Regards
Re: Create Current Record Indicator in Display Item [message #637784 is a reply to message #637783] Mon, 25 May 2015 00:33 Go to previous messageGo to next message
tofajjalhnipu66@gmail.com
Messages: 18
Registered: May 2015
Location: Chittagong,Bangladesh
Junior Member
please please help me dear @Littlefoot....


Regaeds
Re: Create Current Record Indicator in Display Item [message #637785 is a reply to message #637784] Mon, 25 May 2015 01:04 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Why reinventing the wheel? It's already written in the bottom left corner of the form window.
Re: Create Current Record Indicator in Display Item [message #637786 is a reply to message #637785] Mon, 25 May 2015 01:20 Go to previous messageGo to next message
tofajjalhnipu66@gmail.com
Messages: 18
Registered: May 2015
Location: Chittagong,Bangladesh
Junior Member
Yap i know this ...
but i need to show this in a Display item...

Now how to create it ? If u know please let me share details..
Regards.
Re: Create Current Record Indicator in Display Item [message #637789 is a reply to message #637786] Mon, 25 May 2015 01:28 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Current record might be :SYSTEM.CURSOR_RECORD or :SYSTEM.TRIGGER_RECORD.

In order to find total number of records, you have to execute query in that block and set "Query all records" property to "Yes". That number changes as you add new records or delete existing ones, so you'll have to maintain that number somehow (either by adding and subtracting from the initial number, or requerying the block).

By the way, I don't know how Forms does it internally.

From my point of view, it is not worth the pain.
Re: Create Current Record Indicator in Display Item [message #637796 is a reply to message #637789] Mon, 25 May 2015 05:08 Go to previous messageGo to next message
tofajjalhnipu66@gmail.com
Messages: 18
Registered: May 2015
Location: Chittagong,Bangladesh
Junior Member
WHAT'S THE TRIGGER IT IS? AND WHERE I CAN APPLY IT? FORM OR BLOCK LEVEL ?

REGARDS.
Re: Create Current Record Indicator in Display Item [message #638120 is a reply to message #637796] Tue, 02 June 2015 16:55 Go to previous message
CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA
Senior Member
Please, all CAPITALS means you are shouting. I'm sure that is not what you intended. Smile

Since you want to know what record you are on and how many records there are you can use a combination of a When-New-Block-Instance and When-New-Record-Instance to assign the value of a COUNT(*) from your BLOCK table to get the total number of records and :SYSTEM.TRIGGER_RECORD or :SYSTEM.CURSOR_RECORD.

Craig...
Previous Topic: Dynamic Item Properties Control and Apply
Next Topic: how to open detail menu automaticaly when mouse on master menu in forms 10g
Goto Forum:
  


Current Time: Thu Mar 28 11:37:02 CDT 2024