FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin para Harbour/xHarbour Problema con REQUERY
Posts: 1956
Joined: Fri Oct 07, 2005 07:08 PM
Problema con REQUERY
Posted: Thu Apr 07, 2022 09:16 AM
Hola. Tengo este codigo
Code (fw): Select all Collapse
   TEXT into cSql
   Select
   a.id             AS c0,
   a.idusuario      AS c1,
   a.nombre1        AS c2,
   a.nombre2        AS c3,
   a.nombre3        AS c4,
   a.nombre4        AS c5,
   a.apellido1      AS c6,
   a.apellido2      AS c7,
   a.nacimiento     AS c8,
   a.fecha_nac      AS c9,
   a.direccion      AS c10,
   a.estadoactual   AS c11,
   b.id             AS c12,
   b.usuario        AS c13,
   a.ida            AS c14,
   a.idb            AS c15,
   a.idc            AS c16
   FROM tbcarpetas AS a
   Left OUTER JOIN tbautoriza AS b ON a.idusuario = b.id
   ORDER BY a.apellido1
   ENDTEXT

   ::oQry := ::oCnx:query( cSql )

   ::oQry:requery() <------------------------- esto da eror


Las ultimas dos lineas son a modo de practica. "query" me funciona, ahora probe hacer un "requery" porque necesito probar un "refresco" del xbrowser por medio de un "timer" por las dudas que otras terminarles hagan un insert o update de la base de datos "tbcarpetas". cuando ejecuta la linea "requery" tira este error:

Error description: Error BASE/1132 Bound error: array access
Args:
[ 1] = A {3,2,"ÑLAKSJDAÑKLSJD "," "," ... } length: 17
[ 2] = N 18


que estoy haciendo mal?
gracias.
FWH 21.02
Harbour 3.2.0dev (r2104281802)
Copyright (c) 1999-2021, https://harbour.github.io/
Posts: 1956
Joined: Fri Oct 07, 2005 07:08 PM
Re: Problema con REQUERY
Posted: Sat Apr 09, 2022 12:45 AM

no hay nadie que pueda darme una mano con esto?

FWH 21.02
Harbour 3.2.0dev (r2104281802)
Copyright (c) 1999-2021, https://harbour.github.io/
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: Problema con REQUERY
Posted: Sat Apr 09, 2022 12:24 PM
Looks like you did not download FWH2102 Revised version.

If you downloaded revised version, you should find this in "fivewin.ch"

Code (fw): Select all Collapse
#define FWVERSION    "FWH 21.02 Revised"
#define FW_VersionNo 21021


Please check and let us know.
Regards



G. N. Rao.

Hyderabad, India
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: Problema con REQUERY
Posted: Sat Apr 09, 2022 12:27 PM

If you do not have the revised version, please give me your mail and we will send you the revised version.

Regards



G. N. Rao.

Hyderabad, India
Posts: 1956
Joined: Fri Oct 07, 2005 07:08 PM
Re: Problema con REQUERY
Posted: Sat Apr 09, 2022 12:29 PM
nageswaragunupudi wrote:If you do not have the revised version, please give me your mail and we will send you the revised version.


Please send me. I have sent an email to Antonio. Thank you.

Thanks
FWH 21.02
Harbour 3.2.0dev (r2104281802)
Copyright (c) 1999-2021, https://harbour.github.io/

Continue the discussion