FiveTech Software tech support forums

... ID 120 OF oDlgStk ACTION ( lsave := .t., oDlgSTK:End() ) REDEFINE button btnMod ID 130 OF oDlgStk action (Editstock( oBrow, oCon, oRS1, oRS1:AbsolutePosition, .t. ), cSQL := wwcSQL) // Editstock( obrow, .t. ) REDEFINE button btnOK ID 4002 OF oDlgStk ACTION veoplan( precio_vta, 9, 0 ) REDEFINE ...

... the only option is to make an ASCAN into the array obtained with RsGetRows( oRs ), and then, position the cursor in the oRS recordset with Rs:AbsolutePosition := nPos. The code with de option: Function Main()   LOCAL aStruct := {}, aRegs := {}, oRs   SET EXCLUSIVE ...

hi,

nageswaragunupudi wrote:After sorting, oRs:BookMark points to the record number in the original order as read where as oRs:AbsolutePosition points to the relative position in the sorted order.

ah, understand

thx for all Answer

oRs:BookMark --> is like RECNO() of DBF oRs:AbsolutePosition --> is like OrdKeyNo() of DBF After reading a recordset, both point to the same record. After reading a recordset, we can sort the recordset in memory by oRs:Sort := cFieldName After ...

Jimmy,

Equivalents:

Found() --> .not. oRs:Eof()
RecNo() --> oRs:BookMark
DbGoTo( n ) --> oRs:BookMark := n
OrdKeyNo() --> oRs:AbsolutePosition
OrdKeyGoTo( x ) --> oRs:AbsolutePosition := x

Regards,

... to ( oBrw:cAlias )-> GOTO( n ) for DBF and is equivalent to oBrw:oRs:BookMark := n for ADO Same way oBrw:KeyNo is same is OrdKeyNo() for DBF, AbsolutePosition of ADO, etc XBrowse can handle many types of datasources, which use different methods, functions and datas. We talk to XBrowse is one ...

... } oBrow:bSkip = { | nSkip | Skipper( oRs1Cli, nSkip ) } oBrow:lcellstyle := .f. oBrow:nlinestyle := 2 oBrow:nclrpane := { || iif( ( oRS1Cli:AbsolutePosition / 2 ) - INT( oRS1Cli:AbsolutePosition / 2 ) > 0, RGB( 193, 221, 255 ), RGB( 221, 245, 255 ) ) } oBrow:GoTop() oBrow:aActions = { ...

If the customer selects columns and then changes the oRs order (since SetMultiSelectCol works with oRs: AbsolutePosition) NO. oBrw:aSelected is NOT an array of oRs:AbsolutePositions. It is an array of oRs:BookMarks BookMark of a RecordSet is like RECNO() of DBF. Does not change ...

... and lAutosort (as example) . If the customer selects columns and then changes the oRs order (since SetMultiSelectCol works with oRs: AbsolutePosition) the result of the selected columns is wrong . I think SetMultiSelectCol should work on the table ID . #include "fivewin.ch"function ...

joseluispalma wrote:Thank you/ gracias.

And oRs:AbsolutePosition is supported?

Yes

Thank you/ gracias.

And oRs:AbsolutePosition is supported?

... + str(val( tfactura[ i, 10 ] ),10,2) + ", cancelado = 9999999 where id = " + str(tregistro[ i ]) + chr( 13 ) + chr( 10 ) else wrecset:AbsolutePosition = tregistro[ i ] //wrecset:find("factura"=jk ) //oRs:Find( "file_num = '"+cFIND+"'" ) if tfactura[ i, ...

... a una fila eliminada o a una fila marcada para eliminar. (0x80040E23): Microsoft Cursor Engine Stack Calls =========== Called from: => TOLEAUTO:ABSOLUTEPOSITION( 0 ) Called from: .\source\classes\XBROWSE.PRG => (b)TXBROWSE_SETADO( 5620 ) Called from: .\source\classes\XBROWSE.PRG => (b)TXBROWSE( ...

OrdKeyCount() We did not create this method. Instead you can use method KeyCount() AbsolutePosition: Correct spelling is ABSOLUTEPOISTION and not ABSOUTEPOSITION. This access method is provided for compatibility with ADO. The result is the same as KeyNo() LastRec(): ...

... order, respecting filters. OrdKeyCount(), OrdKeyNo(), OrdKeyGoTo( nKeyNo ) KeyCount(), KeyNo(), KeyGoTo( nKeyNo ) RecordCount(), AbsoutePosition, AbsolutePosition := n All these methods work exactly the same way as DBF / RecordSet After sorting it is only KeyNo() that appears serially but not ...