>Hi all,
>
>
>I have a strange Missing operand (Error 1231)
>
>

>FUNCTION Test67()
>  USE C:\CDBK70\AMLINE\data1\Resident IN 0
>
>  PRIVATE condit
>  PRIVATE dvd
>
>  dvd = DATE()
>  condit = [resident.dentree < ?dvd - 800 ]
>
>  CREATE CURSOR Sit ( nombre I )
>
>  INSERT INTO Sit ( nombre ) ;
>    SELECT COUNT(*) FROM (AMLINE!Resident AS 'R' WHERE &condit
>  *-- Here i have Missing operand (Error 1231) ( with the condit clause).
>
> ENDFUNC
>

>
>When i replace ?dvd with Date() i hav'nt no error...
>
>Thank in advance
>
>bernhart

found:

INSERT INTO ... SELECT don't support ? parameters

Bug ?

Why no:

SELECT COUNT(*) INTO CURSOR sit FROM Resident R WHERE r.dentree < m.dvd - 800