[unixODBC-support] Primary Keys in OpenOffice

Nick Gorham nick.gorham at easysoft.com
Tue Dec 28 16:38:34 GMT 2004

Eric Sharkey wrote:

>Does anyone on this list happen to know what OpenOffice needs in
>order to be able to mark a field in a new table as a primary key?
>I'm writing my own ODBC driver, and when I use my driver with OpenOffice
>and right click on the tab to the left of the field name in the table
>creation tool I'm not presented with the option of making a field into
>a primary key the way I am with other drivers.
>I can only presume that some magic needs to be returned from SQLGetInfo
>or SQLGetFunctions or similar in order to make this work, but I haven't
>been able to track down what, and the OpenOffice source code is
>My driver claims core level interface conformance, and implements all
>required functions.
>Has anyone run up against this?
Off the top of my head, I can't remember, but if you do a ODBC trace and 
look at ehat functions its calling it should give a hint. I would assume 
either SQLPrimaryKeys, SQLStatistics or SQLSpecialColumns


More information about the unixODBC-support mailing list