Re: Length of smallint field
What account is banned by Google?? and what is TOS violation? Ian Michael Gumby wrote: > On Sep 10, 3:18 pm, monkeys paw <u...@example.net> wrote: >> I have a table with a smallint field. A number is entered into >> a 4gl form. I need it to be 0 padded, four digits wide. however, >> the LENGTH() function doesn't work on smallint fields. So whether >> user enters "600" or "0600", the length call below returns 0. >> How can i get around this, i need it entered in military time >> by the user, they must enter preceeding zero if time is less >> that 1000, like "0900". >> >> let len = length(calRec.hearing_time) >> message len > > Wow, an account that has been banned by Google for a TOS violation. > > Everett has it right. If you're using a field to enter time in a > "military" fashion, use characters. > Then use your after field statement to validate the entry. If a non > numeric is entered then you can > fix it. If they enter 6:00 you can update it to mean 06:00. > If you need to do any calculations, you can strip leading 0's and or > whitespace and then convert to a number and perform calculations.
In article <NP6dnQM1Y6TipVTVnZ2dnUVZ_jmdnZ2d@insightbb.com>, monkeys paw says... > >What account is banned by Google?? >and what is TOS violation? Your account. If I click on your profile, this is what I get Profile This account has been banned because it violated the Google Groups Terms Of Use. Enter an email address to look up the profile for an author: What did you do to earn this distinction.
I like IBM wrote: > In article <NP6dnQM1Y6TipVTVnZ2dnUVZ_jmdnZ2d@insightbb.com>, monkeys paw says... >> What account is banned by Google?? >> and what is TOS violation? > > > Your account. If I click on your profile, this is what I get > Profile > > > This account has been banned because it violated the Google Groups Terms Of Use. > > Enter an email address to look up the profile for an author: > > > > What did you do to earn this distinction. > I really don't know where my dubious honor came from, some folks claimed i was a troll in the alt.bowling group long ago :)
monkeys paw wrote: > I like IBM wrote: > >> In article <NP6dnQM1Y6TipVTVnZ2dnUVZ_jmdnZ2d@insightbb.com>, monkeys paw says... >> >>> What account is banned by Google?? >>> and what is TOS violation? >>> >> Your account. If I click on your profile, this is what I get >> Profile >> >> >> This account has been banned because it violated the Google Groups Terms Of Use. >> >> Enter an email address to look up the profile for an author: >> >> >> >> What did you do to earn this distinction. >> >> > > I really don't know where my dubious honor came from, some > folks claimed i was a troll in the alt.bowling group long ago :) > I feel your pain. It's awful being falsely accused of trolldom, isn't it? :o( -- Cheers, Obnoxio the Clown http://obotheclown.blogspot.com
In article <BeKdnZluzuJnzlTVnZ2dnUVZ_tjinZ2d@insightbb.com>, monkeys paw says... > >I really don't know where my dubious honor came from, some >folks claimed i was a troll in the alt.bowling group long ago :) I don't think you did anything wrong. The trouble is you are using a generic email address: user @ example.net. A simple search on google groups tells that different people have used this address.