- Code: Select all Expand view
- 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.