next »

[Jos? V.]

Hello,
I'm trying to define a form field with PICTURE attribute set to alphanumeric chars such as:

Code:

edit  e7 = profor.prfmat , upshift, picture = "AA-AA-AAAA";

But when I try to edit the field I can only insert alpha chars, so digits are not allowed.

Is this a version bug or am I reading the manual wrong?

My version or fglrun is 3.00.04 rev-3be6b8d and GDC is 3.00.04 build-5372.

I also tested with fgl 3.10.14 rev-912632b and GDC 3.10.11 build-158046 and got the same result.

[Bernard M.]

Hello,

It seems "A" and "X" have been swapped in the documentation.
Try this instead:

Code:

edit  e7 = profor.prfmat , upshift, picture = "XX-XX-XXXX";

We will update the documentation accordingly.

Regards,
Bernard

[Jos? V.]

I changed from "X" to "A" trying to solve a problem.
So when I read the manual my understanding was:
* X -> Any character(?,/, = etc)
* A -> Only alphanumeric characters.

My problem is X accepts things like linebreaks.
And users are copying cells from excel instead of copying the content of the cell, which then breaks the database because copying the cell carries a linebreak into the field.

The only fields that have this behaviour are field with the PICTURE attribute and TEXTBOX fields.

I was trying and easy fix on the form by using the "A" char on the PICTURE.

[Bernard M.]

OK. This is not as simple as it looks.

I don't see any other solution than treat it with 4gl code.
Maybe with ON ACTION dialogtouched to check characters as soon as there is a change in the INPUT field or with AFTER FIELD to test the whole inserted string.

Anyway if you need to treat line breaks this might be even more complicated.

Maybe someone in the forum as already done something like this before.

Regards,
Bernard

[Bernard M.]

As an example here a simple test case that might help.

Regards,
Bernard

[Jos? V.]

Luckily we don't use that much of textbox or the PICTURE attribute.
We will patch our code to work around this problem as you suggested.
Thank you for your help!

[Sebastien F.]

One should not use ON ACTION dialogtouched to control field values:

This special action is provided to detect immediately user input in DIALOG/END DIALOG, to switch the form state from a visualization/navigation mode ("save" action is disabled) to modification mode ("save" action is enabled).

Check: https://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/c_fgl_prog_dialogs_dialogtouched.html

Ideally we could have a new PICTURE placeholder, to allow ONLY letters and digits...

Seb

[Leo S.]

Hi Jose, 'A' means any letter. The '(alpha-numeric)' in the doc is simply not correct.
We should update the doc.

Regards, Leo

[Jos? V.]

Ideally we could have a new PICTURE placeholder, to allow ONLY letters and digits...

This would be perfect for us.