F�rum Duvidas sobre o uso do Firebird. #573226

26/12/2016

Bom dia,

Gostaria de uma ajuda sobre as sequintes quest�es.:
1� Gostaria de Criar uma Trigger toda vez que excluir um registro ele conta qual o ultimo e atualiza o Generator.
2� Gostaria de Criar trigger ou procedure que ao excluir o registro ele insira as sequintes informa��es.:

/******************************************************************************/
/***               Generated by IBExpert 26/12/2016 12:22:10                ***/
/******************************************************************************/

/******************************************************************************/
/***      Following SET SQL DIALECT is just for the Database Comparer       ***/
/******************************************************************************/
SET SQL DIALECT 3;



/******************************************************************************/
/***                                 Tables                                 ***/
/******************************************************************************/


CREATE GENERATOR GEN_DEL_RECORDES_ID;

CREATE TABLE DEL_RECORDES (
    ID_DELRECORDES    INTEGER NOT NULL,
    TABELA            VARCHAR(70),
    REGISTROEXCLUIDO  VARCHAR(250),
    DATAEXCLUSAO      TIMESTAMP NOT NULL
);




/******************************************************************************/
/***                              Primary Keys                              ***/
/******************************************************************************/

ALTER TABLE DEL_RECORDES ADD CONSTRAINT PK_DEL_RECORDES PRIMARY KEY (ID_DELRECORDES);


/******************************************************************************/
/***                                Indices                                 ***/
/******************************************************************************/

CREATE INDEX IDX_DEL_RECORDES ON DEL_RECORDES (ID_DELRECORDES);


/******************************************************************************/
/***                                Triggers                                ***/
/******************************************************************************/


SET TERM ^ ;



/******************************************************************************/
/***                          Triggers for tables                           ***/
/******************************************************************************/



/* Trigger: DEL_RECORDES_BI */
CREATE OR ALTER TRIGGER DEL_RECORDES_BI FOR DEL_RECORDES
ACTIVE BEFORE INSERT POSITION 0
as
begin
  if (new.id_delrecordes is null) then
    new.id_delrecordes = gen_id(gen_del_recordes_id,1);
end
^


SET TERM ; ^



/******************************************************************************/
/***                              Descriptions                              ***/
/******************************************************************************/

COMMENT ON TABLE DEL_RECORDES IS 
'FUN��O DA TABELA: ARMAZENAR OS REGISTROS DELETADOS.';



/******************************************************************************/
/***                               Privileges                               ***/
/******************************************************************************/

3� Toda vezes que inserir e atualizar ele insira os logs em tabela com o usuario e registro inserido ou atualizado.

Thiago Souto

Curtir t�pico

+ 0

Responder