>Hi All:
>
>Can you help me with this code? What's wrong with this syntax?
>
>

>SET STRICTDATE TO 0
>

You're missing "AS" before flocknum.


SELECT MAX(flocknum) FROM ;
(SELECT SUBSTR(fm_flcode,5,4) AS flocknum ;
FROM flckmast ;
WHERE fm_hatched <= {4/1/07} ;
AND fm_hatched >= {3/1/07} ;
) ;
INTO CURSOR test

>
>Thanks,
>
>Yossi