>Hi all,
>
>The following SELECT-SQL statement runs and compiles fine in FPW2.6, but generates a syntax error at compile and runtime in VFP5.0...any thoughts?
>
>*
>* Hard to read here, I know...I lost all of the formatting when I
>* pasted it in here...
>*
>SELECT insp_no, start_dt AS start_dt, start_hr, start_mn, end_dt AS end_dt, end_hr, end_mn, PADR(spGetDesc(activity, laActivities), 50) AS task, 'S' AS type FROM schedule UNION ;
> (SELECT insp_no, insp_dt AS start_dt, start_hr, start_mn, insp_dt AS end_dt, end_hr, end_mn, PADR(GetTask(insp_tp), 50) AS task, 'A' AS type FROM mvi_actv UNION ;
> (SELECT insp_no, insp_dt AS start_dt, start_hr, start_mn, insp_dt AS end_dt, end_hr, end_mn, PADR('MVI Inspection', 50) AS task, 'A' as type FROM mvi_insp UNION ;
> (SELECT insp_no, insp_dt AS start_dt, start_hr, start_mn, insp_dt AS end_dt, end_hr, end_mn, PADR('CVSA Inspection', 50) AS task, 'A' as type FROM cvsainsp UNION ;
> (SELECT insp_no, insp_dt AS start_dt, start_hr, start_mn, insp_dt AS end_dt, end_hr, end_mn, PADR('Premise Inspection', 50) AS task, 'A' as type FROM preminsp UNION ;
> (SELECT insp_no, insp_dt AS start_dt, start_hr, start_mn, insp_dt AS end_dt, end_hr, end_mn, PADR('Dealer Premise Inspection', 50) AS task, 'A' as type FROM dealprem UNION ;
> (SELECT insp_no, insp_dt AS start_dt, insp_hr AS start_hr, insp_mn AS start_mn, end_dt, end_hr, end_mn, PADR('Mobile Inspection', 50) AS task, 'A' as type FROM mob_main UNION ;
> (SELECT insp_no, insp_dt AS start_dt, insp_hr AS start_hr, insp_mn AS start_mn, end_dt, end_hr, end_mn, PADR('VCS Inspection', 50) AS task, 'A' as type FROM vcs_main))))))) ;
>WHERE BETWEEN(start_dt, ldstart_dt, ldend_dt) ;
>ORDER BY 9, 1, 2, 3, 4, 5, 6, 7, 8 ;
>INTO CURSOR curtemp
According to the online help, you should move up the INTO option:
SELECT ...
FROM ...
INTO ...
WHERE ...
GROUP BY ...
HAVING ...
UNION ...
ORDER ...