reccount en mariadb

reccount en mariadb

Postby goosfancito » Mon Apr 25, 2022 9:02 am

Buen dia.
Necesito saber si esta consulta devuelve datos, si lo hago de la forma que lo hacia hasta ahora siempre me dice que devuelve pero no hay datos realmente.
Code: Select all  Expand view

   oQryLocal := ::oCnx:QUERY( AUXILIAR_ARBOL, { ::nIdcarpeta, ::nIdDanteCausa } )

   IF ( Len(oQrylocal) != 0 )
             ? "hay datos"
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: reccount en mariadb

Postby goosfancito » Mon Apr 25, 2022 9:07 am

Soluciuonado:

Code: Select all  Expand view
oRs:RecordCount() != 0
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: reccount en mariadb

Postby nageswaragunupudi » Mon Apr 25, 2022 12:24 pm

Code: Select all  Expand view
oRs:RecordCount()
oRs:RecCount()
oRs:LastRec()


--> Total number of records

When a filter is applied:
Code: Select all  Expand view
oRs:KeyCount()

Number of filtered records
Regards

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


Return to FiveWin for Harbour/xHarbour

Who is online

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

cron