Hi all,
I'm trying the new OOo 3.0 Base in stead of Access 2007.
The system is:
OS: OpenSUSE 10.3 - Linux ~ 2.6.22.19-0.1-default #1 SMP 2008-10-14
22:17:43 +0200 x86_64 x86_64 x86_64 GNU/Linux
Openoffice: OpenOffice.org 3.0.0, OOO300m9 (Build:9358), Copyright
2000-2008 Sun Microsystems Inc., Build 3.0.0.3.5
I have 3 Tables. Table 1: 3 Col x 11227 Rows (ABC-SAM-Nr-Realtion)
Table 2: 8 Col x 16987 Rows
(erp2-Inventa-81203)
Table 3: 3 Col x 2559 Rows
(SAM-Article-Invent-2008-1)
## Problem 1 ##
When I create relationships between the tables, save it and open it up
again; the relationships are gone. If I open up the relationships again,
the tables are there, but the field-links are gone. If I redo them and
save again, they are lost again on opening up the relationships.
## Probblem 2 ##
If I try to create a query that links the three tables, errors ( SQL
Status: S1000 Error code: 72 out of memory) occur, probably as a result
of the failing relationships.
Error list:
Error 1:
The data content could not be loaded.
Error 2:
SQL Status: S1000
Error code: 72
out of memory
Information:
The SQL command leading to this error is:
SELECT "SAM-Article-Invent-2008-1"."Article SAM" AS "Article SAM",
"SAM-Article-Invent-2008-1"."Number " AS "Number",
"SAM-Article-Invent-2008-1"."Storenr" AS "Storenr",
"ABC-SAM-Nr-Realtion"."ABC-Articlenumber" AS "ABC-Articlenumber",
"ABC-SAM-Nr-Realtion"."Article-Nr (ART:Descr)" AS "Article-Nr
(ART:Descr)", "ABC-SAM-Nr-Realtion"."Descr-wo suffix (ART-Note)" AS
"Descr-wo suffix (ART-Note)", "erp2-Inventa-81203"."Count-Nr." AS
"Count-Nr.", "erp2-Inventa-81203"."Storenr" AS "Storenr",
"erp2-Inventa-81203"."Article " AS "Article",
"erp2-Inventa-81203"."Descr-Name" AS "Descr-Name",
"erp2-Inventa-81203"."Number" AS "Number",
"erp2-Inventa-81203"."Unit-Price" AS "Unit-Price",
"erp2-Inventa-81203"."TotalVal " AS "TotalVal ",
"erp2-Inventa-81203"."Diff Val " AS "Diff Val" FROM
"SAM-Article-Invent-2008-1" "SAM-Article-Invent-2008-1",
"ABC-SAM-Nr-Realtion" "ABC-SAM-Nr-Realtion", "erp2-Inventa-81203"
"erp2-Inventa-81203" ORDER BY "erp2-Inventa-81203"."Count-Nr.",
"erp2-Inventa-81203"."Article", "SAM-Article-Invent-2008-1"."Storenr"
What now? The query is empty.
How can the relationships problem be solved first of all. Perhaps then
the error will also disappear thereafter.
:-)
Al
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
