OraFAQ Forum: Forms » How to print the next record value in oracle forms10g

Home » Developer & Programmer » Forms » How to print the next record value in oracle forms10g (oracle forms10g)

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

How to print the next record value in oracle forms10g [message #462910]

Mon, 28 June 2010 11:09

kvkpraveen
Messages: 20
Registered: June 2010
Location: Bangalore

Junior Member

Dear sir,

I am using oracle forms10g here i have next button. So when i click the next button it will show the total volumn of record count and each record value for example 1/10 like that. Please help me how to do that....

Report message to a moderator

Re: How to print the next record value in oracle forms10g [message #462915 is a reply to message #462910]

Mon, 28 June 2010 11:19

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Forms shows that count at the bottom of the screen anyway.
What exactly are you trying to achieve?

Report message to a moderator

Re: How to print the next record value in oracle forms10g [message #462942 is a reply to message #462915]

Mon, 28 June 2010 15:41

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

Senior Member
Account Moderator

We discussed it not that long ago. Check what's already being said in this topic.

Report message to a moderator

Re: How to print the next record value in oracle forms10g [message #464376 is a reply to message #462915]

Wed, 07 July 2010 10:50

kvkpraveen
Messages: 20
Registered: June 2010
Location: Bangalore

Junior Member

I have the next button and previous button and one display item

So when i will execute the query lets take 10 records are there it should show like "1/10" and when i will clicck the next button it will show "1/2" and same for the previous button

Cheers!
Praveen.K

Report message to a moderator

Re: How to print the next record value in oracle forms10g [message #464380 is a reply to message #464376]

Wed, 07 July 2010 11:18

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

How did you get from 1/10 to 1/2?
Did you mean 2/10?

Regardless read the thread Littlefoot linked to above - it covers this in detail.

Report message to a moderator

Re: How to print the next record value in oracle forms10g [message #464561 is a reply to message #464380]

Thu, 08 July 2010 07:17

kvkpraveen
Messages: 20
Registered: June 2010
Location: Bangalore

Junior Member

Hi ,

This is to print "2/10". Please suggest me.

Cheers!
Praveen.K

Report message to a moderator

Re: How to print the next record value in oracle forms10g [message #464564 is a reply to message #464380]

Thu, 08 July 2010 07:19

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

cookiemonster wrote on Wed, 07 July 2010 17:18

Regardless read the thread Littlefoot linked to above - it covers this in detail.

Report message to a moderator

Re: How to print the next record value in oracle forms10g [message #465076 is a reply to message #464564]

Mon, 12 July 2010 08:28

kvkpraveen
Messages: 20
Registered: June 2010
Location: Bangalore

Junior Member

I have the next button and previous button and one display item

So when i will execute the query lets take 10 records are there it should show like "1/10" and when i will click the next button it will show "2/10....10/10" and for the previous button it should be show like 10/10....1/10 corrsepondingly it will move record also.

Cheers!
Praveen.K

Report message to a moderator

Re: How to print the next record value in oracle forms10g [message #465078 is a reply to message #465076]

Mon, 12 July 2010 08:55

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Repeating the question doesn't change the answer - read the other thread!!!!!!

Report message to a moderator

Re: How to print the next record value in oracle forms10g [message #465202 is a reply to message #465078]

Tue, 13 July 2010 03:23

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear Praveen.K,
Please see this sample form pic.

/forum/fa/8005/0/

As my Understanding hope this code 'll helpfull for you.

After Execute Query

<< When-Button-pressed >> Label Next

Next_Record;
:A:=Get_Block_Property('Po_Header',Current_Record)||'/'||Get_Block_Property('Po_Header',Query_Hits) ;

Note:-

A DataType is Char.
My Header Table (Po_Header) Block Property must be Set Query All Records YES.

Regards

Irfan

Attachment: QueryForm.JPG
(Size: 35.96KB, Downloaded 1026 times)

Report message to a moderator

Previous Topic:	How to change Oracle form background
Next Topic:	Data Receive for COM PORT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:37:56 CDT 2024