Home » Developer & Programmer » Forms » Comparing Two Combo Boxes
Comparing Two Combo Boxes [message #201713] Mon, 06 November 2006 08:20 Go to next message
qadeerahmed
Messages: 63
Registered: July 2006
Location: Pakistan
Member
Hi,
I want to compare two combo boxes, is it possible? if Yes then HOW?
What Queries Will be Used to accomplish this task.

Thanks
Regards
Qadeer Ahmed
Re: Comparing Two Combo Boxes [message #201837 is a reply to message #201713] Tue, 07 November 2006 00:58 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Which part of the combo box? The result or the record_group? If the latter then use the 'Get_Group' commands - Get_Group_Row_Count, etc to present the details of the two groups.

David
Re: Comparing Two Combo Boxes [message #203205 is a reply to message #201837] Tue, 14 November 2006 05:46 Go to previous messageGo to next message
qadeerahmed
Messages: 63
Registered: July 2006
Location: Pakistan
Member
HI,

I didn't get your point ?

Regards,
Qadeer ahmed
Re: Comparing Two Combo Boxes [message #203273 is a reply to message #203205] Tue, 14 November 2006 09:52 Go to previous messageGo to next message
qadeerahmed
Messages: 63
Registered: July 2006
Location: Pakistan
Member
Plz Answer My Query

Thanks!!!

REgards,
Qadeer Ahmed
Re: Comparing Two Combo Boxes [message #203275 is a reply to message #201713] Tue, 14 November 2006 09:56 Go to previous messageGo to next message
yogen
Messages: 39
Registered: October 2006
Location: UK
Member
You need make clear yourself about your query first.Do you want to number of item in 2 diffrent combo boxes? or first item in 1 combo box with 1st item in another combo box and so on...?
or do you mean something else by this comparison.
Try to put your requirement with some example then only you may get good answers..
Re: Comparing Two Combo Boxes [message #203349 is a reply to message #203275] Tue, 14 November 2006 19:43 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I repeat
Which part of the combo box? The result or the record_group?

David
Re: Comparing Two Combo Boxes [message #203642 is a reply to message #203275] Wed, 15 November 2006 22:59 Go to previous messageGo to next message
qadeerahmed
Messages: 63
Registered: July 2006
Location: Pakistan
Member
hi,

The record_Group.

Because i want to compare either the element "A" Exist in both of the comboboxes

Hope so that will clear my point

Thanks!!!
Qadeer Ahmed
Re: Comparing Two Combo Boxes [message #203650 is a reply to message #203642] Wed, 15 November 2006 23:36 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Review the documentation for 'get_Group_Char_Cell'.

David
Re: Comparing Two Combo Boxes [message #203684 is a reply to message #203650] Thu, 16 November 2006 00:52 Go to previous messageGo to next message
qadeerahmed
Messages: 63
Registered: July 2006
Location: Pakistan
Member
Thanks!
Re: Comparing Two Combo Boxes [message #203952 is a reply to message #203684] Fri, 17 November 2006 01:15 Go to previous messageGo to next message
qadeerahmed
Messages: 63
Registered: July 2006
Location: Pakistan
Member
Hi,

I would like you to clear one thing that is not clear to me.

Would it be better to take the 'Intersection' Rather using the 'Get_Group_Char_Cell'.

Because I only want to see is either both the combo boxes have atleast one element common.

What would you suggest.

Regards,

Qadeer Ahmed
Re: Comparing Two Combo Boxes [message #203958 is a reply to message #203952] Fri, 17 November 2006 01:42 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I would suggest writing your own cursor that has both of the pieces of dynamic or static SQL in it and executing it instead of processing two record groups looking for a common element. I thought you were looking for two lists that had the same number of elements and with the same content list.

David
Re: Comparing Two Combo Boxes [message #204022 is a reply to message #203958] Fri, 17 November 2006 06:23 Go to previous messageGo to next message
qadeerahmed
Messages: 63
Registered: July 2006
Location: Pakistan
Member
HI & Thanks !!

Yes I'm looking for that has the same contents not the same number of elements.

Ok! I'll try to Explain you, Hopefully you'll get my point.

Consider an example of course Registration at the university level. University offer some courses for each semester from semester 1 to 8.

Students enroll some courses, against it there rollno is saved; specifying the student had register that course.
Student may be of any semester 1 to 8 and can take course with any semester.

e.g due to any reason he was not able to pass that course, so he has to take that course with the juniors. So the Students of Semester 6th can take course with the students of Semester 3rd;

So While making the date sheet for the exams, We have to keep in mind that there will no Clashes occur. Clashes Means, If One Student has an exam of two courses on the same day.

This can happen because as i wrote earlier that students can take courses with the junior semester students. And We are making separate Datesheet for each and every semester.

Hope so you got it all right !!!

Now,I've an LOV for the courses of 1st Semester. I select any of it. Now i Move on towards the Datesheet for 2nd semester for that i also have an LOV of the courses for 2nd semester. I select any course from there.

What If any Senior Student Was Taking Course With the Semester1 Student also, And Unfortunatly the subject we selected From LOV's of semester 1 and semester 2 were both registered by the Student. So we have a clash.

So How can I check that the Clash exist? And It displays msg that Clash Exists Choose Other Subject.

Thanks !!!

Regards
Qadeer ahmed

Re: Comparing Two Combo Boxes [message #204258 is a reply to message #204022] Sun, 19 November 2006 22:08 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Thank goodness you told us what you really want to do!! All you need to do is change the Record Group definitions so that they DO NOT return any clashes. Start your testing by using the current code in the first LOV's Record Group and in the second LOV's Record Group apply the value returned by the first LOV to the 'where' clause of this second Record Group so that only those classes that are without a clash are listed.

David
Re: Comparing Two Combo Boxes [message #399228 is a reply to message #201713] Tue, 21 April 2009 03:36 Go to previous message
rzkhan
Messages: 345
Registered: March 2005
Senior Member
Did you solve the problem?

rz
Previous Topic: ORA-12560: TNS:protocol adapter error....AGAIN!
Next Topic: ORA-01445 on execute_query
Goto Forum:
  


Current Time: Sun Dec 04 08:54:33 CST 2016

Total time taken to generate the page: 0.19477 seconds