>Hi All: > >Can you help me with this code? What's wrong with this syntax? > >
>SETSTRICTDATETO0
>
You're missing "AS"before flocknum.
SELECTMAX(flocknum) FROM ;
(SELECTSUBSTR(fm_flcode,5,4) AS flocknum ;
FROM flckmast ;
WHERE fm_hatched <= {4/1/07} ;
AND fm_hatched >= {3/1/07} ;
) ;
INTOCURSOR test
> >Thanks, > >Yossi
Cathy Pountney, Microsoft Visual FoxPro MVP Memorial Business Systems, Inc. (www.mbs-intl.com)