To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=114310
Issue #|114310
Summary|wrong reading from tables under windows 7 64 bit
Component|Database access
Version|OOO320m18
Platform|All
URL|
OS/Version|Windows 7
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|cglania
------- Additional comments from cgla...@openoffice.org Sat Sep 4 17:00:06
+0000 2010 -------
Hi,
under windows XP, I created an ooo base database. In a simplified view, it
contains families and persons. The family table has familiy number as key, the
person table has a person number as key and a foreign key relation to the
family number in the family table.
Example table records are:
Family Table:
Family No family name
10 Smith
20 Miller
Person Table
Person no Family No Person name
101 10 John Smith
102 10 Lisa Smith
201 20 Henry Miller.
As long as I used windows XP, this worked fine in all tables, forms, queries
and reports.
No I have a new PC with windows 7, 64 bit.
When I open the existing database on the new PC, and display the content of the
the person table, I get:
Person no Family No Person name
101 10 John Smith
101 10 John Smith
201 20 Henry Miller.
So instead of the recors 101 and 102, I get twice the record 101 (in spite of
the primary key on the person no).
The same error occurs in forms which display data from both tables, and in
queries accessing the person table only.
Deeply below the system still knows the correct data: I cannot create a second
record with key 102 via a form, although the existing 102 record is not
displayed.
Only in queries which access both tables, the result is correct.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
