× This forum has been locked. Please submit new Feature Requests on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues

Using TIME field

Gordon

Junior Member

Posts: 22

10 years 6 months ago #42 by Gordon

Using TIME field was created by Gordon

Probably more of an observation, due to my lack of SQL expertise.

Whenever you try to apply a limit to the TIME type field (e.g. SIZE 5 to a TIME field to drop off the seconds so you get 00:00) it generates a SQL error when you try to install the component. I know you are probably going to say well "don't do that."

My point is you probably need to drop the SIZE entry for a TIME field so others don't do the same thing. Also there are probably other fields (in the normal SQL types) that allow "people to do the wrong thing," that need attention.

Never doubt that a small group of committed people can change the world. Indeed, it is the only thing that ever has... Margaret Mead

Gordon Wright
Old fart developer

The following user(s) said Thank You: Søren Beck Jensen

Please Log in or Create an account to join the conversation.

Time to create page: 0.053 seconds