AppGini Community Forums

Hello
Calculated fields
I have this code which works great in SQL.
Except that ID11 is NOT displayed (on the mysql console it works), I made the field read only, integer ... I use the calculated fields.
An idea ?

Hi,

the code looks good.

Can you please try to set a value in that field of the database manually for a record, the call that record via your app and check what value is written back into the database.

Also you could try to be on the safe side to put each value in a IFNULL statement like

Indeed: the mysql database does not update.
UPDATE ?

Hi,

did you try to change your statement and add the IFNULL ?

+1 for @pböttcher:
Using NULL for calculations may produce unexpected results, I totally agree, see simple example in SQL:


But on the other hand we can see from the screenshot that you don't have NULLs in the selected fields of that specific row.

Narrow down

Did you check if your calculation gets executed at all? Maybe change SQL to and check if every record contains the record's id after loading the TV.

PS: After Re-reading the thread and pböttchers answer above, I guess this is what he wanted you to check by asking you to change the value in DB and then reloading the AppGini DV. Reloading should overwrite the DB-value, he's totally right. This here is just a different approach for testing execution.


Sidenote: Datatype integer?

I'm wondering if datatype integer is suited for the result of division by 5 of a sum of integers. I guess changing to double/float/decimal datatype will not solve your problem, because division by 5, casted to integer should just cut decimals but should not result in NULL.

Perhaps the solution is much simpler:
I just saw that a single quote is missing at the end of your SQL command

SELECT ( `DNB_MAITRISE_SOCLE`.`D11_FR`+`DNB_MAITRISE_SOCLE`.`D11_HG`+`DNB_MAITRISE_SOCLE`.`D11_SVT`+`DNB_MAITRISE_SOCLE`.`D11_PHY`+`DNB_MAITRISE_SOCLE`.`D11_TECHNO`)/5
FROM DNB_MAITRISE_SOCLE WHERE `DNB_MAITRISE_SOCLE`.`id`='%ID%;

%ID% should be surrounded by single quote ' (and you don't need the ";" here)
If your fields have required flag (NOT NULL in database), you don't need the ifnull() function calls but just...