carriage return line feed problem?
I couldn't figure out the differences until I loaded the 'good' code and the 'bad' code into a hex editor. The end of all my lines in the 'good' code have the ASCII carriage return line feed characters in it... (0D 0A), whereas in the 'bad' code some of the lines contain the carriage return (0D), but not the line feed (0A).
My theory as to why it made my code fail with the above error is because the line in question contained a comment at the end
sql code here --followed by a comment more sql code hereI believe the compiler interpreted the 2nd line as being part of the same comment, therefore causing the error.
Visually they look the same in my query editor. When I added the line feed character and tried again, it worked just fine.
Is this a know bug?
Has anyone else experienced this type of problem?
Is it going to get fixed?