Hi fabio,

Thank for help.

I have still the same error.
But if i use this code i have any more error....

  PRIVATE condit
  PRIVATE dvd
  dvd = DATE()
 *  condit = [ r.dentree < ?dvd - 800 ]

condit = [ r.dentree < DATE() ]

  CREATE CURSOR Sit ( nombre I )
  INSERT INTO Sit ( nombre ) ;
    SELECT COUNT(*) FROM Resident AS 'R' WHERE &condit

>

>>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
>
>1. typo or error ?
>(AMLINE!
>2. you rename the table with R, then
>condit = [r.dentree < ?dvd - 800 ]