FiveTech Software tech support forums

[quote]::oBrt:bOnChanges := { || ::oRsTestate:ReSync(),; ::oBrt:RefreshCurrent(),; ::oBrt:MakeTotals(),; ::oBrt:RefreshFooters() } [/quote Before I go into the main topic, I like to advise you that this code is not required. XBrowse automatically ...

... new values and returns number of rows updated ReQuery ( [aNewParams] ) Reads data fully again from the server, optionally applying new parameters ReSync() Reads current record from the server and updates the values in the rowset

... 13:45:05: FWMARIACONNECTION:EXECUTE_SQL( 6163 ) cCallStack( "<-", 3 ) = "FWMARIACONNECTION:EXECUTE( 6453 )<-FWMARIAROWSET:RESYNC( 3757 )<-FWMARIAROWSET:ROWGET( 4971 )<-TDATAROW:READOBJ( 943 )<-TDATAROW:LOAD( 251 )<-TDATAROW:NEW( 196 )<-FWMARIAROWSET:DATAROW( ...

... by oRecA:save() and oRecB:save(), the database confirms the update/appended but even with oRs:SyncChild() or oRs:oChild:SyncChild(), or oRs:oChild:ReSync() oRs:oChild:oChild:ReSync() .... or :ReQuery or :Refresh() the content of oRs:oChild:oChild wasn't updated ??? I couldn't make a small sample ...

... have add another function ItemSaved() and Ithink the problem solved. I have used the original datarow.prg. Of course some more lines like oRsItems:ReSync(), oBrw:RefreshCurrent() is needed. static function EditItems( oRec ) ...    // ACTION If( oRec:Save(), oDlg:End(), nil )   ACTION If( ...

Mr. Rao,

I got it!

oRs:ReSync()
oRs:SyncChild()

refreshes the oRs:oChild...

... log file: 05/03/18 14:31:41: FWMARIACONNECTION:EXECUTE_SQL( 5369 ) CallStack() = " <- FWMARIACONNECTION:EXECUTE(5609) <- FWMARIAROWSET:RESYNC(3380) <- FWMARIAROWSET:EDITBASERECORD(4186) <- (b)MAIN(54) <- TBUTTON:CLICK(179)" cSql = "SELECT * FROM esocial AS esc WHERE ...

... 28/03/2018 13:54:00: FWMARIACONNECTION:EXECUTE_SQL( 5369 ) CallStack() = " <- FWMARIACONNECTION:EXECUTE(5609) <- FWMARIAROWSET:RESYNC(3380) <- FWMARIAROWSET:EDITBASERECORD(4186) <- (b)SFP213(72) <- TBUTTONBMP:CLICK(179)" cSql = "SELECT * FROM esocial AS esc ...

... \ Source \ internal \ FWMARIA.PRG => FWMARIAROWSET: REQUERY (3114)    Called from:. \ Source \ internal \ FWMARIA.PRG => FWMARIAROWSET: RESYNC (3407)    Called from:. \ Source \ internal \ FWMARIA.PRG => FWMARIAROWSET: SAVE (3902)    Called from: ADMP1190.PRG => SAVE (172)

... were restored but record pointer is moved to top. Now the record pointer is positioned on the previous record with the same primary key. - Method ReSync() Fix: Resync() was failing on some rare cases, where table contained joins, fields with the same name exist in more than one table and the alias ...

... to oRs:Requery() of RowSet. These methods read and load the entire table again from the server and we like to avoid it as far as possible. RowSet:ReSync() reads only one record from the server and updates the rowset. This is fast. After modifying the record With Dolphin oDbCli:LoadQuery(.F.)oBrw:DrawLine()  ...

... downarrow key on the last row. The new row is saved only when some data is entered. 8 ) Visibility of other users' changes automatically. ( Resync() and Refresh() methods) #include "fivewin.ch"static oCnfunction Main()   local oRs   SET DATE BRITISH   SET CENTURY ON   FW_SetUnicode( ...

... and also autoincrementing ID. Still our client does not know what are the values written, We need to re-read the values written with either oRs:ReSync( 1, 2 ) or oRs:Requery() Unfortunately Resync() does not work perfectly with all databases. Works perfectly with MSSQL and Requery() is slow ...

ReQuery( [params] ), Refresh() and ReSync() ReQuery() Reads the entire rowset again from the Server using the original SQL and replaces the previous data with new data. This method works exactly like ADO's Requery. ReQuery( params ) In case ...

... procedure is not visible, the rowset object makesw its best efforts to identify the base table and prepares appropriately to Requery, Refresh and Resync. Option-5: oRs2 := oRs:Clone() This works similar to the ADO method Clone(). All the Clones work on the same data but can be sorted / filtered ...