https://bugs.freedesktop.org/show_bug.cgi?id=82688
--- Comment #8 from Lionel Elie Mamane <[email protected]> --- (In reply to Julien Nabet from comment #7) > I'll quote Christian Werner, maintainer of sqllite odbc: > " > SQL_OSC_MINIMUM is what > SQLite and the driver can provide, higher values would be a cheat. There are > other means in the ODBC spec to find out if a primary key is available on a > table, think e.g. of SQLPrimaryKeys() > " The question is not whether a particular table has a primary key (which is the question SQLPrimaryKeys() answers), but whether the database supports the concept of primary key in general, and (I guess) whether in its DDL SQL (Data Definition Language) it supports the SQL-standard way of adding a primary key. >From a pure ODBC point of view, we might be able to get this information from SQLGetInfo(SQL_CREATE_TABLE) or something like that (might be what is meant by SQL_CT_TABLE_CONSTRAINT)... Need to check. Also need to check whether this can map "cleanly" to some JDBC/SDBC interface to go through the layers of abstraction in LibreOffice :) That is probably, one of the "supportsFoo" in https://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html References for later usage: ODBC Minimum grammar (no mention of primary key from a cursory glance): http://msdn.microsoft.com/en-us/library/ms711725%28v=vs.85%29.aspx ODBC SQLGetInfo reference: http://msdn.microsoft.com/en-us/library/ms711681%28v=vs.85%29.aspx Haven't found the exact definition of SQL Core / Extended grammar (should be somewhere...) but here's a third-party high-level description I've found: https://www.progress.com/products/datadirect-connect/odbc-drivers/odbc-developer-center/odbc-definitions -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
