Product: Database Access
Type: new
Title: allow to overrule Base's heuristics for primary key support
Posted by: [email protected]
Affected: -
TaskId: i104329
<http://www.openoffice.org/issues/show_bug.cgi?id=104329>
Effective from: CWS dba33b
CWS:
<http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300/dba33b>
CWS status: new
*Flags*
-------
API/ BASIC [ ]
Configuration [ ]
File format change [ ]
Help/ Guide [x]
Performance test [ ]
Translation [x]
UI relevant [x]
*Description*
-------------
When connecting to a database via a generic API like ODBC, JDBC, ADO,
Base currently applies a heuristics to determine whether or not this
database supports primary keys, because none of those APIs has
dedicated support to retrieve this information. Depending on the
Since the heuristics sometimes fails, there's now an explicit option
(Edit / Database / Advanced Settings) named "Supports primary keys".
It's implemented as a usual tri-state check box, where un/check mean
"do (not) assume PK support", and the "undetermined" third state,
which is the default, means "apply the heuristics".
Note that if this option is just for overruling the heuristics. If you
check it for a database which actually does not support primary keys,
you'll probably be slain with error messages as soon as Base attempts
to actually use PK related features (like creating a PK in the table
designer).
Send feedback to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
