Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hi I am using DBswing components

Status
Not open for further replies.

Gita21

Programmer
Nov 17, 2002
11
0
0
NZ
Hi

I am using DBswing components.

>> Course
>> ------
>> CourseID(PK)
>> CourseStartDate(PK)
>>
>> Registration
>> ----------
>> customerID (PK)
>> courseID(PK)
>> courseStartDate(PK)
>>
A person cannot register for a course where the courseStartDate is same as the courseStartDate for a course already registered by that customer.

I'm using these queryDataSets
Select * from person
Select * from course
Select * from registration where customerID =: personID (master link table person)

When I register a customer, I enter the courseID and courseStartdate.
When click save - I want to check that the courseStartDate entered
is not the same as a startDate already saved in the registration
table of that particular customer.
Because can't have a customer taking 2 courses at the same date.

I don't know how to go through the queryDataSet and check it.
Help pliz
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top