>>This is a SQL statement that is created in code. I'm getting this error:
>>
>>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
>>
>
>Is this from VFP native or from VFPOleDB? The reason I ask is that the only time I got this type of message was from the VFPOleDB which is causing some weird errors under IIS. As for that situation, I see that are no space after []. Could it be a factor?
No, just straight VFP in a PRG right now for testing.