To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=74492
Issue #|74492
Summary|dBASE/Calc-queries in calculated columns unusable
Component|Database access
Version|OOo 2.1
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P2
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|reichowmi
------- Additional comments from [EMAIL PROTECTED] Tue Feb 13 14:49:56 +0000
2007 -------
I connected an existing dBASE-File to the Base-Frontend.
When creating a query in Design View I'm using a calculated column.
SQL-Command:
SELECT "TYPE", "NUMBER", SUBSTRING ( "REGISTER", 1, 8 ), "OVER", "USER", "TEXT"
FROM "ap010400"
Result:
TYPE NUMBER SUBSTRING("REGISTER", 1,8) OVER
A 1046 09:12:46 /
:
A 1032 10:12:27 10:12:41,13/01.04.00
A 1033 10:12:27 10:12:53,13/01.04.00
Now I added a LIKE-criterion in column TYPE.
SQL-Command:
SELECT "TYPE", "NUMBER", SUBSTRING ( "REGISTER", 1, 8 ), "OVER", "USER",
"TEXT" FROM "ap010400" WHERE ( ( "TYPE" LIKE 'A' ) )
Result:
TYPE NUMBER SUBSTRING("REGISTER", 1,8) OVER
A 1046 09:09:11 /
A 1032 09:12:46 10:12:41,13/01.04.00
A 1033 10:12:27 10:12:53,16/01.04.00
As you see, column SUBSTRING("Register", 1, 8) is now one line down.
The resulting new data records of this query are unusable, cause the result
in this column is wrong.
User Stefan Weigel reported, this this behavior is shown in Calc-files (ods)
too, when a calculated column exits.
This bug is also in OOo2.2m6.
---------------------------------------------------------------------
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
