FiveTech Support Forums

Dear Friend,
Look this please





the procedure does not show exactly the right reservation

on My archive I have the room n. 7 has a different date range



Why it show other dates ?



I explain You

I have RESERVA->CHECK_IN and RESERVA->CHECK_OUT on reserva.dbf and I must show the reservation

the final user can select the dates fron datepich control , the datepich are on the ribbonbar ( I select from 23.02.2013 to 23.02.2013)






when I show the bitmaps I made a dbseek on number of room to se the state of each room

IF RESERVA->( DbSeek( nRoom ) )

and then

IF DToS( RESERVA->CHECK_OUT ) > DToS( dStart ) .AND. DToS( RESERVA->CHECK_IN ) < DToS( dEnd )
nStato:= val(RESERVA->STATUS)
endif

ELSE
nStato:= 0

ENDIF




I tried also with

IF (DToS( RESERVA->CHECK_IN ) >= DToS( dStart ) .AND. DToS( RESERVA->CHECK_IN ) <= DToS( dEnd ) ) .OR.;
(DToS( RESERVA->CHECK_OUT ) >= DToS( dStart ) .AND. DToS( RESERVA->CHECK_OUT ) <= DToS( dEnd ))


but it make error !!!! ( the same)