PRIVATE dvd dvd = DATE() ccondit1 = "IIF(ISNULL( e.iid ), ?dvd BETW TTOD( R.dentree ) AND IIF( EMPT( R.dsortie ) , ?dvd , TTOD( R.dsortie )),"+ ; "?dvd BETW e.ddebut AND IIF( EMPTY( e.dfin ) = .T.,"+; "IIF( e.ltransfert = .T. ,IIF(EMPTY( R.dsortie),?dvd ,TTOD( R.dsortie )),"+ "?dvd ),e.dfin))" INSERT INTO Sit ( nNombre, cCause ) ; SELECT COUNT( RECNO() ) , 'Résidants Présents dont :' FROM (AMLINE!Resident AS 'R'; LEFT OUTER JOIN AMLINE!Etats AS 'E' ON R.iid = e.iresidentid ) WHERE &ccondit1Missing expression (Error 152)
cCommand = "SELECT ... FROM ..... INNER JOIN " + "WHERE .... "+ " INTO CURSOR x" >&ccommand>