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

Using TIME field

8 years 2 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.124 seconds
Powered by Kunena Forum

We use cookies so that you can place orders and we can provide a better service. You can control the use of cookies at the individual browser level. If you reject cookies, you may still use our website, but your ability to use some features or areas of our website may be limited.