General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I have student .dbf with fields 1.Regno (C) 2.Name (C) 3.DOB (D) 4.Category (C) 5. Result (C) 6.Sitting (Integer) 7.Course (C) having around 2000 records. I would like to write a "Error.prg" for four types of Error list mention below.
1. List out the student whose age above 25 years as on 1st July 2011 based on DOB Field.
2. List out the student whose age above 17 years as on 1st December 2011 based on DOB Field.
3. List out the failed student based on Result filed. The result field having two types of value 1."Y" 2."N" if Y means "Pass" and if "N" means "Fail".
4.List out Sitting filed value equal to "3".
How to write?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only