Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Syntax
Message
From
14/01/2009 21:35:41
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
14/01/2009 19:45:04
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01373839
Message ID:
01373878
Views:
15
If I remove the ORDER BY clause, it works. Any ideas?

>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
>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform