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