×
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: 23
10 年 5 个月 前 #42
由 Gordon
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
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.
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 登录 或 注册一个帐号 to join the conversation.
创建页面时间:0.051秒