How to add these in oracle query?

Question

1.00/5 (2 votes)

See more:

i am doing my final year project entitled "College Admission Management" in VB6.0 and oracle(10G).
i have completed 75% of the project. But i m stuck in a place, i cannot find any sol for the problem. The problem is dat i need to add selection criteria to vb forms so that it can extract eligible students from the entire list.
I have added a simple code to extract the list based on cutoff marks but what abt community priority? How to add the community priority to query. Pls help me i m running out of time.
The code i have used to extract the list based on cutoff marks is:

VB

Adodc1.RecordSource = "select application_no,name,community,subpart2,markspart2 from sfugc where course_applied='BA Eng' and markspart2>=130 order by markspart2 desc"
Adodc1.Refresh
Adodc1.Caption = Adodc1.RecordSource

Posted 31-Mar-14 20:05pm

Sanya Raj

Updated 31-Mar-14 20:09pm

Maciej Los

v2

Add a Solution

Comments

Maciej Los 1-Apr-14 2:16am

Waht you mean by: How to add the community priority to query?

Sanya Raj 1-Apr-14 11:42am

In India, every college must provide higher priority for SC, ST community, and lower priority for MBC and BC community other than merit rank list of applied students. Certain criteria are there i.e. 40 % of SC and ST are provided priority after merit students. So I want to add ths type of conditions to query.

CHill60 1-Apr-14 19:58pm

I'm struggling to understand your question... "sol", "dat", "abt" "Pls"?? In what way does the code you have written not work? And if you are doing a final year project why are you using VB6? It is unusual for educational facilities to use antiquated software

Sanya Raj 2-Apr-14 12:05pm

solution, that, about, please.
i am supposed to do this in vb.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)