[unixODBC-support] Primary Keys in OpenOffice

Eric Sharkey sharkey at netrics.com
Wed Dec 29 15:06:17 GMT 2004


> >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.

This change seems to have no effect.  I can't set a primary key regardless
of whether I claim to be core, level 1, or level 2.

> 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.

I did that before posting here and I wasn't able to find anything
obvious.

> 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.

Thanks.  I missed that.  I'm reading the docs religiously, but there
are a lot of details..

Eric



More information about the unixODBC-support mailing list