Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Syntax
Message
From
14/01/2009 19:45:04
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL Syntax
Miscellaneous
Thread ID:
01373839
Message ID:
01373839
Views:
56
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
Next
Reply
Map
View

Click here to load this message in the networking platform