Menu

#50 Left() function problem

open
nobody
None
5
2006-04-04
2006-04-04
b2
No

The parsing fails on the following query:

select Left(StringField,5) as F1 from Table1

This is a correct MS-Access query using Left function
but gaSQLParser thinks that Left stands for a LEFT JOIN
and gives a StatusCode=errWrongKeywordSequence
(StatementState becomes sssJoinClause after sssFieldList)

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.