next »

[Jeremy G.]

Hello,

I want to format integer input value, but I can't make it working.

I defined "INCLUDE = (0 TO 99999999999999)" in include properties, if I'm right, the only values accepted should be beetween 0 to 99999999999999, but i can put for example : "0srtgtrgrs" and the value is accepted.

My need : a user insert "0101010201" value
I want to display it in the input "01 01 01 02 01", I tried to insert [## ## ## ## ##] in format properties of the widget but I'm wrong it doesn't works.

Regards

[Sebastien F.]

Hello Jeremy,

You may want to try the PICTURE attribute.

However, if you allow spaces in the value, it will not be an INTEGER, it will be stored in a CHAR(n) or VARCHAR(n)...

With PICTURE="## ## ## ## ##" you don't need a FORMAT attribute, assuming that CHAR/VARCHAR values which are displayed are already properly formatted...

https://4js.com/online_documentation/fjs-fgl-manual-html/?path=fjs-fgl-manual#c_fgl_FSFAttributes_PICTURE.html

Seb

[Reuben B.]

The question was posted in Studio section of the forum so the more appropriate link maybe to the picture property in the Form Designer part of the Studio documentation https://4js.com/online_documentation/fjs-gst-manual-html/#c_gst_formdesigner_properties_PICTURE.html (although it should be the same meaning as the FGL documentation link Seb provided, sometimes Studio/.4fd property names and Genero/.per attribute names don't match)

Jeremy: Sometimes it helps to give the underlying business reason of what you are trying to do.  So in this case, with PICTURE="## ## ## ## ##" are you inputting French phone numbers?

I defined "INCLUDE = (0 TO 99999999999999)" in include properties, if I'm right, the only values accepted should be beetween 0 to 99999999999999, but i can put for example : "0srtgtrgrs" and the value is accepted.

For the reason why this might be occurring, what is the datatype of the variable?  A quick test suggests you'd get the behaviour you report if the datatype of the variable was STRING/CHAR, but if datatype was integer then I get "This value is not amongst the valid possibilities"

Reuben

[Jeremy G.]

Hello,

Ok for the wrong section, sorry for mistake.

Right the field is to input french numbers, I tried the picture and it works nicely, thx a lot.

Right again, my field is not an integer because I'm using an existing database with old values with varchar definition.

Thx a lot.