This is to use Room frame a code as shown in figure

 @ Query (" SELECT * FROM the Monitor WHERE the date (add_date)=': the date' ORDER BY id desc ") 
List GetMonitorOfDay (String date); 

My SQL statement variables: the date joined the single quotes because take cannot be identified, escape characters is what excuse me have tried slash %

CodePudding user response:

Colon date directly, can not get rid of the single quotes

CodePudding user response:

reference 1st floor z1258_yh response:

colon date directly, can not get rid of the single quotes

This compilation is no problem, but, the SQL statement is wrong