Re: [q-lang-users] ODBC connection with MS Access

[Albert G. <Dr....@t-...>]

Jiri Spitz wrote:
> I tried the new release candidate and it works now fine with both NULLs 
> and empty strings in parametrized queries.

Great. I also tested the new version with MySQL and PostgreSQL and the
workaround doesn't seem to cause any hiccups there, so I hope that we
can consider this solved.

I still have to fix up the "menagerie" example (odbc_examp.q), so that
it works with Access without any ado, but that will be in the final release.

BTW, does anyone here know a _portable_ way to quote column names which
are also SQL keywords? (MS SQL doesn't like these.) ANSI SQL mandates
double quotes, which works with both Access and PostgreSQL out of the
box, but not with MySQL. :(

Albert

-- 
Dr. Albert Gr"af
Dept. of Music-Informatics, University of Mainz, Germany
Email:  Dr....@t-..., ag...@mu...
WWW:    http://www.musikinformatik.uni-mainz.de/ag