Thank walther,

I progress but I still have problems

 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 &ccondit1

Missing expression (Error 152)
when I replace dvd by date() all functions well.

What can i do ?

Bedank

bernhart




>Hi bernhart,
>
>>Bonjour Walter,
>>
>>What do we do if a macro is larger than 254 caractères ?
>
>You can use macro substitution with strings larger than 254 character. Probably them problem is that you cannot have literal string larger than that. so a work arround might be:
>
>

cCommand = "SELECT ... FROM ..... INNER JOIN " + "WHERE ....  "+ " INTO CURSOR x"
>&ccommand

>
>Walter,