To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=53331
Issue #:|53331
Summary:|Updateable Query discards insert record
Component:|Database access
Version:|680m123
Platform:|All
URL:|
OS/Version:|All
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|none
Assigned to:|dbaneedsconfirm
Reported by:|atjensen
------- Additional comments from [EMAIL PROTECTED] Mon Aug 15 05:35:12 -0700
2005 -------
After creating an updateable query such as this:
SELECT "STUDENTS"."ID" AS "STUDENTSID", "STUDENTS"."FirstName",
"STUDENTS"."LastName", "STUDENTS"."email", "STUDENTS"."COURSEID", "MARKS"."ID"
AS "MARKSID", "MARKS"."STUDENTID", "MARKS"."MARKFOR", "MARKS"."MARK",
"MARKS"."COMMENTS" FROM { OJ "MARKS" "MARKS" LEFT OUTER JOIN "STUDENTS"
"STUDENTS" ON "MARKS"."STUDENTID" = "STUDENTS"."ID" }
opening in a db browser window and attempting to insert a record, only the data
entered for the secondary table (MARKS in this case) will be written. The data
for the primary table (STUDENTS here) is discarded.
---------------------------------------------------------------------
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]
