FiveTech Software tech support forums

Amigos del foro:

En un record set tenemos los comandos

oRs:MoveFirst()
oRs:MoveLast()
oRs:MoveNext()
oRs:MovePrevious()

La pregunta, existe el comando para moverse a un registro especifico?, algo como
oRs:Move(30) <===== movernos al registro 30

Saludos

hi,

i can use ADO Method MoveFirst, MoveLast, MoveNext and MovePrevious to move to a Position but how to get the actual "Position" in ADO Recordset
RECNO() does not work with EXCEL ...

how to find out how many ROW Recordset have

... ID 181 of odlg ; font ofont1 oBrow:bLogicLen = { || oRS1Cli:RecordCount } oBrow:bGoTop = { || oRS1Cli:MoveFirst() } oBrow:bGoBottom = { || oRS1Cli:MoveLast() } oBrow:bSkip = { | nSkip | Skipper( oRs1Cli, nSkip ) } oBrow:lcellstyle := .f. oBrow:nlinestyle := 2 oBrow:nclrpane := { || iif( ( oRS1Cli:AbsolutePosition ...

Solamente añadir que todos los comandos como Movefirst, MoveLast, etc, funcionan perfectamente, sólamente el comando Seek, Find, Locate, que la verdad es que no sé si lo estoy haciendo del modo correcto.

... not yet saved. 61. Move( n ) Same as ::Skip( n ). This method is created for compatibility with ADO syntax 62. MoveFirst() Same as GoTop(). 63. MoveLast() Same as GoBottom() 64. MoveNext() Same as Skip( 1 ) 65. MovePrevious() Same as Skip( -1 ) 66. OemToAnsi() Internal Internally used when ::lOemToAnsi ...

... ) takes back to the same record even after sorting and / or filtering, if the record is not deleted. GoTop(), GoBottom(), Skip( n ) MoveFirst(), MoveLast(), MoveNext(), MovePrevious(), Move( n ) Work similar to DBF and RecordSet, navigating in the sorted order, respecting filters. OrdKeyCount(), ...

... TDatabase like GoTop,GoBottom,GoTo,Skip,Eof,Bof,LastRec,RecCount,KeyCount,KeyGoTo, etc Also supports aliased methods compatible with ADO MoveFirst,MoveLast,Move,BookMark,AbsolutePosition, etc DATA oChild // Optional child rowset created with oRs:AddChild(...) Sorting the rowset in memory: oRs:SetOrder( ...

... like oData:Salary := 2500 - All navigational methods similar to DBF and also RecordSet can be used (eg. gotop(), gobottom(), movefirst(), movelast(), etc ) - While it is desriable to initialize with multi-dim array conforming to the data structure provided, single dimentional and ragged ...

... 4556 ) Called from: .\source\classes\XBROWSE.PRG => (b)TXBROWSE( 438 ) Offending line: ::bGoBottom := {|| If( ::oRs:RecordCount() > 0, ::oRs:MoveLast(), nil ) },; Can you please verify at METHOD SetAdO( oRs, lAddCols, lAutoOrder, aFldNames ) CLASS TXBrowse that oRs is not nil?. Thank you.

... the lSoftseek and since it works with filter can take an eternity. Im trying this alternative and I would like to have your opinions: oRecordSet.MoveLast oRecordSet:Find( "NAME = 'whatever' ", , adSearchBackward) oRecordSet:Move(1) == lSoftSeek The remaining problem is when the cKey ...

Buenas tardes.
Y no te sirve oRs:MoveLast() ?

http://www.w3schools.com/asp/ado_ref_recordset.asp


Saludos.

Antonio,

Antonio Linares wrote:oRS:MoveLast()
oRs:AddNew()
fill the right values
oRS:Update()

You can safely remove oRS:MoveLast().

EMG

Lucas,

I am using ADO + Access on a development and I don't call oRs:Requery() when adding a record and here it works fine

I use:

oRS:MoveLast()
oRs:AddNew()
fill the right values
oRS:Update()

... Fail"   endifreturn aStates  what is the equivalent for recordset DO WHILE !EOF() and, also, Dbskip()?. oRs:MoveFirst() // GoTop oRs:MoveLast() // gobottom oRs:MoveNext() // skip( +1 ) oRs:MovePrevious() // skip( -1 ) oRs:Move( n ) // Skip( n ) oRs:Bof() and oRs:Eof() // same as dbf ...

... STDCALL dispatch FUNC void MoveNext() STDCALL dispatch FUNC void MovePrevious() STDCALL dispatch FUNC void MoveFirst() STDCALL dispatch FUNC void MoveLast() STDCALL dispatch FUNC void Open( [optional] VARIANT, [optional] VARIANT, [defaultvalue] USERDEFINED, [defaultvalue] USERDEFINED, [defaultvalue] ...