You have extra comma after the last field in the list (before FROM).

>Command contains unrecog phrase keyword error on the following.
>Wassup with that?
>I've experimented with set engi 70 and 90 but same error. A very similar SQL, just before this, to produce another similar cursor, using the same macro subs is fine.
>
>

>
>lcMacroBetween	= "BETWEEN( Jobs.Number, FromJob, ToJob)"
>lcOrderBy		= "JobNumber"
>Store 20 to  FromJob, ToJob
>...
>Select JobAct.*, Invoices.Number                  as InvNo, ;
>			  Jobs.Number			 	as JobNumber, ;
>			   UPPER( Jobs.Reference)	as JobRef, ;
>			   UPPER( Jobs.Text)		as JobDesc, ;
>	from JOBACT	;
>	INNER JOIN JOBS ;
>		on JobAct.JobID    == Jobs.ID ;
>	INNER JOIN INVOICES ;
>		on JobAct.OurInvID == Invoices.ID ;
>	into CURSOR csrJAs ;
>	where	&lcMacroBetween ;
>	and   	not EMPTY( OurInvID) ;
>	order by &lcOrderBy, InvNo, LineNumber, Subline
>

>
>
>'ppreciate it