/** * Aqui el id es el codigo * @see TSLBasicRecordDAO::getUpdateRecordQuery() */ protected function getUpdateRecordQuery(\TSLDataModel &$record) { /* @var $record RegionesModel */ $sql = 'select * from (select sp_regiones_save_record(' . '\'' . $record->get_regiones_codigo() . '\'::character varying,' . '\'' . $record->get_regiones_descripcion() . '\'::character varying,' . '\'' . $record->getActivo() . '\'::boolean,' . '\'' . $record->get_Usuario_mod() . '\'::character varying,' . $record->getVersionId() . '::integer, 1::BIT) as insupd) as ans where insupd is not null;'; return $sql; }
/** * Aqui el id es el codigo * @see \TSLBasicRecordDAO::getUpdateRecordQuery() */ protected function getUpdateRecordQuery(\TSLDataModel &$record) { /* @var $record PaisesModel */ $sql = 'SELECT * FROM (SELECT sp_paises_save_record(' . '\'' . $record->get_paises_codigo() . '\'::CHARACTER VARYING,' . '\'' . $record->get_paises_descripcion() . '\'::CHARACTER VARYING,' . '\'' . $record->get_paises_entidad() . '\'::BOOLEAN,' . '\'' . $record->get_regiones_codigo() . '\'::CHARACTER VARYING,' . '\'' . $record->get_paises_use_apm() . '\'::BOOLEAN,' . '\'' . $record->get_paises_use_docid() . '\'::BOOLEAN,' . '\'' . $record->getActivo() . '\'::BOOLEAN,' . '\'' . $record->get_Usuario_mod() . '\'::CHARACTER VARYING,' . $record->getVersionId() . '::INTEGER, 1::BIT) AS insupd) AS ans WHERE insupd IS NOT NULL;'; return $sql; }