Hi Sir/Madam
I have a Room Reservation database, CHECK CONSTRAINT has been applied to the RoomOccupations table to prevent double booking of the same room by intersecting ranges:
However, I am facing a problem that every time I wants to book consecutive bookings , an error message of CHECK CONSTRAINT appears as applied by me only, although there is a vacant room. For doing the same I have quit the database and re-login into it.
I don't know way its happening
I have a Room Reservation database, CHECK CONSTRAINT has been applied to the RoomOccupations table to prevent double booking of the same room by intersecting ranges:
However, I am facing a problem that every time I wants to book consecutive bookings , an error message of CHECK CONSTRAINT appears as applied by me only, although there is a vacant room. For doing the same I have quit the database and re-login into it.
I don't know way its happening