On 2/22/2010 2:23 AM, Peter Eberlein wrote:
Hi,

anybody from the base team there who can confirm
http://www.openoffice.org/issues/show_bug.cgi?id=109185



Hi Peter,

I don't have an Oracle server running at the moment, sorry.
There will be one up here by the end of the week, but not
any sooner.

I think however you are right about the Base time control.

To test it I used MySQL

Created a datetime field and bound a Time control on a form reading directly from the table.
Everything is fine.

Then created a query that cast the datetime field to a date, aliases back to the same name of course. Changed the form to now read the query instead of the table - the time field will not read time values.

So - for a work around, when you need to use a time control for a Date field I think you will need to use a query that casts to a timestamp.

Does that mean also that in a dataview window only the Date portion if a date field, that has time data, is displayed?

Drew








---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Reply via email to