Why do Table controls in Base split underlying datetime fields into two separate columns? [closed]

asked 2014-11-04 07:33:54 +0200

calcman gravatar image

updated 2020-07-28 21:35:24 +0200

Alex Kemp gravatar image

A table control in a Base form splits underlying datetime fields into two columns (at least when connected to MySQL, I haven't tried with the native format).

The values appear as (for example):

fieldName 12/09/2008 13:54:02

in a table or query result, but as:

fieldName (date) 12/09/2009


fieldName (time) 13:54:02

in a form/subform table control. I presume this isn't a bug but rather deliberate behaviour. If so, what purpose does this serve? It seems to me to do more harm than good - what do you do if you want the date + time to appear together?

Also, I don't quite understand the reasoning behind Base's subform architecture. Unless this is buggy in v4.3.3.2 (and several prior versions [on Ubuntu]) subforms appear only as part of the reference model in the form navigator and do not appear to be contained within a bounded area - either do their fields - unless a table control is used. What purpose is served by the ability to add subform fields to a master form without any visual distinction if not "designed in" by the user? There being no bounded area, and hence no "continuous forms" option as in MS Access, the table control providing the equivalent of Access's "datasheet" view, it seems a little loose and liable to confuse - have I missed the point somewhere?


A little research suggests there is no "datetime" format as such in HSQLDB, only timestamp, date and time: http://hsqldb.org/doc/guide/sqlgenera...

...if this is the issue, has there been a decision not to coerce/degrade a MySQL "datetime" field to an HSQLDB "timestamp" field - wouldn't that be better than separate date and time values?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-03-05 19:55:36.660296