Check the value of goApp.noreport at the time of error.

>when I use this request I do not have any error.
>
>

>SELECT  PADL( ALLTRIM( cnosecretariat) ,7 , "0" ) AS 'cnosecretariat',;
>  TRANSFORM( iemployeid , "@L 9999999" ) AS 'iemployeid',;
>  Tempx.ddate,;
>  iplanpauseid,;
>  SurSalaire,;
>  PADL( TRANSFORM( INT( SUM( totheure ) * 100 ), 4 ) , "0" ) AS 'TotHo' ,;
>  MAX( Planpause.cnom ) AS 'cnomPlanpause',;
>  MAX( PADL( Planpause.cnomsecsocial , 4 , "0" ) ) AS 'cnomsecsocial',;
>  SPACE(4) AS cSdCode ,;
>  MAX( IIF( ISNULL( D.djour ) , .F. , .T. )) AS 'jf',;
>  MAX( Planpause.lnuit ) AS 'lnuit',;
>  MAX( 'K' ) AS 'cType',;
>  PADL( ALLTRIM( ls_numdossier ) ,7 , "0" ) AS 'cSdNummer';
>  FROM Tempx ;
>  INNER JOIN Planpause	ON  Tempx.iplanpauseid = Planpause.iid ;
>  LEFT JOIN DatesFiltred D ON D.djour = Tempx.ddate ;
>  GROUP BY 1,2,3,4,5 READWRITE INTO CURSOR cursorfinal
>
>

>
>
>On the other hand, when I use a filter with the clause “where” I have an error: (No 11 )
>"Function argument value, type, or count is invalid."
>
>

>SELECT  PADL( ALLTRIM( cnosecretariat) ,7 , "0" ) AS 'cnosecretariat',;
>  TRANSFORM( iemployeid , "@L 9999999" ) AS 'iemployeid',;
>  Tempx.ddate,;
>  iplanpauseid,;
>  SurSalaire,;
>  PADL( TRANSFORM( INT( SUM( totheure ) * 100 ), 4 ) , "0" ) AS 'TotHo' ,;
>  MAX( Planpause.cnom ) AS 'cnomPlanpause',;
>  MAX( PADL( Planpause.cnomsecsocial , 4 , "0" ) ) AS 'cnomsecsocial',;
>  SPACE(4) AS cSdCode ,;
>  MAX( IIF( ISNULL( D.djour ) , .F. , .T. )) AS 'jf',;
>  MAX( Planpause.lnuit ) AS 'lnuit',;
>  MAX( 'K' ) AS 'cType',;
>  PADL( ALLTRIM( ls_numdossier ) ,7 , "0" ) AS 'cSdNummer';
>  FROM Tempx ;
>  INNER JOIN Planpause	ON  Tempx.iplanpauseid = Planpause.iid ;
>  LEFT JOIN DatesFiltred D ON D.djour = Tempx.ddate ;
>  WHERE Tempx.itelephoneid = ;
>  ( SELECT itelephoneid FROM cfiltre WHERE cfiltre.lactif = .T. AND ;
>  cfiltre.ireport = goApp.noreport AND ;
>  cfiltre.itelephoneid = tempx.itelephoneid );
>  GROUP BY 1,2,3,4,5 READWRITE INTO CURSOR cursorfinal
>

>
>Where is the error? Thank you advances some for the assistance
>
>bernhaet