To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=57005 Issue #:|57005 Summary:|Base embedded db Create view changes case Component:|Database access Version:|OOo 2.0 Platform:|All URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|atjensen
------- Additional comments from [EMAIL PROTECTED] Sun Oct 30 18:53:06 -0700 2005 ------- I created a new Db using 2.0.0 Created table Created a query against that table, in SQL view. This uses SQL direct. After saving the query selected 'Created as Vew' against the query object. Using the created VIEW in a a form worked fine, until I closed and reopend the Base file. Then when opening the form that used the view received the error that the column could not be found. Checked the column names on the saved View, the first column name had been changed from mixed case to all upper case. Here is the SQL statement from the query that was subsequently used to create the view. select "PatientID", CASE WHEN datediff( 'yy', "DOB", CURRENT_DATE ) <> 0 THEN CAST(datediff( 'yy', "DOB", CURRENT_DATE ) AS VARCHAR) || ' Yrs' WHEN datediff( 'mm', "DOB", CURRENT_DATE ) <> 0 THEN CAST(datediff( 'mm', "DOB", CURRENT_DATE ) AS VARCHAR) || ' Mos' else CAST(datediff( 'dd', "DOB", CURRENT_DATE ) AS VARCHAR) || ' Dys' END as "Age" from "patients" If you select edit on the veiw, the first colum is listed as PATIENTID. --------------------------------------------------------------------- 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]