AppGini Community Forums

I am using the following formula in before update:
Works perfectly on 7.4, but does nothing in 8.1, as if the formula is not there.
Any idea what I should change in the formula to make it work in 8.1?

The funny part is I have other formulas almost same as this one (just different message), work on both.
I am just having hard time with this particular one, cannot see why it is not working!
Changing php from 8.1 to 7.4 it works, if I change back it stops!

thanks

Capital letter "v" in sqlValue(...) missing

thanks for the reply, tried V, but that did not work, and the others are the same, with small v.

You are right, I have just learned something new: function names are not case-sensitive in PHP.

Case sensitive

variables, constants, array keys, class properties, class constants

Case insensitive

functions, class constructors, class methods, keywords and constructs (if, else, null, foreach, echo etc.)

Other Ideas:

• Can you please check value of $chkCer and $args by var-dumping before return
• We cannot see your function. Are you passing $args by reference?
  Can you please show the whole function TABLENAME_before_update

It is working now!
I have no idea what happened since I did not change a single letter.

Maybe 8.1.8 solved the problem, whatever that was (server PHP updated from 8.1)

that was the full function, nothing else is there actually:

<code>
function toll_before_update(&$data, $memberInfo, &$args) {
$chkCer=sqlvalue("select status from freight where `id` = {$data['freight']}",$eo);
if ( $chkCer =='Canceled'){$args['error_message'] = 'Alert: Canceled!';return FALSE;};

return TRUE;
}
</code>

Anyway, what I learned from this: if I have a formula that worked fine and just stopped for no reason check your PHP version before and after!
That my rule number one now.

Thanks JAN and have a nice day