> >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 >>