[dba-features] new/CWS dba33b : allow to overrule Base's heuristics for primary key support

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[dba-features] new/CWS dba33b : allow to overrule Base's heuristics for primary key support

frank.schoenheit


       Product: Database Access
          Type: new
         Title: allow to overrule Base's heuristics for primary key support
     Posted by: [hidden email]
      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 [hidden email]



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]