FiveTech Software tech support forums

... are: 1) the rooms are divided into types so you need to create a combobox to select the type of rooms i.e. there could be no. 1 SS and n.1 DD 2) reservations can be for one day or many days if I insert some records having the same camera and a period from xx to 3) I cannot insert, modify, extend ...

Original idea by Silvio, implemented by Mr. Rao You can drag & drop the reservations using the mouse booking.prg #include "fivewin.ch"function Main()   local oDlg, oBrw, oFont, oCur   local aData := Array( 6, 11 )   local n   local ...

... days, because it has happened to us many times especially in the summer, how does an owner of an establishment such as a hotel to place orders and reservations? It gets stuck or goes back to doing it on the paper notes as it used to be connections, even in fiber optic mode, are not yet secure, ...

Silvio, I just discovered that records 3, 6 and 16 in the test Reserva.dbf (reservations) all have the same ROOMS_ID and TYPE with overlapping dates. Theoretically that can't happen. This prevents one of the tests from working since even when you attempt to add ...

... search, it just saves the record with the new dates. Simple. I would really think about having an alternative option for the user to find new reservations. Using a blank reservation screen, the user then enters any options the customer wants, i.e. Room id, room_type, check_in, check_out, etc. ...

... didn't sound like RESNO, RESID or similar, and I don't even know how big of a number is 18 digits long (1,000 trillion). Wow, that is a lot of reservations for only a 3 month period. Why such a huge field, maybe a government requirement? Also, it is traditional to have the ID field as the first ...

... Just build a routine that looks for all free rooms for the customer's desired date range. Collect them all and present in a browse of available reservations for the user to select from. They could also be sorted by room and/or type. James

... didn't sound like RESNO, RESID or similar, and I don't even know how big of a number is 18 digits long (1,000 trillion). Wow, that is a lot of reservations for only a 3 month period. Why such a huge field, maybe a government requirement? Also, it is traditional to have the ID field as the first ...

... ? I not have oReserva opened I Open a copy of reserva on that function and then close it Only when I show the beach planning I check if there are reservations on reserva.dbf but then I close it that is I not have reserva.dbf opened, I 'm trying to not have the databse opened but open the dbf when ...

... strsso room_id could have many bookings with different periods, and excluding the room_id you would risk making a mes if, for example, I have two reservations of the same number, one from 08/07/2021 to 28/07/2021 and the other reservation from 29/07/2021 to 29/07/2021 and I exclude the room_id ...

Hi Silvio: If you do not use the cargo of each btnbmp, you can use that data to save an array with all the reservations that that umbrella has in the selected period. It's an idea. i did it this way open reservation filter reservation with my parameter( range date, number and ...

Hi Silvio:
If you do not use the cargo of each btnbmp, you can use that data to save an array with all the reservations that that umbrella has in the selected period.
It's an idea.

when I show the beach (using btnbmp) I go to look for reservations for each umbrella making a filter with the period requested by the user. https://i.postimg.cc/cJ6bSLnh/spiaggia.jpg with a do while loop the procedure loads only the ...

... chalet by the sea it is two days for the search ( my problem) when the operator goes to modify a range of dat, the procedure should check in the reservations archive if there is already a reservation in that date range (fields check_in and check_out) for that number (field rooms_id) and for that ...

... to the reservation database. CUSTOMERS.DBF FIELDS: CUSTNO (primary key, unique) FIRSTNAME LASTNAME RESERVS.DBF FIELDS: (You could have multiple reservations for the same CUSTNO) RESERVNO (primary key, unique) CUSTNO RESERVITEMS.DBF FIELDS: (Multiple items per RESERVNO) RESERVNO (primary key, ...