Home » Developer & Programmer » Forms » how to add callendar in Report 6i urgent!!!!!!pls (dba10g/forms 6i)
how to add callendar in Report 6i urgent!!!!!!pls [message #429545] Wed, 04 November 2009 08:35 Go to next message
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





Re: how to add callendar in Report 6i urgent!!!!!!pls [message #429617 is a reply to message #429545] Wed, 04 November 2009 14:40 Go to previous messageGo to next message
Littlefoot
Messages: 20827
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?
Re: how to add callendar in Report 6i urgent!!!!!!pls [message #429745 is a reply to message #429617] Thu, 05 November 2009 11:12 Go to previous messageGo to next message
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
Re: how to add callendar in Report 6i urgent!!!!!!pls [message #429746 is a reply to message #429745] Thu, 05 November 2009 11:24 Go to previous messageGo to next message
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
Re: how to add callendar in Report 6i urgent!!!!!!pls [message #430029 is a reply to message #429746] Sat, 07 November 2009 01:28 Go to previous messageGo to next message
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.
Re: how to add callendar in Report 6i urgent!!!!!!pls [message #430052 is a reply to message #430029] Sat, 07 November 2009 11:24 Go to previous messageGo to next message
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

Re: how to add callendar in Report 6i urgent!!!!!!pls [message #430054 is a reply to message #430052] Sat, 07 November 2009 11:42 Go to previous messageGo to next message
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



Re: how to add callendar in Report 6i urgent!!!!!!pls [message #430647 is a reply to message #430054] Wed, 11 November 2009 07:14 Go to previous messageGo to next message
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

Re: how to add callendar in Report 6i urgent!!!!!!pls [message #430667 is a reply to message #429545] Wed, 11 November 2009 10:07 Go to previous messageGo to next message
cookiemonster
Messages: 12321
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.
Re: how to add callendar in Report 6i urgent!!!!!!pls [message #432554 is a reply to message #430647] Tue, 24 November 2009 22:29 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: how to add callendar in Report 6i urgent!!!!!!pls [message #434728 is a reply to message #432554] Thu, 10 December 2009 07:10 Go to previous messageGo to next message
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

Re: how to add callendar in Report 6i urgent!!!!!!pls [message #434730 is a reply to message #430667] Thu, 10 December 2009 07:25 Go to previous message
cookiemonster
Messages: 12321
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.
Previous Topic: log on erro
Next Topic: Oracle Forms and Non-Profit
Goto Forum:
  


Current Time: Sat Oct 01 04:07:32 CDT 2016

Total time taken to generate the page: 0.25425 seconds