Issue 114173 - Primary key in Base Forms are not shown
Summary: Primary key in Base Forms are not shown
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOO330m3
Hardware: PC All
: P2 Trivial (vote)
Target Milestone: OOo 3.3
Assignee: marc.neumann
QA Contact: issues@dba
Keywords: regression, release_blocker
Depends on:
Blocks: 111112
  Show dependency tree
Reported: 2010-08-28 16:38 UTC by Mechtilde
Modified: 2010-10-15 12:29 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description Mechtilde 2010-08-28 16:38:35 UTC
I use a mysql backend and the mysql connector

the form is formatted as a table.

If I input datasets the primary key is shown as "0" after leaving the row.

This isn't shown in the table. There is shown the right value. 

this is a regression against version 3.2.1. I guess it comes in with the cws
dba33g. so I will nominate it as a stopper.
Comment 1 r4zoli 2010-08-28 18:46:52 UTC
Same happens with OOO330m3/m5, ODBC driver (5.1.7 version)on win7.

I tested with native driver 1.0.1 alpha from qa-upload server, same "0" values
on PK. 
May be a side effect, if I use form on table ID (int), and text field, after
saving record, I can not change text field value on form, only if I reopen form.
And then PK values changed to normal values from "0".

If I use JDBC driver (5.1.13) this problem not happens, form works, add new
autovalue to PK and shows it on form.
Comment 2 ocke.janssen 2010-08-31 12:43:52 UTC
Fixed in cws dba33i
Comment 3 Frank Schönheit 2010-09-02 11:04:04 UTC
targeting to 3.3 then
Comment 4 Mechtilde 2010-09-06 18:38:48 UTC
I can verify the fix in CWs build dba33i

Thanks to the team

please integrate this CWS
Comment 5 ocke.janssen 2010-09-08 07:21:02 UTC
Please verify. Thanks.

- Open test mysql database
- Open table testdb.i114173
- enter a value
=> The ID column should be filled with the correct value and not with zero
Comment 6 r4zoli 2010-10-15 12:29:04 UTC
I checked in OOO330m10, ok. Closing.