[unixODBC-support] Primary Keys in OpenOffice
nick.gorham at easysoft.com
Tue Dec 28 22:53:20 GMT 2004
Eric Sharkey wrote:
>SQLPrimaryKeys is level 1, not core, but, while I support SQLPrimaryKeys,
>there's a lot of other stuff in level 1 that I don't (and don't plan to),
>so I have to repsond "core", no?
yes, but it wouldn't hurt to check what openoffice does if you lie to it.
>>And of course the other option is to get the OpenOffice source and see
>>if that shows anything.
>I've done that and not been able to follow it. It's too big of a code
>base for a casual reader to easily work something like this out.
yes, its a bit huge, but the ODBC stuff is in one module, you could
search for SQLPrimaryKeys and see if there are any obvious flags around
it that give hints.
>At the moment, I'm trying to upgrade unixODBC to 2.2.10. The currently
>packaged Debian release is really really really old and includes a
>truncated value for the macro SQL_ODBC_KEYWORDS, which my driver
>returns in response to SQLGetInfo fro SQL_KEYWORDS. It may be the
>absence of "PRIMARY" and "KEY" in the keyword list which is causing OOo
>to not allow primary keyword creation in new tables.
Be carefull of SQL_ODBC_KEYWORDS. Read the docs, all you have to return
are the list of keywords your driver uses, that are _additional_ to the
list in the ODBC header file. So if the only keywords you have are
already in the list, you should return a empty string.
More information about the unixODBC-support