>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 >>
INSERT INTO ... SELECT don't support ? parametersBug ?
SELECT COUNT(*) INTO CURSOR sit FROM Resident R WHERE r.dentree < m.dvd - 800