FiveTech Software tech support forums

... IsDisplayPosVisible(), LastDisplayPos(), BrwWidth(), GridWidth(), BrwHeight(), HeaderHeight(), FooterHeight(), CalcHdrHeight(), RowCount(), FirstRow(), LastRow(), FooterRow(), DataHeight(), BrwFitSize(), CancelEdit(), Check_oSeek(), SetSortBmp(), AutoFit(), CheckSize(), Resize ...

... Returns the total number of rows in the data source.

Parameters: None

Return Value: NUMERIC - Total number of rows.

Usage Example:

nRowCount := oBrw:KeyCount()
content_copy
download
Use code with caution.
Harbour

197. BookMark( uGoTo )

Description: Sets or gets the bookmark position ...

... Description**: Sets the data source and field for the list.
- **Parameters**: `uDataSource`, `cField`.
- **Returns**: None.

16. **`RowCount()`**
- **Description**: Returns the number of visible rows in the list.
- **Returns**: Numeric (count of visible rows).

### Additional ...

Hi

"select * from tablename where userid = '"+cUserId+"'"
if tablename.rowcount > 0
fnCheckPassword()
else
MsgInfo('User Not Found')
endif

Hope this is what you meant.

Colin


Can you explain this a little more..
i did a quick test of this, changed tablename to (members) where username ...

Hi

"select * from tablename where userid = '"+cUserId+"'"
if tablename.rowcount > 0
fnCheckPassword()
else
MsgInfo('User Not Found')
endif

Hope this is what you meant.

Colin

... in the forum ,
I would like to know how do I read the value of a cell in the selected row of a QtableView ?
msginfo(oBrw:setCurrentCell(oBrw:rowCount()-1,0):value) // I would love to return
Thanks a lot

Italiano
Salve, sto iniziando ad utilizzare la fivetouch con esempi trovati qui nel forum ...

salve
in questo esempio mi ritorna Errore nei comandi :

oBrw:setCurrentCell(0,0)
oBrw:setCurrentCell(oBrw:rowCount()-1,0)

Grazie

* ------------------------ ELENCO
FUNCTION Elenco( fDbf, fNtx )
local oDlg := QDialog()
local oBrw := QTableView( oDlg )
local oModel := QStandardItemModel( 3, 4, oDlg ...

... oDlg:Exec()

Video->( DBCLOSEAREA() )

return nil

// ------------------------------------ Altre Funzioni

PROCEDURE Top( oT )
oT:scrollToTop()
oT:setCurrentCell( 0, 0 )
oT:setFocus()
RETURN

PROCEDURE Bot( oT )
oT:scrollToBottom()
oT:setCurrentCell( oT:rowCount() - 1, 0 )
oT:setFocus()
RETURN

... stmt=$conn->prepare($cSenEje);
$stmt->setFetchMode(PDO::FETCH_ASSOC);
$stmt->execute(array($cEmpSuc,$cCodCon,$cDocGra));
$registros = $stmt->rowCount();
unset($stmt);

if ($registros > 0) {
actualizaConsecutivo($conn,$codigoConsecutivo) ;
$nDocGra = ( $nDocGra + 1 );
} else {
$noExiste ...

... sec WRITE, transainventarios WRITE, conceptosinventarios AS con WRITE;";
};
$stmt=$conn->prepare($cSenEje);
$stmt->setFetchMode(PDO::FETCH_ASSOC);
$stmt->execute();
$registros = $stmt->rowCount();
unset($stmt);
}

//*************************************************************

Johnson Russi

... possible solution is to create a new DATA in Txbrowse , nMaxrow.

First lines from BrwFitsize

local nMaxRow
IF ::nMaxRow == nil
::nMaxRow := ::RowCount()
END
DEFAULT nMaxRow := ::nMaxrow

Then we can call Brwfitsize as usual and must give no attention to set nMaxrow in the calling routine ...

... lHscroll := .F. :CreateFromCode() ENDACTIVATE DIALOG oDlg CENTER ON INIT oBrw2:BrwFitSize(.T.)RETURN

Starting this aplication , RowCount() from oBrw2 is adjusted to 6 elements , the second browse fit's to 6 elements.

Giving el2 from obrw1 (second row) focus adjust rowcount() from ...

nFirstKeyNo := oBrw:KeyNo() - oBrw:nRowSel + 1
nLastKeyNo := nFirstKeyNo + oBrw:RowCount() - 1

In case of RDD, nFirstKeyNo and nLastKeyNo are the OrdKeyNo() of the first and last records displayed.

In case of Array, nFirstKeyNo and nLastKeyNo are the first and last array elements displayed. In case ...

... lt;/RutUsuario&gt;&lt;RutEmpresa&gt;90000008-0&lt;/RutEmpresa&gt;&lt;RutAgencia&gt;&lt;/RutAgencia&gt;&lt;/header&gt;"><result><srvs result="ok" rowCount="1"><data TTotal="14" id="consultarCausalesRechazo" result="ok" rowCount="3" rowCountTotal="3"><row CODI_TDOC="101" CONT_VALI="Validación de ...

Hola Armando,

Si la longitud del array varía, puedes ponerlo asi:

nLenArray:=len(aArray)
oFr:SetProperty("MasterData1", "RowCount",nLenArray)

Un saludo,
Ernesto.