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

Members

Help

Home

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

Show: Today's Messages :: Show 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: 96
Registered: March 2008
Location: MUSCAT

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: 9235
Registered: June 2005
Location: Croatia, Europe

Senior Member

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: 96
Registered: March 2008
Location: MUSCAT

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: 96
Registered: March 2008
Location: MUSCAT

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: 205
Registered: November 2006
Location: Mumbai

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: 96
Registered: March 2008
Location: MUSCAT

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 25 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: 96
Registered: March 2008
Location: MUSCAT

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: 96
Registered: March 2008
Location: MUSCAT

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: 1425
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: 9452
Registered: March 2005
Location: Canberra ACT Australia

Senior Member

Have you solved your problem?

David

Report message to a moderator

Previous Topic:	Oracle 10g key combination to call form trigger
Next Topic:	Error while running forms in web

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 29 15:18:57 CST 2009

Total time taken to generate the page: 0.21123 seconds

.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.