Re: [firebase-br] Por favor, me ajudem com este erro que não conheço
Carlos H. Cantu
listas em warmboot.com.br
Qua Abr 20 09:58:36 -03 2005
Verifique se o BD está corrompido.
[]s
Cantu
http://www.warmboot.com.br
FireBase - http://www.FireBase.com.br
FCdRG> Pessoal,
FCdRG> fiz uma rotina em Delphi que ver a quantidade de registros em cada
FCdRG> tabela de um banco de dados. Para isto ela gera uma SQL conforme o
FCdRG> exemplo abaixo. Neste exemplo, aparece o seguinte erro:
FCdRG> Invalid token.
FCdRG> invalid request BLR at offset 495.
FCdRG> context already in use (BLR error).
FCdRG> Rodei a SQL no IB Expert e deu o mesmo erro.
FCdRG> Este erro não aparece em versão anteriores do BD em questão e em outros
FCdRG> BDs que trabalho.
FCdRG> O que pode estar acontecendo?
FCdRG> Agradeço desde já o apoio de vocês.
FCdRG> Francisco Carlos
FCdRG> Embrapa Acre
FCdRG> Aqui vai a SQL:
FCdRG> /*'QtdRegs do BD
FCdRG> localhost:C:\FCarlos\Desen\Sisdaf\SisdafBdProd\IDAFBD.GDB'*/
FCdRG> select 'ABATEDOUROS ' as Tabela, Count(*) as QtdRegs
FCdRG> from ABATEDOUROS union
FCdRG> select 'ACESSO ' as Tabela, Count(*) as QtdRegs
FCdRG> from ACESSO union
FCdRG> select 'AGENTEDACADEIA ' as Tabela, Count(*) as QtdRegs
FCdRG> from AGENTEDACADEIA union
FCdRG> select 'ANIMAIS ' as Tabela, Count(*) as QtdRegs
FCdRG> from ANIMAIS union
FCdRG> select 'APLICSAL ' as Tabela, Count(*) as QtdRegs
FCdRG> from APLICSAL union
FCdRG> select 'ASSISTECAGROPROD ' as Tabela, Count(*) as QtdRegs
FCdRG> from ASSISTECAGROPROD union
FCdRG> select 'ASSISTECNICA ' as Tabela, Count(*) as QtdRegs
FCdRG> from ASSISTECNICA union
FCdRG> select 'ATIVIDADE ' as Tabela, Count(*) as QtdRegs
FCdRG> from ATIVIDADE union
FCdRG> select 'ATIVIDADETERCEIROS ' as Tabela, Count(*) as QtdRegs
FCdRG> from ATIVIDADETERCEIROS union
FCdRG> select 'CARACPASTO ' as Tabela, Count(*) as QtdRegs
FCdRG> from CARACPASTO union
FCdRG> select 'CARACREBANHO ' as Tabela, Count(*) as QtdRegs
FCdRG> from CARACREBANHO union
FCdRG> select 'CISE ' as Tabela, Count(*) as QtdRegs
FCdRG> from CISE union
FCdRG> select 'CISECARACT ' as Tabela, Count(*) as QtdRegs
FCdRG> from CISECARACT union
FCdRG> select 'COMPRAPRODAGROEXTRAT ' as Tabela, Count(*) as QtdRegs
FCdRG> from COMPRAPRODAGROEXTRAT union
FCdRG> select 'COMPRAPRODAGROPEC ' as Tabela, Count(*) as QtdRegs
FCdRG> from COMPRAPRODAGROPEC union
FCdRG> select 'CONDICAO ' as Tabela, Count(*) as QtdRegs
FCdRG> from CONDICAO union
FCdRG> select 'CROQUIIMAGEM ' as Tabela, Count(*) as QtdRegs
FCdRG> from CROQUIIMAGEM union
FCdRG> select 'CULTIVAR ' as Tabela, Count(*) as QtdRegs
FCdRG> from CULTIVAR union
FCdRG> select 'CULTURA ' as Tabela, Count(*) as QtdRegs
FCdRG> from CULTURA union
FCdRG> select 'DATUM ' as Tabela, Count(*) as QtdRegs
FCdRG> from DATUM union
FCdRG> select 'DESTINOPRODUCAO ' as Tabela, Count(*) as QtdRegs
FCdRG> from DESTINOPRODUCAO union
FCdRG> select 'DOCAJUSTEDESALDO ' as Tabela, Count(*) as QtdRegs
FCdRG> from DOCAJUSTEDESALDO union
FCdRG> select 'DOCAUTODEADVERT ' as Tabela, Count(*) as QtdRegs
FCdRG> from DOCAUTODEADVERT union
FCdRG> select 'DOCAUTODEDESINTERD ' as Tabela, Count(*) as QtdRegs
FCdRG> from DOCAUTODEDESINTERD union
FCdRG> select 'DOCAUTODEINFRACAO ' as Tabela, Count(*) as QtdRegs
FCdRG> from DOCAUTODEINFRACAO union
FCdRG> select 'DOCAUTODEINFRTEST ' as Tabela, Count(*) as QtdRegs
FCdRG> from DOCAUTODEINFRTEST union
FCdRG> select 'DOCAUTODEINTERDICAO ' as Tabela, Count(*) as QtdRegs
FCdRG> from DOCAUTODEINTERDICAO union
FCdRG> select 'DOCAUTODEINTERDTEST ' as Tabela, Count(*) as QtdRegs
FCdRG> from DOCAUTODEINTERDTEST union
FCdRG> select 'DOCDECLDEVACINA ' as Tabela, Count(*) as QtdRegs
FCdRG> from DOCDECLDEVACINA union
FCdRG> select 'DOCGTA ' as Tabela, Count(*) as QtdRegs
FCdRG> from DOCGTA union
FCdRG> select 'DOENCAANIMAL ' as Tabela, Count(*) as QtdRegs
FCdRG> from DOENCAANIMAL union
FCdRG> select 'ESCRITORIO ' as Tabela, Count(*) as QtdRegs
FCdRG> from ESCRITORIO union
FCdRG> select 'ESTADO ' as Tabela, Count(*) as QtdRegs
FCdRG> from ESTADO union
FCdRG> select 'EXAME ' as Tabela, Count(*) as QtdRegs
FCdRG> from EXAME union
FCdRG> select 'EXPLORAGRICOLA ' as Tabela, Count(*) as QtdRegs
FCdRG> from EXPLORAGRICOLA union
FCdRG> select 'FINALIDADE ' as Tabela, Count(*) as QtdRegs
FCdRG> from FINALIDADE union
FCdRG> select 'GTAEXAME ' as Tabela, Count(*) as QtdRegs
FCdRG> from GTAEXAME union
FCdRG> select 'GTAMARCAREBANHOIMAGEM' as Tabela, Count(*) as QtdRegs
FCdRG> from GTAMARCAREBANHOIMAGEM union
FCdRG> select 'GTAVACINA ' as Tabela, Count(*) as QtdRegs
FCdRG> from GTAVACINA union
FCdRG> select 'INVASORA ' as Tabela, Count(*) as QtdRegs
FCdRG> from INVASORA union
FCdRG> select 'ITEM ' as Tabela, Count(*) as QtdRegs
FCdRG> from ITEM union
FCdRG> select 'ITEMCARACREBANHOFLOAT' as Tabela, Count(*) as QtdRegs
FCdRG> from ITEMCARACREBANHOFLOAT union
FCdRG> select 'ITEMCARACREBANHOINT ' as Tabela, Count(*) as QtdRegs
FCdRG> from ITEMCARACREBANHOINT union
FCdRG> select 'ITEMCONSTRUCAOM ' as Tabela, Count(*) as QtdRegs
FCdRG> from ITEMCONSTRUCAOM union
FCdRG> select 'ITEMCONSTRUCAOM2 ' as Tabela, Count(*) as QtdRegs
FCdRG> from ITEMCONSTRUCAOM2 union
FCdRG> select 'ITEMMAQUINAEQUIP ' as Tabela, Count(*) as QtdRegs
FCdRG> from ITEMMAQUINAEQUIP union
FCdRG> select 'ITEMPRODUCAOLOCAL ' as Tabela, Count(*) as QtdRegs
FCdRG> from ITEMPRODUCAOLOCAL union
FCdRG> select 'ITEMQUALIT ' as Tabela, Count(*) as QtdRegs
FCdRG> from ITEMQUALIT union
FCdRG> select 'ITEMQUANTI ' as Tabela, Count(*) as QtdRegs
FCdRG> from ITEMQUANTI union
FCdRG> select 'ITEMSOCIOECO ' as Tabela, Count(*) as QtdRegs
FCdRG> from ITEMSOCIOECO union
FCdRG> select 'ITEMSUBAREAHA ' as Tabela, Count(*) as QtdRegs
FCdRG> from ITEMSUBAREAHA union
FCdRG> select 'MARCAREBANHOIMAGEM ' as Tabela, Count(*) as QtdRegs
FCdRG> from MARCAREBANHOIMAGEM union
FCdRG> select 'MOVDEANIMAIS ' as Tabela, Count(*) as QtdRegs
FCdRG> from MOVDEANIMAIS union
FCdRG> select 'MUNICIPIO ' as Tabela, Count(*) as QtdRegs
FCdRG> from MUNICIPIO union
FCdRG> select 'OCORRDOENCAANIMAL ' as Tabela, Count(*) as QtdRegs
FCdRG> from OCORRDOENCAANIMAL union
FCdRG> select 'OCUPACAO ' as Tabela, Count(*) as QtdRegs
FCdRG> from OCUPACAO union
FCdRG> select 'PASTAGEM ' as Tabela, Count(*) as QtdRegs
FCdRG> from PASTAGEM union
FCdRG> select 'PESSOA ' as Tabela, Count(*) as QtdRegs
FCdRG> from PESSOA union
FCdRG> select 'PESSOAAGENTE ' as Tabela, Count(*) as QtdRegs
FCdRG> from PESSOAAGENTE union
FCdRG> select 'PESSOALRESIDENTE ' as Tabela, Count(*) as QtdRegs
FCdRG> from PESSOALRESIDENTE union
FCdRG> select 'PLANTACAO ' as Tabela, Count(*) as QtdRegs
FCdRG> from PLANTACAO union
FCdRG> select 'PLANTACAOCULTIVAR ' as Tabela, Count(*) as QtdRegs
FCdRG> from PLANTACAOCULTIVAR union
FCdRG> select 'PLANTAS ' as Tabela, Count(*) as QtdRegs
FCdRG> from PLANTAS union
FCdRG> select 'PRAGA ' as Tabela, Count(*) as QtdRegs
FCdRG> from PRAGA union
FCdRG> select 'PRAGANOPASTO ' as Tabela, Count(*) as QtdRegs
FCdRG> from PRAGANOPASTO union
FCdRG> select 'PRODAGROEXTRATIVA ' as Tabela, Count(*) as QtdRegs
FCdRG> from PRODAGROEXTRATIVA union
FCdRG> select 'PRODAGROEXTRATPRAGA ' as Tabela, Count(*) as QtdRegs
FCdRG> from PRODAGROEXTRATPRAGA union
FCdRG> select 'PRODUTO ' as Tabela, Count(*) as QtdRegs
FCdRG> from PRODUTO union
FCdRG> select 'PRODUTORES ' as Tabela, Count(*) as QtdRegs
FCdRG> from PRODUTORES union
FCdRG> select 'PROPRIEDACESSOS ' as Tabela, Count(*) as QtdRegs
FCdRG> from PROPRIEDACESSOS union
FCdRG> select 'PROPRIEDADE ' as Tabela, Count(*) as QtdRegs
FCdRG> from PROPRIEDADE union
FCdRG> select 'PROPRIEDADEEXTERNA ' as Tabela, Count(*) as QtdRegs
FCdRG> from PROPRIEDADEEXTERNA union
FCdRG> select 'PROPRIEDCODNOVO ' as Tabela, Count(*) as QtdRegs
FCdRG> from PROPRIEDCODNOVO union
FCdRG> select 'RACA ' as Tabela, Count(*) as QtdRegs
FCdRG> from RACA union
FCdRG> select 'RACASUTILIZADAS ' as Tabela, Count(*) as QtdRegs
FCdRG> from RACASUTILIZADAS union
FCdRG> select 'RECURSOS ' as Tabela, Count(*) as QtdRegs
FCdRG> from RECURSOS union
FCdRG> select 'RECURSOSESCRIT ' as Tabela, Count(*) as QtdRegs
FCdRG> from RECURSOSESCRIT union
FCdRG> select 'REGIONAL ' as Tabela, Count(*) as QtdRegs
FCdRG> from REGIONAL union
FCdRG> select 'REGMUNICIP ' as Tabela, Count(*) as QtdRegs
FCdRG> from REGMUNICIP union
FCdRG> select 'RESIDENTES ' as Tabela, Count(*) as QtdRegs
FCdRG> from RESIDENTES union
FCdRG> select 'RESIDOCUPACAO ' as Tabela, Count(*) as QtdRegs
FCdRG> from RESIDOCUPACAO union
FCdRG> select 'SALDODAPROPRIEDADE ' as Tabela, Count(*) as QtdRegs
FCdRG> from SALDODAPROPRIEDADE union
FCdRG> select 'SALDOHISTORICO ' as Tabela, Count(*) as QtdRegs
FCdRG> from SALDOHISTORICO union
FCdRG> select 'SISTEMACONFIG ' as Tabela, Count(*) as QtdRegs
FCdRG> from SISTEMACONFIG union
FCdRG> select 'SISTEMALOG ' as Tabela, Count(*) as QtdRegs
FCdRG> from SISTEMALOG union
FCdRG> select 'SISTEMASQL ' as Tabela, Count(*) as QtdRegs
FCdRG> from SISTEMASQL union
FCdRG> select 'SISTEMATABELAS ' as Tabela, Count(*) as QtdRegs
FCdRG> from SISTEMATABELAS union
FCdRG> select 'TIPODEPRODUTO ' as Tabela, Count(*) as QtdRegs
FCdRG> from TIPODEPRODUTO union
FCdRG> select 'TPRECURSOS ' as Tabela, Count(*) as QtdRegs
FCdRG> from TPRECURSOS union
FCdRG> select 'TRANSPORTE ' as Tabela, Count(*) as QtdRegs
FCdRG> from TRANSPORTE union
FCdRG> select 'UNIDADEDEDISTANCIA ' as Tabela, Count(*) as QtdRegs
FCdRG> from UNIDADEDEDISTANCIA union
FCdRG> select 'USODEPRODAGROTOX ' as Tabela, Count(*) as QtdRegs
FCdRG> from USODEPRODAGROTOX union
FCdRG> select 'USODEPRODZOOSANIT ' as Tabela, Count(*) as QtdRegs
FCdRG> from USODEPRODZOOSANIT union
FCdRG> select 'VACINA ' as Tabela, Count(*) as QtdRegs
FCdRG> from VACINA
FCdRG> ______________________________________________
FCdRG> FireBase-BR (www.firebase.com.br) - Hospedado em www.bavs.com.br
FCdRG> Para editar sua configuração na lista, use o endereço
FCdRG> http://mail.firebase.com.br/mailman/listinfo/lista_firebase.com.br
FCdRG> Para consultar mensagens antigas:
FCdRG> http://search.gmane.org/search.php?group=firebase
Mais detalhes sobre a lista de discussão lista