[in your example code]

Roland,

Sorry if DIALOG.setArrayAttributes() does not satisfy your needs.
I am using this in many Genero programs, and I think this is a great feature easy to program.

Funnily enough, in your example code, the AUI tree is also manipulated directly to assign a style to an element

???
What code example are you referring to?
I see no direct AUI tree manipulation.
What do you mean?

Seb

Hello Sebastien,

I'm aware of the setArrayAttributes() function, although this only works for arrays/tables but not for single elements such as Edit fields.
Funnily enough, in your example code, the AUI tree is also manipulated directly to assign a style to an element. So there does seem to be a need for a simpler solution.

Apart from that, I always found the possibility of specifying the attributes via the setArrayAttributes() and setCellAttributes() functions unsatisfactory because you have to define the array structure again separately. If you then add or delete a new column, you always have to bear in mind that you also have to adapt the second array. From my kind of view it would be more practical to be able to specify the attributes directly when defining the array, similar to how it is already possible to specify the attributes for JSON or XML syntax (https://4js.com/online_documentation/fjs-fgl-manual-html/index.html#fgl-topics/c_fgl_Arrays_attributes.html and https://4js.com/online_documentation/fjs-fgl-manual-html/index.html#fgl-topics/c_fgl_variables_attributes.html).

Kind regards
Roland

Hello Roland,

Did you consider using DIALOG.setArrayAttributes(), to put specific colors on individual cells?

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

There was once a request to specify a style for each cell but I think using simple colors and TTY attributes like reverse is sufficient.

We are using this in the FGLSQLDEBUG viewer, see screenshot here:

https://github.com/FourjsGenero/tool_fglsqldebug

Seb

Hello everyone,

Is there a reason why the DISPLAY ARRAY/AT/TO/BY NAME statements do not allow a STYLE to be specified for the attributes (https://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/c_fgl_record_display_DISPLAY_BY_NAME.html)?
In contrast to MESSAGE (https://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/c_fgl_message_display_MESSAGE.html) and ERROR (https://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/c_fgl_message_display_ERROR.html), only the TTY attributes can be used here.
So if I want to display an element differently (e.g. to indicate an error), I only have the option of either specifying this directly in the form or manipulating the AUI tree directly.
Wouldn't it be more practical if this could also be specified via a STYLE attribute in future instead of being restricted to the TTY attributes? Or is there another option that I have missed?

Kind regards
Roland

Hi,

OK I will add the same warning note in the page

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

Seb

Hi,

i didn't see that note ...
maybe better put that warning here : https://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/c_fgl_static_sql_003.html

Regards

Are you aware of the openFiles front-call https://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/c_fgl_frontcall_standard_openfiles.html. (Note that is ...files plural

My inclination when transforming to use GBC is to precede FGL_GETFILE wth an explicit openFile(s) front-call as this gives you a little more control of what is rendered as opposed to FGL_GETFILE in isolation which will add its own UI if the file referenced has not been uploaded to the GAS temporary directory already.

Reuben

@Benjamin We do have the "strange behaviour" documented, see the 3rd sentence of the "Important note" here https://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/c_fgl_result_sets_DECLARE.html

... Do not mix ? SQL parameter placeholders with program variables: This would lead to a runtime error at OPEN or at FOREACH time, because the number of SQL parameters will not match the number of variable provided in the USING clause.

To also add understanding, look at the FGLSQLDEBUG of a static SQL statement with a host variable.

For instance

Code

LET numcli = '8905'
  SELECT custname FROM fdecus WHERE custnr=$numcli AND cussupcd='C'

yields in FGLSQLDEBUG, note the host variable is a parameter and passed using using ...

Code

SQL: SELECT custname FROM fdecus WHERE custnr = ? AND cussupcd = 'C'
 | 4gl source      : play.4gl line=33
 | ../ODI_common.h:00829(3)  : adaptStatement: stmt type = 1
 | ../ODI_common.h:00834(3)  : adaptStatement: ifxemul = 1
 | sqt.c:00861(3)  : Nat stmt1 = select custname from   fdecus where custnr = ? AND cussupcd = 'C'
 | sqlcode         : 100
 |   sqlerrd3      : 0
 | curr driver     : ident='dbmsqt'
 | curr connection : ident=':memory:' (dbspec=[:memory:])
 | using: 1
 |  t:                        STRING f:01 v:"8905"
 | Timestamp       : 2024-10-11 09:48:44.17306
 | Execution time  :         0 00:00:00.00007

@Seb - perhaps we can improve the visibility of that note

That's great

Thanks Scott

Hi Richard:

While I expect others to reply with more examples, I wanted to point you to the BDL documentation topic "Images on mobile devices" at https://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/c_fgl_images_dynamic_images.html#c_fgl_images_dynamic_images__mobile_images