public function getNextValue($sequence = '', $tableGenerator = 'manager_sequence') { $sql = new \Maestro\Database\MSQL("value", $tableGenerator, "(sequence='" . $sequence . "')"); $sql->setDb($this->db); $result = $this->db->query($sql->select()); $value = $result[0][0]; $sql = new \Maestro\Database\MSQL("value", $tableGenerator, "(sequence='" . $sequence . "')"); $sql->setDb($this->db); $result = $this->db->query($sql->update(':value + 1')); return $value; }