len( oqry) me devuelve mal un valor (creo)

[goosfancito]

Hola.
La tabla "no tiene registros" y este codigo (mariadb) me devuelve que tengo 91, estoy intentando hacer un
procedimiento para verificacion de usuario

Code: Select all  Expand view

 LOCAL oQry, cSql

   TEXT into cSql
   Select
   *
   FROM tbautoriza AS a
   WHERE a.usuario = ?
   ENDTEXT

   //aca qyedi

   oQry := ::oCnx:QUERY( cSql, { ::vGets[ 1 ] } )
 

[nageswaragunupudi]

There is no way we can verify and help you.

We have a suggestion.

If you connect to our FiveWin cloud server

Code: Select all  Expand view

oCn := FW_DemoDB( 6 )
 

we have many tables on the server. We have `customer`, `states` and many more tables.

If you prepare an independent small program with the tables on this server, we can run the program at our end and provide you support.