*create the query string
lcQuery = "SELECT a.Handle, a.Hrid, a.EmployeeID, a.FirstName, a.LastName, NVL(b.VarInt, 3) AS RoleID,
        b.Description, b.Created
       FROM Employee!EmployeeMaster a
        LEFT JOIN Employee!EmployeeAttributes b ON b.HRID=a.HRID AND b.AttrTypeID=303
       WHERE a.Active
        AND a.LocID = 12332
        AND a.WorkCenter = 'L7147'
       INTO CURSOR tmpData"

*execute the query
&lcQuery

*this fails stating "Command contains unrecognized phrase/keyword" because the string is too long...
*this query will not always be the same and may be longer than this...
*so I'm looking for a dynamic way to split up the string into smaller segments so it doesn't bre
*execute the query
&lcQuery

*this fails stating "Command contains unrecognized phrase/keyword" because the string is too long...
*this query will not always be the same and may be longer than this...
*so I'm looking for a dynamic way to split up the string into smaller segments so it doesn't bre
*this fails stating "Command contains unrecognized phrase/keyword" because the string is too long...
*this query will not always be the same and may be longer than this...
*so I'm looking for a dynamic way to split up the string into smaller segments so it doesn't bre
*this query will not always be the same and may be longer than this...
*so I'm looking for a dynamic way to split up the string into smaller segments so it doesn't bre
*so I'm looking for a dynamic way to split up the string into smaller segments so it doesn't break