FiveTech Software tech support forums

... Called from: .\source\classes\XBROWSE.PRG => TXBROWSE:SETCOLFROMADO(4123) Called from: .\source\classes\XBROWSE.PRG => TXBROWSE:SETADO(3988) Called from: .\source\classes\XBROWSE.PRG => XBRWSETDATASOURCE(10553) Called from: .\source\classes\XBROWSE.PRG => XBROWSENEW(10375) ...

I modified souce this way: DEFINE WINDOW oDlgs MDICHILD OF wndMain() TITLE "Alteração de notícia" oLbx := TXBrowse():New( oDlgs ) oLbx:SetAdO( oRs, .t., .t., { "data_release", "titulo" } ) oLbx:aCols[ 1 ]:cHeader := "DATA" oLbx:aCols[ 2 ]:cHeader := "TÍTULO" ...

... IF oRs:RecordCount > 0 DEFINE WINDOW oDlgs MDICHILD OF wndMain() TITLE "Alteração de notícia" oLbx := TXBrowse():New( oDlgs ) oLbx:SetAdO( oRs, .t., .t., { "data_release", "titulo" } ) oLbx:aCols[ 1 ]:cHeader := "DATA" oLbx:aCols[ 2 ]:cHeader := "TÍTULO" ...

... 1 )  you must have already assigned the datasource ( cAlias, oRs,oDbf. etc. with methods like SetRDD/SetADO,etc and preferably define atleast some columns ). My advice is that the datasource be defined soon after creating the xbrowse.

... can contain only N,C,D,L and NIL. It is programmeer's responsibility to ensuring the data does not contain any codeblocks/objects.etc. * xBrowse: SetADO() can now handle adLongVarChar and adLongVarWChar also. * Enhancement: samples\RC2PRG.prg utility has been enhanced. Thanks to Armando! * New: ...

Mr. James This syntax is OK; it is the same as oBrw:setADO( oRS ) Note that a recordset is not an alias. There is no alias used when using a recordset. In TWbrowse you had to set cAlias to nil to prevent it erroring--this was really a workaround for ...

Rick, RECORDSET oRsTrip                   ;   // recordset alias This syntax is OK; it is the same as oBrw:setADO( oRS ) Note that a recordset is not an alias. There is no alias used when using a recordset. In TWbrowse you had to set cAlias to nil to prevent it erroring--this ...

Rick,

Try issuing a oBrw:gotop() right before the oBrw:refresh().

Also, are you using oBrw:setADO(oRecordset) to setup the original browse?

James

... putting a MsgInfo() right after that statement to see. Your error message is indicating that it is erroring out right after a call to TXBrowse:setado(). James

... TXBrowse. The error you are getting seems to indicate that the new recordset is not opened. Try verifying that it is. You could try a call to oBrw:setADO( oRecordset ) after opening the new recordset. Perhaps you could make a very simple example of switching the recordset and using the same TXBrowse. ...

... Called from: D:\xHarbour\source\rtl\win32ole.prg => TOLEAUTO:FIELDS(0) Called from: C:\FWH\SOURCE\CLASSES\xbrowse.prg => TXBROWSE:SETADO(3277) Called from: C:\FWH\SOURCE\CLASSES\xbrowse.prg => XBRWSETDATASOURCE(7636) Called from: C:\FWH\SOURCE\CLASSES\xbrowse.prg => XBROWSE(7923) ...

Raymundo

Como ya te indiqué, para arrays en lugar de oBrw:SetAdo(), usas oBrw:SetArray(adatos) eso es todo.

Un Saludo

Marcelo Jingo

Un saludo amigos del foro Es posible indicarle al Xbrowse qué ordene una columna n al inicializarlo?. Con oBrw:SetAdo(oRs,,.t.) se produce el autosort para todas las columnas, pero dentro del browse hay que hacer click en el encabezado de cada columna para que se ordenen, eso ...

... keep in mind that when we specify AUTOSORT clause in the XBROWSE command or specify lAutoSort as parameter in any of the set methods like SetRDD, SetADO, SetODBF, SetArray, XBrowse automatically constructs bSeek codeblock. This default codeblock is generally much superior to what we can ourselves ...

JfaFive...

Es mas sencilo...
Antes del oBrw:Refresh()
pon un oBrw:SetAdo(oRcs, .T., .T.)

Prueba y me comentas
Saludos

Desde Chile
Adolfo