[firebase-br] erro View apos atualizacao para versao 2.5

[André Conrado]

Cara, usar "DIALECT 1" é muito limitado. Mude para "DIALECT 3". O
problema pode está ai também.

abçs.


2012/4/26 Sandro Souza <escovadordebits em gmail.com>:
> Bom dia/tarde Daniel.
>
> Sugiro que substitua o seguinte:
>
> De: *(SELECT cast ('now' as timestamp) - 45 from rdb$database)*
>
> Por: *(CURRENT_TIMESTAMP - 45)
> *
> De: *(SELECT cast ('today' as date) from rdb$database)*
>
> Por: *CURRENT_DATE*
>
> Espero ter ajudado mais que atrapalhado. :D
>
>
> 2012/4/25 Daniel Reis <daniellcr em yahoo.com.br>
>
>> Pessoal,
>>
>>
>>
>> Atualizei minha BD 2.1 para 2.5. Após a atualização uma de minhas views
>> está
>> apresentando erro.
>>
>>
>>
>> O erro só acontece se for executava a view. Se for executada somente o
>> select mostras os resultados normalmente sem erros.
>>
>>
>>
>> Erro:
>>
>>
>>
>> Arithmetic overflow or division by zero has occurred.
>>
>>
>>
>>
>>
>> CREATE VIEW VW_SPC2(
>>
>>    CPJ_CDCLII006,
>>
>>    CPJ_RZSOCA060,
>>
>>    CPJ_CGCMFA014,
>>
>>    CPF_DTNASD000,
>>
>>    CPF_SEXOCA001,
>>
>>    CPF_DOCOEA020,
>>
>>    ECI_CDECII002,
>>
>>    UFE_CDUFEA002,
>>
>>    CPF_NOPAIA035,
>>
>>    CPF_NOMAEA035,
>>
>>    CPJ_ENDERA035,
>>
>>    CPJ_CIDADA020,
>>
>>    CPJ_CDUFEA030,
>>
>>    CEP_CDCEPI005,
>>
>>    CEP_DGCEPI003,
>>
>>    CPJ_NMTE1A012,
>>
>>    CRE_DTEMID000,
>>
>>    CRE_DTVEND000,
>>
>>    CRE_SERIEA003,
>>
>>    CRE_NUNOFI006,
>>
>>    CRE_VALORN017,
>>
>>    CPJ_BAIRRA020,
>>
>>    CRE_DEPARA002,
>>
>>    CPF_NATURA020,
>>
>>    EMP_CDEMPA003,
>>
>>    NUMERO_ENDERECO)
>>
>> AS
>>
>> SELECT CPJ.CPJ_CDCLII006
>>
>>      ,CPJ.CPJ_RZSOCA060
>>
>>      ,CPJ.CPJ_CGCMFA014
>>
>>      ,CPF.CPF_DTNASD000
>>
>>      ,CPF.CPF_SEXOCA001
>>
>>      ,CPF.CPF_DOCOEA020
>>
>>      ,CPF.ECI_CDECII002
>>
>>      ,CPF.UFE_CDUFEA002
>>
>>      ,CPF.CPF_NOPAIA035
>>
>>      ,CPF.CPF_NOMAEA035
>>
>>      ,CPJ.CPJ_ENDERA035
>>
>>      ,CPJ.CPJ_CIDADA020
>>
>>      ,CPJ.CPJ_CDUFEA030
>>
>>      ,CPJ.CEP_CDCEPI005
>>
>>      ,CPJ.CEP_DGCEPI003
>>
>>      ,CPJ.CPJ_NMTE1A012
>>
>>      ,CRE.CRE_DTEMID000
>>
>>      ,CRE.CRE_DTVEND000
>>
>>      ,CRE.CRE_SERIEA003
>>
>>      ,CRE.CRE_NUNOFI006
>>
>>      ,CRE.CRE_VALORN017
>>
>>      ,CPJ.CPJ_BAIRRA020
>>
>>      ,CRE.CRE_DEPARA002
>>
>>      ,CPF.CPF_NATURA020
>>
>>      ,CRE.EMP_CDEMPA003
>>
>>      ,NUMERO_ENDERECO
>>
>>  FROM TB_CPJ CPJ INNER JOIN TB_CRE CRE ON (CPJ.CPJ_CDCLII006 =
>> CRE.CPJ_CDCLII006)
>>
>>    INNER JOIN TB_CPF CPF ON (CPJ.CPJ_CDCLII006 = CPF.CPJ_CDCLII006)
>>
>> WHERE
>>
>>    CRE.CRE_SERIEA003 IN ('UNI','REN')
>>
>> AND CRE.CPJ_CDCLII006 not in
>> (0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,85)
>>
>> AND CRE.CRE_SITUAA001 <> 6
>>
>> AND CRE.EMP_CDEMPA003 IN ('001','005','006')        --Empresa
>>
>> AND CRE.CRE_DTVEND000 < (SELECT cast ('now' as timestamp) - 45 from
>> rdb$database)
>>
>> AND CRE.CRE_VLPAGN017 < (CRE.CRE_VALORN017 + CRE.CRE_ACRESN017)
>>
>> AND CRE.CRE_EMFATA003 <> '1'
>>
>> AND CPJ.CPJ_CCOEMA001 = 'S'
>>
>> AND CRE.CRE_VALORN017 > 5
>>
>> AND CPJ.SCL_CDOBSI003 <> 6 --Nao emitir pra quem ja esta no spc
>>
>> AND CPJ.CPJ_CDCLII006
>>
>> NOT IN (
>>
>> SELECT CPJ_CDCLII006 FROM TB_CON WHERE
>>
>>       CON_DTPPGD000 >= (SELECT cast ('today' as date) from rdb$database)
>>
>>       )
>>
>> AND CPJ.CPJ_CDCLII006
>>
>> NOT IN (
>>
>> SELECT CPJ_CDCLII006 FROM TB_CON WHERE
>>
>>       CON_DTPCOD000 >= (SELECT cast ('today' as date) from rdb$database)
>>
>>       )
>>
>> AND CPJ.CPJ_CDCLII006
>>
>> IN (SELECT CPJ_CDCLII006 FROM TB_CON WHERE CON_SITUAA001 = 0)
>>
>> ;
>>
>>
>>
>>
>>
>> ______________________________________________
>> FireBase-BR (www.firebase.com.br) - Hospedado em www.locador.com.br
>> Para saber como gerenciar/excluir seu cadastro na lista, use:
>> http://www.firebase.com.br/fb/artigo.php?id=1107
>> Para consultar mensagens antigas: http://firebase.com.br/pesquisa
>>
> ______________________________________________
> FireBase-BR (www.firebase.com.br) - Hospedado em www.locador.com.br
> Para saber como gerenciar/excluir seu cadastro na lista, use: http://www.firebase.com.br/fb/artigo.php?id=1107
> Para consultar mensagens antigas: http://firebase.com.br/pesquisa