Page 1 of 2
xbrowse fwh2006 sqlrdd erro
Posted: Wed Jul 15, 2020 11:28 pm
by Sistem
segue o erro
Code: Select all
METHOD SQLRDD_SaveState() CLASS TXBrowse
if ::SQLRDD_hState == nil
::SQLRDD_hState := {=>}
HSetCaseMatch( ::SQLRDD_hState, .f. )
endif
::SQLRDD_hState[ "nLen" ] := ::nLen
::SQLRDD_hState[ "IndexOrd" ] := INDEXORD()
::SQLRDD_hState[ "descend" ] := OrdDescend() // erro
::SQLRDD_hState[ "recno" ] := RECNO()
::SQLRDD_hState[ "nKeyNo" ] := ::SQLRDD_nKeyNo
return nil
Re: xbrowse fwh2006 sqlrdd erro
Posted: Thu Jul 16, 2020 4:19 am
by nageswaragunupudi
Is the function OrdDescend() not supported by SQLRDD ?
Re: xbrowse fwh2006 sqlrdd erro
Posted: Thu Jul 16, 2020 7:15 am
by karinha
Intente con:
Code: Select all
EXTERNAL DESCEND
tubanco->( ORDDESCEND( , , .T.) )
Saludos.
Re: xbrowse fwh2006 sqlrdd erro
Posted: Thu Jul 16, 2020 8:56 am
by MOISES
I haven't detected the problem so far.
Yes, SQLRDD supports OrdDescend()
Anyway, without a self-contained example it is impossible to debug.
Re: xbrowse fwh2006 sqlrdd erro
Posted: Thu Jul 16, 2020 10:09 am
by nageswaragunupudi
OrdDescend() does not require the EXTERNAL DESCEND
Re: xbrowse fwh2006 sqlrdd erro
Posted: Thu Jul 16, 2020 10:11 am
by nageswaragunupudi
MOISES wrote:I haven't detected the problem so far.
Yes, SQLRDD supports OrdDescend()
Anyway, without a self-contained example it is impossible to debug.
In our tests, OrdDescend() is working well with SQLRDD.
Can some body explain to me the error in English? What does the error say?
Re: xbrowse fwh2006 sqlrdd erro
Posted: Thu Jul 16, 2020 1:24 pm
by karinha
Re: xbrowse fwh2006 sqlrdd erro
Posted: Thu Jul 16, 2020 5:30 pm
by Enrico Maria Giordano
Workarea not in use
EMG
Re: xbrowse fwh2006 sqlrdd erro
Posted: Thu Jul 16, 2020 7:11 pm
by nageswaragunupudi
Enrico Maria Giordano wrote:Workarea not in use
EMG
Thank you very much.
That means the application program closed the dbf, even before xbrowse is destroyed. So, when the xbrowse got focus, the method KeyCount() is executed and the alias is not in use anymore.
Mr. Sistem
Can you please make this modification and try again?
Code: Select all
METHOD SQLRDD_SaveState() CLASS TXBrowse
if ::SQLRDD_hState == nil
::SQLRDD_hState := {=>}
HSetCaseMatch( ::SQLRDD_hState, .f. )
endif
if SELECT() > 0
::SQLRDD_hState[ "nLen" ] := ::nLen
::SQLRDD_hState[ "IndexOrd" ] := INDEXORD()
::SQLRDD_hState[ "descend" ] := OrdDescend() // erro
::SQLRDD_hState[ "recno" ] := RECNO()
::SQLRDD_hState[ "nKeyNo" ] := ::SQLRDD_nKeyNo
endif
return nil
Re: xbrowse fwh2006 sqlrdd erro
Posted: Thu Jul 16, 2020 9:43 pm
by Sistem
fiz um video mostrado o erro. (acho que acontece o erro quando se tem um xbrowse aberto e abre outro e fechando em seguinda... não sei explicar, o video explica)
a correção não trabalha bem. trava o xbrowse
https://youtu.be/aDBEQd3Z53Y
Re: xbrowse fwh2006 sqlrdd erro
Posted: Thu Jul 16, 2020 10:45 pm
by Sistem
desculpa pessoal
como esse erro não acontecia antes, pensei que fosse por conta da nova versão.
o problema eh que na tela que faço backup dos xml (segunda tela) fecha a tabela Exml->(dbCloseArea()) e o xbrawse(Exml) estando aberto corretamente apresenta o erro.
em resumo, ERRO MEU
obrigado a todos
Re: xbrowse fwh2006 sqlrdd erro
Posted: Fri Jul 17, 2020 4:39 am
by nageswaragunupudi
Thanks for clarifying that the problem is not with xbrowse.
Re: xbrowse fwh2006 sqlrdd erro
Posted: Fri Aug 07, 2020 11:31 pm
by Sistem
XBROWSE lento com grande volume de dados versão 2006
tive que voltar para a versão 1912
amanha posto video com a diferença das duas versões
Re: xbrowse fwh2006 sqlrdd erro
Posted: Sat Aug 08, 2020 2:51 am
by nageswaragunupudi
Sistem wrote:XBROWSE lento com grande volume de dados versão 2006
tive que voltar para a versão 1912
amanha posto video com a diferença das duas versões
You are right. We understand the reason.
Please wait, we will provide a workaround.
Meanwhile, please let us know the number of records in the DBF being browsed.
Re: xbrowse fwh2006 sqlrdd erro
Posted: Sat Aug 08, 2020 10:12 am
by Sistem
usando SQLRDD
Tabela 110.000 registros
seek esta demorado um pouco (1912 normal)
PageDown pressionando 10x seguidos trava o xbrowse por 20segundos
PageUP não trava, mais esta mais lento que a versão 1912