To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=88921 Issue #|88921 Summary|problem with default current_timestamp using forms con |nected to MySQL Component|Database access Version|OOo 2.4.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|zeb_
------- Additional comments from [EMAIL PROTECTED] Thu May 1 14:53:24 +0000 2008 ------- Hi, I use Base as a frontend to connect to a MySQL database I built, using the JDBC connector. I have a table with a field supposed to keep the modification time: modified timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP I populate my table with Python or using insert commands from MySQL Query browser and as expected data entries are created and the 'modified' field receives the current timestamp. Now in Base I built a GUI with a table control capable of displaying other fields and the timestamp. Opening the base works and timestamps are correctly displayed. Interestingly, if I update a current entry, the timestamp is also updated accordingly (as expected because of 'on update CURRENT_TIMESTAMP'. However, if I try to create a new entry from the table control, I get this error message: Error writing data to database Input required in field 'modified'. please enter a value. Note that using insert within the MySQL query browser still works. Am I doing something wrong? Or is there something wrong with the way base posts the insert command to the database? Thanks. --------------------------------------------------------------------- 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]
