H!, i am currently doing my thesis, my thesis is all about enrollment system, i'am in a part 2 of my thesis which is the developing of enrollment system.
i have a scheduling module on our program, and i want the program not to accept a conflict time..
for example, if have a table of "Schedule" and two columns Start_time and End_time on table, then i will input
a record
for example:
start_time:6:00
End_time 7:00
then if i will add another record but has a conflict on the existing record
for example:
Start_time: 6:30
End_time:7:00
then the system will still accept the record
Now, my question is, how can i detect the conflict based on what i said before.
heres the systax that i've used:
select*from Schedule where Start_time>='"& startime.value &"' and End_time<='"& Endtime.value &"'
i have a scheduling module on our program, and i want the program not to accept a conflict time..
for example, if have a table of "Schedule" and two columns Start_time and End_time on table, then i will input
a record
for example:
start_time:6:00
End_time 7:00
then if i will add another record but has a conflict on the existing record
for example:
Start_time: 6:30
End_time:7:00
then the system will still accept the record
Now, my question is, how can i detect the conflict based on what i said before.
heres the systax that i've used:
select*from Schedule where Start_time>='"& startime.value &"' and End_time<='"& Endtime.value &"'
