FiveTech Software tech support forums

Thanks Rao
excellent clarification

Maurizio

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

...    :Open()ENDoBrw:Refresh()    But this doesn't work . Is there a solution or is it better to close xBrowse and reopen it? Regards Maurizio

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

Regards Maurizio
www.nipeservice.com

Hello
I tested on a table of 700,000 records , 350000Kb
Regards Maurizio

Thank Rao

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.

Is it possible to have a list of :RecSet() methods?

Thank you
Maurizio

RAO,
I wanted to ask you for advice on how to use tables with millions of data without experiencing a loss of performance

Grazie Maurizio

Hello
ors:Find() only works with one field.

If I need more fields use the Filter function

oRs:Filter = "ll_consec="+alltrim(cFcEn)+" AND ll_docume="+alltrim(cFcDc)
IF oRs:RecordCount() == 0

ENDIF
oRs:Filter := "
Maurizio "

Maurizio, gracias por publicar el código, funciona de maravilla

Dear Mst.Rao and Maurizio, I got another problem for ::nFreeze. If you scroll to right until the column hide under freeze, the :cExpr will show incorrected. I use cField := oBrw:aCols[oBrw:nColSel]:cExpr Maurizio Dear Master, It works ...

dutch wrote:Dear Mst.Rao and Maurizio,
I got another problem for ::nFreeze. If you scroll to right until the column hide under freeze, the :cExpr will show incorrected.

Maurizio wrote:I use

cField := oBrw:aCols[oBrw:nColSel]:cExpr

Maurizio

Try

Code: Select all  Expand view

cField := oBrw:SelectedCol():cExpr

Dear Maurizio, It's work correct, thanks. I don't know if this is correct but you can try with :nColOffSet oBrw:bLDblClick := <||            Local  n := oBrw:nColSel           if oBrw:nColOffSet >  1              n+= oBrw:nColOffSet ...

...      ? oBrw:aCols[n]:cExpr           Return nil          } Maurizio

Dear Mst.Rao and Maurizio,
I got another problem for ::nFreeze. If you scroll to right until the column hide under freeze, the :cExpr will show incorrected.

Maurizio wrote:I use

cField := oBrw:aCols[oBrw:nColSel]:cExpr

Maurizio

Hello Rao
how to specify the port with FW_OpenAdoConnection() ?

Maurizio