FiveTech Software tech support forums

... Time from start: 0 hours 0 mins 13 secs Error occurred at: 06-03-2017, 15:35:55 Error description: Error ADODB.RecordSet/6 DISP_E_UNKNOWNNAME: RECORDCOUNT Args: Stack Calls =========== Called from: => TOLEAUTO:RECORDCOUNT( 0 ) Called from: .\source\classes\XBROWSE.PRG => (b)TXBROWSE:SETADO( ...

... remains constant during the life of the rowset, even after deletion of some records. The behavior is similar to LastRec() of DBF. RecCount() or RecordCount() // compatible with ADO Total number of records in the RowSet, reduced by records deleted, if any. KeyCount() // similar to OrdKeyCount() ...

... rowset This number remains constant even after deletion of some records. Behavior similar to DBF. Adding records increases the number. RecCount()/RecordCount(): Actual number of records. This is equal to LastRe() less number of deleted records. In the present version deleted records are totally ...

... + ALLTRIM(cShipno) + "' ORDER BY shipmentno DESC" TRY oSqlSeek:Open( cSqlSeek, xSQL ) CATCH oError lError := .T. END IF (oSqlSeek:RecordCount>0) cTxemail := oSqlSeek:Fields( "TXEMAIL" ):Value ENDIF ENDIF IF VALTYPE(cTxemail)<>"C" cTxemail := "aceaes@cdmsoft.com" ...

... results I got did not seem different from the original program I am replacing .. all the totals seemed to add up, only when I looked at the oRs:RecordCount() did I realize I was returning a ton of rows at a horrible performance price. After reviewing the recordsets did I realize my error using ...

Hello, I am getting this error reported by some customers: Error description: Error BASE/1004 No existe el m‚todo: RECORDCOUNT Args: [ 1] = U Stack Calls =========== Called from: => RECORDCOUNT( 0 ) Called from: .\source\classes\XBROWSE.PRG => (b)TXBROWSE_SETADO( 4556 ) Called ...

... to adUseServer and CursorType as adDynamic. In such cases the provider might even support adSeek In this case we need to adopt workarounds for recordcount()

... then leave it. The programmer anyway will face lots of problems and learn by mistakes. Anyway for small tables we may compare COUNT(*) with oRs:RecordCount() and decide, though it is slow and not foolproof. When opening a table it is easy for us to identify the primary key and also if it is ...

... total records in the table The index records are logical so not the same as table records. In adordd OrdKeyNo = AbsolutePositon and OrdKeyCount = RecordCount LastRec Reccount = see function my previous post Recno = value of fieldrecno Does filter works without indexes? Here ok Does filter works ...

... FUNCTION ADO_RECCOUNT( nWA, nRecords )   LOCAL oRecordSet := USRRDD_AREADATA( nWA )[ WA_RECORDSET ],nRecNo   IF oRecordSet:RecordCount() < 0      nRecords := ADORECCOUNT(nWA,oRecordSet) // AHF SEE FUNCTION FOR EXPLANATION oRecordSet:RecordCount()      ...

... version you just send me, there are some bugs so far: At, ADOFINDREC(), oRecordSet:AbsolutePosition := IF( oRS:AbsolutePosition == adPosEOF, oRS:RecordCount() + 1, oRS:AbsolutePosition ) is failing, as IF( oRS:AbsolutePosition == adPosEOF, oRS:RecordCount() + 1, oRS:AbsolutePosition ) its giving ...

... version you just send me, there are some bugs so far: At, ADOFINDREC(), oRecordSet:AbsolutePosition := IF( oRS:AbsolutePosition == adPosEOF, oRS:RecordCount() + 1, oRS:AbsolutePosition ) is failing, as IF( oRS:AbsolutePosition == adPosEOF, oRS:RecordCount() + 1, oRS:AbsolutePosition ) its giving ...

Antonio, I am also having trouble with MySQL. For somehow, at ADOFINDREC() oRecordSet:AbsolutePosition := IF( oRS:AbsolutePosition == adPosEOF, oRS:RecordCount() + 1, oRS:AbsolutePosition ) is set to -1, and it gives an error. oRecordSet:AbsolutePosition can´t be minor than 0. Do yoy know why? Thank ...

Rick al hacer lo que dices, no se produce el error, pero en cuanto accedes a la barra de botones, desaparecen los registros y el Browse queda vacío a la vista. Como dato curioso he de decir que si quito el cierre de los recordsets tampoco se produce el error pero indica que no existe el recordset en...

Pedro Two things .. 1) Remove the SysRefresh() <-- this is most likely the cause or the error 2) After you close your table oRsDiario assign 0 to the following code blocks :    oRsDiario:Close()   oBrw:bKeyCount := { || 0 }   oBrw:bKeyNo   &nbs...