FiveTech Software tech support forums

Pieter,

As I commented to Erwin, to me the shortest and easiest way is to implement a Method SetAdo() for your Class PBrowse().

You may use Class TXBrowse Method SetAdo() as a reference and Class TWbrowse Method SetArray() as the template to follow.

... you may try the approach you proposed with these modifications: 1. delete all columns as in your code. then oBrw:lAdjusted := .f. // new oBrw:SetADO( oRsNew ) // You may use last param aFldNames if you want specific fields // Here you insert other code like changing bEditValue, SetCheck() ...

... of the recordset are not identical. I solved in this way Open new Recset oNewRs FOR i := len(oBrwLis:aCols) to 1 STEP - 1 oBrw:DelCol(i) NEXT oBrw:SetADO( oNewRs ) oRsOld:Close() oBrw:GoTop() oBrw:Refresh() Is correct use oBrw:SetADO( oNewRs ) or can cause side effects ? I have another question ...

... Hope you know we can browse oDlg, oWnd, etc .. any object ) ------------- Having said this, let me add a few notes: Hereafter no new methods like SetAdo, SetArray, etc will not be added to accommodate new classes. It is enough if the class is designed providing above methods and any such object ...

...       HEADERS "Usuario","Población"    //        oLbx:SetAdo(oRs) // Do not call this method  Please do not use FIELDS clause Instead use COLUMNS clause as shown as above. Do not forget to specify ...

... it is not desirable to set this data to .t. For Array and Recordset browses, lVThumbTrack is set to .t. by default in the SetArray() and SetADO() methods, because in both cases the data resides in the memory. Because it is not possible for xbrowse to decide the data access speeds in case ...

... la clase XBrowse, nuevo DATA bDelete y nuevo método Delete(). oBrw:Delete() evalua bDelete si ha sido asignado y refresca el “browse”. SetRDD(), SetADO, SetOdbf, SetArray y SetTDolphin asignan por defecto el bloque de código bDelete. Así, por defecto oBrw:Delete() borra la fila actual y refresca ...

... * New: XBrowse new DATA bDelete and new Method Delete() oBrw:Delete() evaluates oBrw:bDelete if assigned and refreshes the browse. SetRDD(), SetADO, SetOdbf, SetArray and SetTDolphin assign default bDelete codeblocks. So, by default oBrw:Delete() deletes the current row and refreshes the ...

... padre, tampoco muestra el primer registro agregado,(lo hace cuando cierro el dialogo y entro de nuevo) entonces concluyo que es al crear un browse:setado(oRs) con un recordset vacío cuando no se refresca. estamos cercando el problema. saludos y gracias

Rao is correct .. this particular error drives me nuts from time to time .. Stack Calls =========== Called from: => TOLEAUTO:RECORDCOUNT( 0 ) Called from: .\source\classes\XBROWSE.PRG => (b)TXBROWSE_SETADO( 4277 ) Called from: .\source\classes\XBROWSE.PRG => TXBROWSE:PAINT( 1381 ) Called fr...

Hola a todos: Estoy usando un browse con setado, el problema es que navego en el y al editar el registro simpre me abre el primero, no en el que estoy posicionado con el puntero. alguna pista oBrwDet:SetAdO( oRsDetOrdSrv, .t., .t., { ...

... aIdx ID 1007 OF oDlg UPDATE; ON CHANGE SeOrden(oCbx,oLbx,nIndex) REDEFINE SAY oSay ID 101 OF oDlg UPDATE FONT oVentPrinc:oFont COLOR CLR_BLUE oLbx:SetAdo(cMa_Ctes) oLbx:bSeek := {|c| BBus(c,cMa_Ctes,nIndex[cVar]) } oLbx:oSeek := oSay oLbx:bKeyDown := {|nKey| iif( nKey=13,(cKey := ADOField(cMa_Ctes,"ma_rutc"),oDlg:End() ...

... lo que no sé es como volverle a asignar al browse el nuevo objeto para que lo muestre. Así como para un objeto recordset lo muestro con oBrw : SetAdo( oRs), para mostrar un objeto oTxt generado por la clase TTxtFile, cual es el método ??? Espero haberme explicado. Nuevamente gracias por tu ...

... 0 ) Called from: .\source\classes\XBROWSE.PRG => TXBROWSE:ADOINCRSEEK( 4860 ) Called from: .\source\classes\XBROWSE.PRG => (b)TXBROWSE:SETADO( 4310 ) Called from: .\source\classes\XBROWSE.PRG => TXBROWSE:SEEK( 6043 ) Called from: .\source\classes\XBROWSE.PRG => TXBROWSE:KEYCHAR( ...

... and OrdKeyGoTo( n ) by oRs:AbsolutePosition = n. I don't know if it can be of any help. EMG You are right. That is how XBrowse's SetAdo() works. But I think SQLRDD does not use ADO. Instead it uses the native libraries of the respective RDMS. I also do not *think* SQLRDD does ...