Where clause with Date Error

[robin]

James,

Using latest C#.net parser version and setting database vendor to Ms Access, the following code:

SELECT [T1].[F1], [T1].[F2], [T1].[F3] FROM [T1] WHERE [T1].[F3] = #4/1/2008 3:09:29 PM#

produces the following error message from the parser (result code of 1).

3(1,78) expected token:; ) * + , - / = > WHERE HAVING AND OR NOT ON JOIN FROM GROUP ORDER UNION

Of course [T1].[F3] is of datetime datatype. Oddly, if I change the # to apostrophes (') around the date in the Where clause, the parser will work. Access however uses the # around dates and won't execute with the apostrophes around the date (does work in Access with the # around the date).

If this is a parser error, please send me a fixed version.

Thanks
Robin

[james]

GSP doesn't support # around dates of ACCESS, please PM your Order number so we can start a ticket to fix this bug in time.

[robin]

When is this expected to be fixed. I am displaying color coded query statement using a rich textbox and your color formatting options but since it won't parse correctly, I get single color making the user believe there is a syntax error. Really could use this soon.

Thanks,
Robin

[james]

Fixed in version 1.12.13

[robin]

Great. When will this version be downloadable?

[james]

It's available now.

http://www.sqlparser.com/download.php