Custom field

PHPMaker General Discussion (PHPMaker)
1

Hello,

I have created custom field → test and i want to sum 4 number so the expression would be: number1 + number2 + number3 + number4

If i do like this the field data type is changed to Memo(UniCode) (adLongVarWChar) and the output number is for example : 3331440

I found out that if i do number1 + number2 i get the correct calculation and the field type remain 4-byte Real (adDouble) and i get +5,800,275.00 which is correct.

How can i solve this i also tried with SQL but it is the same…Any ideas?

Best regards,
Wuchi

2

If you use MySQL, you may try to convert/cast the data type, see https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html.

3

Hello,

Solved. There were values NULL so the the expression doesn’t take this into calculation.
I have solved this with DEFAULT value 0.0 so i don’t have this problem…

Best regards,
Wuchi