Clepehibhef
New Member
hi im new to programming i have this small system for room reservations (school requirement). i have this question that is it possible to update the fields of my table on specific date?i have three tables naming users , reservations, and rooms. i want to update the field of the rooms on specific date, like if the date_out in the rooms table is the same as the sysdate it will update the status field from unavailable to available and make the room available again for choosing.also can this be able to do with function onLoad ?looking forward for your answers, thanks !-renz