dash or hyphen in field name not working #47
Description
I have the following SQL that is getting hung up on a field that contains a
dash in its name.
SELECT TableMain.Holw-serm-ID FROM TableImport INNER JOIN TableMain ON
TableImport.[Holw-serm-ID]=TableMain.[Holw-serm-ID] WHERE
TableMain.do_not_update IS NULL
I have tried putting the field quoted in [, ", and ` but makes no difference.
I get an ExQueryError with 'Field serm was not found'.
It seems the field name Holw-serm-ID is getting broken into TableMain.Holw,
serm and ID.
What version of the product are you using? On what operating system?
3.0.1
Original issue reported on code.google.com by bdwil...@gmail.com on 13 Aug 2013 at 8:47