RunSQL = 'SELECT ' + lcFields + ' FROM ' + lcTable + IIF(!EMPTY(lcOrderField),' ORDER BY ' + lcOrderField, '') + ' INTO CURSOR ReportCursor' &RunSQL>Why not use CAST('' AS CHAR(1)) instead? As in
>CAST('' AS CHAR(1)) as FLD8 >>
>>SQL: Column ' ' is not found. >>>>This is the SQL:
>>SELECT ; >>SEQ_NUM AS Fld1, ; >>DOC_CODE AS Fld2, ; >>DAY_WEEK AS Fld3, ; >>OFF_CODE AS Fld4, ; >>FROM_TIME AS Fld5, ; >>TO_TIME AS Fld6, ; >>MARK_LEVEL AS Fld7, ; >>[ ]AS Fld8 ; >>FROM SCHDOC2 ; >>ORDER BY RIGHT(" "+doc_code,2)+RIGHT("000"+seq_num,3) ; >>INTO CURSOR ReportCursor >>