Problema con REQUERY

Problema con REQUERY

Postby goosfancito » Thu Apr 07, 2022 9:16 am

Hola. Tengo este codigo
Code: Select all  Expand view  RUN
  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/
User avatar
goosfancito
 
Posts: 1954
Joined: Fri Oct 07, 2005 7:08 pm

Re: Problema con REQUERY

Postby goosfancito » 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/
User avatar
goosfancito
 
Posts: 1954
Joined: Fri Oct 07, 2005 7:08 pm

Re: Problema con REQUERY

Postby nageswaragunupudi » 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: Select all  Expand view  RUN
#define FWVERSION    "FWH 21.02 Revised"
#define FW_VersionNo 21021
 


Please check and let us know.
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10690
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: Problema con REQUERY

Postby nageswaragunupudi » 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
User avatar
nageswaragunupudi
 
Posts: 10690
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: Problema con REQUERY

Postby goosfancito » 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/
User avatar
goosfancito
 
Posts: 1954
Joined: Fri Oct 07, 2005 7:08 pm


Return to FiveWin para Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 123 guests