topic-41691

Board index FiveWin for Harbour/xHarbour reccount en mariadb

Posts: 1956

Joined: Fri Oct 07, 2005 07:08 PM

reccount en mariadb
Posted: Mon Apr 25, 2022 09: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 (fw): Select all Collapse

   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/

goosfancito

Posts: 1956

Joined: Fri Oct 07, 2005 07:08 PM

Re: reccount en mariadb
Posted: Mon Apr 25, 2022 09:07 AM

Soluciuonado:

Code (fw): Select all Collapse

oRs:RecordCount() != 0

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

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: reccount en mariadb
Posted: Mon Apr 25, 2022 12:24 PM

Code (fw): Select all Collapse

oRs:RecordCount()
oRs:RecCount()
oRs:LastRec()

--> Total number of records

When a filter is applied:

Code (fw): Select all Collapse

oRs:KeyCount()

Number of filtered records

Regards

G. N. Rao.

Hyderabad, India

FiveTech Support Forums

Continue the discussion