OraFAQ Forum: Forms » Create Current Record Indicator in Display Item

Home » Developer & Programmer » Forms » Create Current Record Indicator in Display Item

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

Create Current Record Indicator in Display Item [message #637780]

Mon, 25 May 2015 00:11

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

Report message to a moderator

Re: Create Current Record Indicator in Display Item [message #637781 is a reply to message #637780]

Mon, 25 May 2015 00:15

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

Senior Member
Account Moderator

What is a "current record indicator"?

Report message to a moderator

Re: Create Current Record Indicator in Display Item [message #637783 is a reply to message #637780]

Mon, 25 May 2015 00:22

tofajjalhnipu66@gmail.com
Messages: 18
Registered: May 2015
Location: Chittagong,Bangladesh

Junior Member

Like This one ....

Regards

Attachment: 2015-05-25_112100.png
(Size: 151.39KB, Downloaded 1319 times)

Report message to a moderator

Re: Create Current Record Indicator in Display Item [message #637784 is a reply to message #637783]

Mon, 25 May 2015 00:33

tofajjalhnipu66@gmail.com
Messages: 18
Registered: May 2015
Location: Chittagong,Bangladesh

Junior Member

please please help me dear @Littlefoot....

Regaeds

Report message to a moderator

Re: Create Current Record Indicator in Display Item [message #637785 is a reply to message #637784]

Mon, 25 May 2015 01:04

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

Report message to a moderator

Re: Create Current Record Indicator in Display Item [message #637786 is a reply to message #637785]

Mon, 25 May 2015 01:20

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.

Report message to a moderator

Re: Create Current Record Indicator in Display Item [message #637789 is a reply to message #637786]

Mon, 25 May 2015 01:28

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

Report message to a moderator

Re: Create Current Record Indicator in Display Item [message #637796 is a reply to message #637789]

Mon, 25 May 2015 05:08

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.

Report message to a moderator

Re: Create Current Record Indicator in Display Item [message #638120 is a reply to message #637796]

Tue, 02 June 2015 16:55

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...

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 23:01:52 CDT 2025