OraFAQ Forum: Forms » how to add callendar in Report 6i urgent!!!!!!pls

Home » Developer & Programmer » Forms » how to add callendar in Report 6i urgent!!!!!!pls (dba10g/forms 6i)

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

how to add callendar in Report 6i urgent!!!!!!pls [message #429545]

Wed, 04 November 2009 08:35

owais_baba
Messages: 289
Registered: March 2008
Location: MUSCAT

Senior Member

hi all gurus

i have a two question

(1). 1st is how to add callendar in report 6i.
(2). 2nd question is why "ORDER BY dbms_random.value" not
working in form 6i my problem is this that i am developing application regarding electronic balloting system it means quizz program.

my example code is this which i make on when button pressed on canvas

DECLARE
C VARCHAR2(10);
CURSOR C1 IS SELECT *
FROM (SELECT empno FROM EMP
ORDER BY dbms_random.value)
;
BEGIN
FOR A IN C1 LOOP
c:=a.EMPNO;
synchronize;
END LOOP;
END;

kindly solve my problem on a immediate base

thanks in advance

Report message to a moderator

Re: how to add callendar in Report 6i urgent!!!!!!pls [message #429617 is a reply to message #429545]

Wed, 04 November 2009 14:40

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

Senior Member
Account Moderator

As of your "calendar" question, search the board - it has already been discussed, and some threads contain working sample forms.

As of DBMS_RANDOM.VALUE, what does "it doesn't work" mean?

Report message to a moderator

Re: how to add callendar in Report 6i urgent!!!!!!pls [message #429745 is a reply to message #429617]

Thu, 05 November 2009 11:12

owais_baba
Messages: 289
Registered: March 2008
Location: MUSCAT

Senior Member

thnaks for reply
yes you are right it does'nt work i think its not compatible with forms 6i what else should i do can u give me some idea

actually i took emp table for example i took empno on canvas
on button pressed i put this code what it should do counter should run i mean loop will execute untill unless i will not stop this loop i mean it will be infanite loop but data will be in loop it will be randome wise

example

1001
1006
1002
1010 like

pls sole this problem

thanks

thansk

Report message to a moderator

Re: how to add callendar in Report 6i urgent!!!!!!pls [message #429746 is a reply to message #429745]

Thu, 05 November 2009 11:24

owais_baba
Messages: 289
Registered: March 2008
Location: MUSCAT

Senior Member

as far as concern calendar for form 6i there is no problem to add calendar in forms 6i but problem is to add calendar in report 6i i tried to find some threads but not for report 6i all are for forms 6i

thanks i hope you will help me

Report message to a moderator

Re: how to add callendar in Report 6i urgent!!!!!!pls [message #430029 is a reply to message #429746]

Sat, 07 November 2009 01:28

javed.khan
Messages: 340
Registered: November 2006
Location: Banglore

Senior Member

I appreaciate if you will Pls Attach your form regarding the Random Value Example with Emp Table.

Report message to a moderator

Re: how to add callendar in Report 6i urgent!!!!!!pls [message #430052 is a reply to message #430029]

Sat, 07 November 2009 11:24

owais_baba
Messages: 289
Registered: March 2008
Location: MUSCAT

Senior Member

hi mr javed khan thanks for reply

i am attaching this fmb file pls check and help

thanks

Attachment: example_form_RANDOM.fmb
(Size: 44.00KB, Downloaded 1112 times)

Report message to a moderator

Re: how to add callendar in Report 6i urgent!!!!!!pls [message #430054 is a reply to message #430052]

Sat, 07 November 2009 11:42

owais_baba
Messages: 289
Registered: March 2008
Location: MUSCAT

Senior Member

hi mr javed khan

sorry check code there will be one excess end loop; pls remove it. anyway let me clear you complete scnario this was a example form actually this should work like this

loop will be infanite untill unless we will not press any button user will press the button one of the no. will display in other text_item which will be winner like as i mentioned before electronic balloting system then again we will press butt counter will start for 2nd position. I hope you will understand my problem

thanks

Report message to a moderator

Re: how to add callendar in Report 6i urgent!!!!!!pls [message #430647 is a reply to message #430054]

Wed, 11 November 2009 07:14

owais_baba
Messages: 289
Registered: March 2008
Location: MUSCAT

Senior Member

no one here to solve my problem
actually this is little bit urgent that's why i am bothering you peoples

thanks

Report message to a moderator

Re: how to add callendar in Report 6i urgent!!!!!!pls [message #430667 is a reply to message #429545]

Wed, 11 November 2009 10:07

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

Senior Member

You probably haven't got an answer yet because your problem description is less than clear.
I suspect what you need is a database function that returns a random emp record. Or just the primary key of a random record which you can then query in the form.

If that's not what you need then you need to restate your problem a lot more clearly than you have done.

As for the calendar issue - I assume you want this for a parameter. Just create a form to specify the parameters and use the calendar in that.

Report message to a moderator

Re: how to add callendar in Report 6i urgent!!!!!!pls [message #432554 is a reply to message #430647]

Tue, 24 November 2009 22:29

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

Senior Member
Account Moderator

Have you solved your problem?

David

Report message to a moderator

Re: how to add callendar in Report 6i urgent!!!!!!pls [message #434728 is a reply to message #432554]

Thu, 10 December 2009 07:10

owais_baba
Messages: 289
Registered: March 2008
Location: MUSCAT

Senior Member

not yet solved this i am using parametar to use calender in report 6i but i want to add calendar like forms 6i calendar its
possible or not pls tell me

thanks

Report message to a moderator

Re: how to add callendar in Report 6i urgent!!!!!!pls [message #434730 is a reply to message #430667]

Thu, 10 December 2009 07:25

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

Senior Member

cookiemonster wrote on Wed, 11 November 2009 16:07

As for the calendar issue - I assume you want this for a parameter. Just create a form to specify the parameters and use the calendar in that.

I as far as I'm aware you can't plug a calendar directly into reports.

Report message to a moderator

Previous Topic:	log on erro
Next Topic:	Oracle Forms and Non-Profit

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:47:03 CDT 2024