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