General information
Category:
Coding, syntax & commands
Strictly a SWAG, Phil, but can you try with a blank between last char. of line and semi-colon. I have heard of remedy with this move.
Good luck,
Jim N
>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
>
>TIA,
>Phil
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only