Re: [firebase-br] Por favor, me ajudem com este erro quenão conheço
Evandro - Palas Recife
palaspro em palasnet.com.br
Qua Abr 20 09:59:43 -03 2005
http://qc.borland.com/wc/qcmain.aspx?d=9540
----- Original Message -----
From: Francisco Carlos da Rocha Gomes <fcarlos em cpafac.embrapa.br>
To: FireBase <lista em firebase.com.br>
Sent: Wednesday, April 20, 2005 9:33 AM
Subject: [firebase-br] Por favor, me ajudem com este erro quenão conheço
> 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
>
>
> ______________________________________________
> FireBase-BR (www.firebase.com.br) - Hospedado em www.bavs.com.br
> Para editar sua configuração na lista, use o endereço
http://mail.firebase.com.br/mailman/listinfo/lista_firebase.com.br
> Para consultar mensagens antigas:
http://search.gmane.org/search.php?group=firebase
>
Mais detalhes sobre a lista de discussão lista