Thank Fabio,

It was a simplified example....:)

THIS.ccondit1 = [((ISNULL( E.iid )=.T. AND ?dvd => TTOD(R.dentree) AND ( ?dvd =< TTOD(R.dSortie) OR R.dSortie ={})) OR ]+;
[(?dvd >= E.dDebut AND (?dvd =< E.dFin OR (E.dFin={} AND (!E.lTransfert OR R.dSortie = {} OR ?dvd =< TTOD(R.dSortie))))))]


i can use this code
.ccondit1 = STRTRAN( .ccondit1, "dvd", "date()" , 1 , 25 , 1)


bernhart




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