Dear Nageswarao and Antonio,
I don't know if you remember in 2021 that Nages created a test to create an Isfree function to check in the archive if the umbrella was occupied or not.
This year I have a difficulty in the sense that the morning and afternoon or all day bookings have been added to the booking archive.
In practice there are two logical fields "Morning" and "Evening"
So you should modify the IsFree() lookup function for these two fields as well, because now the function does not work correctly
the search in the Nages function was
cSearch := oDbf:ApplyParams( cSearch, { oRec:rooms_id, oRec:type, oRec:RecNo, ;
oRec:check_out, oRec:check_in } )
now I don't understand if adding the other parameters can work
cSearch := oDbf:ApplyParams( cSearch, { oRec:rooms_id, oRec:type, oRec:RecNo, ;
oRec:check_out, oRec:check_in ,oRec:morning, oRec:evening} )
on picture there is a test not run ok see the first record
the room is occupated that period but only on the evening
so on the morning I can make a reservation but the procedure say to me it's occupated