topic-39196

Posts: 226

Joined: Sun May 13, 2012 07:52 AM

xbrowse fwh2006 sqlrdd erro
Posted: Wed Jul 15, 2020 11:28 PM

segue o erro

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

FWH2008 | xHarbour | BCC74 | SQLRDD

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: xbrowse fwh2006 sqlrdd erro
Posted: Thu Jul 16, 2020 04:19 AM

Is the function OrdDescend() not supported by SQLRDD ?

Regards

G. N. Rao.

Hyderabad, India

karinha

Posts: 8523

Joined: Tue Dec 20, 2005 07:36 PM

Re: xbrowse fwh2006 sqlrdd erro
Posted: Thu Jul 16, 2020 07:15 AM

Intente con:

Code (fw): Select all Collapse

EXTERNAL DESCEND

tubanco->( ORDDESCEND( , , .T.) )

Saludos.

João Santos - São Paulo - Brasil - Phone: +55(11)95150-7341

MOISES

Posts: 838

Joined: Wed Aug 22, 2007 10:09 AM

Re: xbrowse fwh2006 sqlrdd erro
Posted: Thu Jul 16, 2020 08:56 AM

I haven't detected the problem so far.

Yes, SQLRDD supports OrdDescend()

Anyway, without a self-contained example it is impossible to debug.

Saludos / Regards,

FWH 20.04, Harbour 3.2.0 dev (r1909261630) y BCC 7.40

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: xbrowse fwh2006 sqlrdd erro
Posted: Thu Jul 16, 2020 10:09 AM

OrdDescend() does not require the EXTERNAL DESCEND

Regards

G. N. Rao.

Hyderabad, India

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: xbrowse fwh2006 sqlrdd erro
Posted: Thu Jul 16, 2020 10:11 AM

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?

Regards

G. N. Rao.

Hyderabad, India

karinha

Posts: 8523

Joined: Tue Dec 20, 2005 07:36 PM

Re: xbrowse fwh2006 sqlrdd erro
Posted: Thu Jul 16, 2020 01:24 PM

http://www.pctoledo.com.br/forum/download/file.php?id=383&sid=5325ef2eb76c463d6c3d9dd09229718c

João Santos - São Paulo - Brasil - Phone: +55(11)95150-7341

Enrico Maria Giordano

Posts: 9022

Joined: Thu Oct 06, 2005 08:17 PM

Re: xbrowse fwh2006 sqlrdd erro
Posted: Thu Jul 16, 2020 05:30 PM

Workarea not in use

EMG

Enrico Maria Giordano

e.m.giordano@emagsoftware.it
http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: xbrowse fwh2006 sqlrdd erro
Posted: Thu Jul 16, 2020 07:11 PM

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 (fw): Select all Collapse

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

Regards

G. N. Rao.

Hyderabad, India

Sistem

Posts: 226

Joined: Sun May 13, 2012 07:52 AM

Re: xbrowse fwh2006 sqlrdd erro
Posted: Thu Jul 16, 2020 09:43 PM

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

FWH2008 | xHarbour | BCC74 | SQLRDD

Sistem

Posts: 226

Joined: Sun May 13, 2012 07:52 AM

Re: xbrowse fwh2006 sqlrdd erro
Posted: Thu Jul 16, 2020 10:45 PM

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

FWH2008 | xHarbour | BCC74 | SQLRDD

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: xbrowse fwh2006 sqlrdd erro
Posted: Fri Jul 17, 2020 04:39 AM

Thanks for clarifying that the problem is not with xbrowse.

Regards

G. N. Rao.

Hyderabad, India

Sistem

Posts: 226

Joined: Sun May 13, 2012 07:52 AM

Re: xbrowse fwh2006 sqlrdd erro
Posted: Fri Aug 07, 2020 11:31 PM

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

FWH2008 | xHarbour | BCC74 | SQLRDD

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: xbrowse fwh2006 sqlrdd erro
Posted: Sat Aug 08, 2020 02:51 AM

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.

Regards

G. N. Rao.

Hyderabad, India

Sistem

Posts: 226

Joined: Sun May 13, 2012 07:52 AM

Re: xbrowse fwh2006 sqlrdd erro
Posted: Sat Aug 08, 2020 10:12 AM

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

FWH2008 | xHarbour | BCC74 | SQLRDD

FiveTech Support Forums