Criei um calendário com uso do banco firebird e tudo funciona normal menos a recorrência.
Pode ser a estrutura do meu BD?
No campo recorrencia ele guarda de forma normal o Y ou N
Este é o ddl da minha tabela no firebird:
/******************************************************************************/
/*** Generated by IBExpert 24/09/2010 04:52:05 ***/
/******************************************************************************/
/******************************************************************************/
/*** Following SET SQL DIALECT is just for the Database Comparer ***/
/******************************************************************************/
SET SQL DIALECT 3;
/******************************************************************************/
/*** Tables ***/
/******************************************************************************/
CREATE GENERATOR GEN_CALENDARIO_ID;
CREATE TABLE CALENDARIO (
CHAVE INTEGER NOT NULL,
TITULO VARCHAR(50) COLLATE PT_BR,
DESCRICAO BLOB SUB_TYPE 1 SEGMENT SIZE 80,
INICIO TIMESTAMP,
FINAL_DATA DATE,
FINAL_HORA TIME,
RECORRENCIA CHAR(1),
PERIODO CHAR(1)
);
/******************************************************************************/
/*** Primary Keys ***/
/******************************************************************************/
ALTER TABLE CALENDARIO ADD CONSTRAINT PK_CALENDARIO PRIMARY KEY (CHAVE);
/******************************************************************************/
/*** Triggers ***/
/******************************************************************************/
SET TERM ^ ;
/******************************************************************************/
/*** Triggers for tables ***/
/******************************************************************************/
/* Trigger: CALENDARIO_BI */
CREATE OR ALTER TRIGGER CALENDARIO_BI FOR CALENDARIO
ACTIVE BEFORE INSERT POSITION 0
as
begin
if (new.chave is null) then
new.chave = gen_id(gen_calendario_id,1);
end
^
SET TERM ; ^
/******************************************************************************/
/*** Privileges ***/
/******************************************************************************/
Obrigado