[mdb-dev] SQL parsing

[Jeff S. <why...@ya...>]

I will soon be taking a look at some of the SQL/ODBC issues raised recently, but first I
want to take care of something a little more fundamental.

Currently, we parse SQL syntax something like this...
  123 - numeric constant
  xyz - identifier
  'xyz' - string constant
  "xyz" - identifier

Access does it more like this...
  123 - numeric constant
  xyz - identifier
  'xyz' - string constant
  "xyz" - string constant
  [xyz] - identifier

I have a patch to change the parsing to the latter, but I am probing for any objections
before I apply.  My personal feelings are we run the least risk by trying to match Access
as closely as reasonably possible.

 -- Jeff Smith


		
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail