如何在oracle查询中添加这些? [英] How to add these in oracle query?
问题描述
我正在进行VB6.0和oracle(10G)中名为大学入学管理的最后一年项目。
我完成了75%的项目。但我被困在一个地方,我找不到任何解决问题的方法。问题是我需要将选择标准添加到vb表单,以便它可以从整个列表中提取符合条件的学生。
我添加了一个简单的代码来根据截止标记提取列表但是社区优先级是什么?如何将社区优先级添加到查询中。请帮我快点耗尽。
我用来根据截止标记提取列表的代码是:
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:
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
推荐答案
这篇关于如何在oracle查询中添加这些?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!