SET ENGINEBEHAVIOR 70 SELECT ; pi_id,; pitype_id,; MAX(expdate); FROM PI ; WHERE eqtype_id=2 AND equip_id=2246 ; GROUP BY 2; INTO CURSOR cc1in vfp 8 that gives me a group by error
SET ENGINEBEHAVIOR 80 SELECT ; pi_id,; pitype_id,; MAX(expdate); FROM PI ; WHERE eqtype_id=2 AND equip_id=2246 ; GROUP BY 1,2; INTO CURSOR cc1works but gives me all records because pi_id is the unique primary key (which i AM AFTER)