Re: [firebase-br] Por favor, me ajudem com este erro quenão conheço
Carlos H. Cantu
listas em warmboot.com.br
Qua Abr 20 10:38:43 -03 2005
hahaha, o mais interessante do link:
"This problem was fixed in Firebird 1.50 Beta 3 by Arno Brinkman, as
documented at
http://sourceforge.net/project/shownotes.php?group_id=9028&release_id=238440"
Ou seja, informação sobre Firebird no QC da Borland!
hehehehe!
[]s
Cantu
http://www.warmboot.com.br
FireBase - http://www.FireBase.com.br
EPR> http://qc.borland.com/wc/qcmain.aspx?d=9540
EPR> ----- Original Message -----
EPR> From: Francisco Carlos da Rocha Gomes <fcarlos em cpafac.embrapa.br>
EPR> To: FireBase <lista em firebase.com.br>
EPR> Sent: Wednesday, April 20, 2005 9:33 AM
EPR> 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
EPR> http://mail.firebase.com.br/mailman/listinfo/lista_firebase.com.br
>> Para consultar mensagens antigas:
EPR> http://search.gmane.org/search.php?group=firebase
>>
EPR> ______________________________________________
EPR> FireBase-BR (www.firebase.com.br) - Hospedado em www.bavs.com.br
EPR> Para editar sua configuração na lista, use o endereço
EPR> http://mail.firebase.com.br/mailman/listinfo/lista_firebase.com.br
EPR> Para consultar mensagens antigas:
EPR> http://search.gmane.org/search.php?group=firebase
Mais detalhes sobre a lista de discussão lista