After Row_Inserted run multiple queries

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
sal1150
User
Posts: 69

After Row_Inserted run multiple queries

Post by sal1150 »

I tray to run these functions :-

function Row_Inserted($rsold, &$rsnew) {
  return ew_ExecuteScalar($this->sql_payroll_r ());
  return ew_ExecuteScalar($this->sql_payroll_n ());
}

But I found the result of first one only.
How can I run both in same time


sal1150
User
Posts: 69

Post by sal1150 »

Sorry I found the solution, 'return' must be removed so

function Row_Inserted($rsold, &$rsnew) {
ew_ExecuteScalar($this->sql_payroll_r ());
ew_ExecuteScalar($this->sql_payroll_n ());
}


Webmaster
User
Posts: 9438

Post by Webmaster »

To get a value from ew_ExecuteScalar, the correct syntax should be:

$val = ew_ExecuteScalar("<SQL>");


Post Reply