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

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

Tim Haynes wrote:
> SQLGetInfo(SQL_IDENTIFIER_QUOTE_CHAR) is your friend:

Tim, that was very helpful, thanks a lot. I added a new odbc_getinfo
function to the odbc module which provides a direct wrapper of
SQLGetInfo(), so that I can now query all metadata. Fixing odbc_examp.q
so that it works with different RDBMS should be a piece of cake now!

While I'm giving the odbc module a facelift... I'd also like to support
user-defined functions written in Q (the sqlite3 interface already
provides these and I find them pretty useful). By any chance, do you
know whether ODBC provides an API for this kind of stuff? I'm looking
for an ODBC function which would allow to register a C callback as a UDF
to be called from SQL queries, which takes some SQL values as parameters
and returns another SQL value as the result. Googling around didn't turn
up anything useful so far.

Thanks,
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