FiveTech Software tech support forums

Posted: **Tue May 08, 2018 3:21 pm**

Mr Rao.

I have a xBrowse which I need to update with a different FwhMysql rowset. When I created it I do

oDbDat:=oSvr:Rowset(xSelect)
oBrow:setMysql(oDbDat,.T.,.T.)

Later on I need to change the select (same fields, but different data), then I do.

oDbNew:=oSvr:Rowset(NewSelect)
oDbDat:=oDbNew
oBrw:Refresh()
SysRefresh()

But nothing changes on the Browse, the old data is still present ( if I call a xBrowse(oDbDat) after assign oDbDat:=oDbNew to check it, the new data is there, but no replicated in the Browse)

Any Ideas
FWH 17.04

Posted: **Tue May 08, 2018 3:48 pm**

Please try this sample.
You may adopt this logic to your situation

Code: Select all

   local oCn, oRs, oRs2
   local oDlg, oBrw

   oCn   := FW_DemoDB()
   oRs   := oCn:RowSet( "SELECT first,city,state,salary FROM customer where state = 'NY'" )

   DEFINE DIALOG oDlg SIZE 600,400 PIXEL TRUEPIXEL

   @ 60,20 XBROWSE oBrw SIZE -20,-20 PIXEL OF oDlg ;
      DATASOURCE oRs AUTOCOLS CELL LINES NOBORDER
   oBrw:CreateFromCode()

   @ 20,20 BUTTON "Change RS" SIZE 150,30 PIXEL OF oDlg ;
      ACTION ( oRs2  := oCn:RowSet( "SELECT first,city,state,salary FROM customer WHERE state = 'CA'" ), ;
               oBrw:oDbf   := oRs2, ;
               oBrw:GoTop(),        ;
               oBrw:Refresh() )

   ACTIVATE DIALOG oDlg CENTERED
   oRs := nil
   oRs2 := nil
   oCn:Close()
   oCn := nil

Posted: **Wed May 09, 2018 12:51 pm**

Thanks a lot...it works perfect

Greetings from Chile
Adolfo

FiveTech Software tech support forums

Refreshing xBrowse Problem

Refreshing xBrowse Problem

Re: Refreshing xBrowse Problem

Re: Refreshing xBrowse Problem