FiveTech Software tech support forums

... de Windows. * samples\mariabig.prg: Leer y navegar una tabla con 4.1 millones de registros desde un servidor mysql en la nube usando la clase RecSet() de la librería FWHMaria. * Mejora: Nuevo método Dispatch( bAction ) en la clase TWebView. bAction es un bloque de código que toma hWebView ...

... view oem box chars in a Winodws application. * samples\mariabig.prg: Read and Browse table with 4.1 million records from mysql cloud server using RecSet() class FWHMaria lib * Enhancement: Class TWebView() new METHOD Dispatch( bAction ) where bAction is a codeblock that gets the hWebView as the ...

Both RowSet and RecSet were available from the very beginning. Please continue using RowSet(...) only for normal use. You may use RecSet() only when you need to read for very large tables ( say more than 50000 records) and display ...

nageswaragunupudi wrote:Please see
viewtopic.php?f=3&t=44175

What is different between ::RowSet() and ::RecSet()?
Which the latest table FWH version of TRECSET ?

I have FWH2304 but not much of information of TRECSET, such as full parameter.

Thanks in advance,

oCn:RowSet( cSql, 100 ) means read first 100 records only Sameway oCn:RecSet( cSql, 100 ) also means read first 100 records only. But oCn:RecSet( cSql, -100 ) means read entire table with page size 100. RecSet does not read entire table atonce. That will take ...

Thanks Rao ,
just what I was looking for .
What does -100 mean in oCn:RecSet( cSql, -100 )
I knowo Cn:RecSet( cSql, 100 ) but not with a negative sign

Regards Maurizio

:ActiveConnections is only for ADO recordsets. In fwmaria lib, it is oRs:oCn. To change the sql, please make a new RecSet object, set it to oBrw:oDbf and then close the old RecSet object You may try this sample and use similar logic #include "fivewin.ch"function Main()  ...

Hello RAO Since it is not possible to use filters with RecSet I am trying to close and reopen RecSet in xBrowse. I normally use WITH OBJECT oBrw:oRs         :Close()         :Source  := cNewSelectWithWhere          :ActiveConnection := oServer  ...

Thanks Mr Rao....

Thanks RAO for the clear specification, and how to use RecSet.
Now we also know what methods are available.

Regards Maurizio
www.nipeservice.com

... FieldGet(),FieldPut() SetOrder(cSort,,lDescend) Save() Close() or End() --------------- NOT SUPPORTED: Seek(), Filter(),Delete(),Append() The RecSet class is created in such rare cases where it is essential to read and display a big table in full. This is not possible with other libraries ...

You are right. With RecSet, eof() and bof() do not work. We will try to provide this in future versions. for now you can use this: nRecs := oData:RecCount()nSave := oData:RecNo()do while oData:RecNo() <= nRecs  ...

What about calling oData:MoveFirst() before starting the Do while Loop ?

I'm trying oCn:RecSet() and it's very, very fast, I noticed that certain methods that work with oCn:Rowset() with :RecSet() don't work.

What size of tables you tested?

Mr Rao You can help me please , I use RecSet, but not work correctly, EOF() and BOF() not workink with RecSet, see you this example: I used MaeiaDb Function ListaUser(oCn)local lOK, cData, oData, aRet := {}lOk := .t.cData := ...