FiveTech Software tech support forums

... 12 IRowsetFind VERDADERO 13 IRowsetIdentity VERDADERO 14 IRowsetInfo VERDADERO 15 IRowsetLocate VERDADERO 16 IRowsetRefresh VERDADERO 17 IRowsetResynch FALSO 18 IRowsetScroll VERDADERO 19 IRowsetUpdate VERDADERO 20 IRowsetView VERDADERO 21 IRowsetIndex FALSO 22 ISequentialStream VERDADERO 23 ...

... the error in TRY/CATCH block and dealwith it. 2. If the recordset is opened in Batch Optimistic mode and if the provider is OLEDB In most cases ReSync() works First call oRs:ReSync( adAffectCurrent, adResyncUnderlyingValues ) // ( 1, 1 ) RecordSet reads current values into underlyingvalues Each ...

... [defaultvalue] USERDEFINED, [defaultvalue] int ) STDCALL dispatch FUNC void Requery( [defaultvalue] int ) STDCALL dispatch FUNC void _xResync( [defaultvalue] USERDEFINED ) STDCALL dispatch FUNC void Update( [optional] VARIANT, [optional] VARIANT ) STDCALL dispatch PROPERTYGET USERDEFINED ...

... cFld ) ),  aData[ nAt, nCol ] } )  That will do it. If you have other files with a relationship then you would need to resync() just the affected workarea. For example, lets say you have an invoices table that relates to the customer number on the array, then you need ...

... caso yo lo ejecuto 4 veces al día. rem el archivo es tiempo.bat net time /setsntp:"0.pool.ntp.org 1.pool.ntp.org 2.pool.ntp.org" w32tm /resync /rediscover tienes que agregar una tarea al XP en CMD at 11:00 /every:D,L,M,Mi,J,V,S D:\miruta\tiempo.BAT at 13:00 /every:D,L,M,Mi,J,V,S D:\miruta\tiempo.BAT ...

... .. which detects if that row was possibly deleted by another user or the data had changed All this work is because Access does not respect the ReSync() method .. Just thought I would share this code .. I think these ideas can help other ADO users deal with their concurrency and workstation ...

Lafug and Rao Rao .. you are VERY correct about ReSync() not being universally supported by some Databases .. like Access for example which causes difficulties in networked environments specifically when it comes to workstation updates and visibility. ...

... error. It is desirable that we should ascertain that the row is not updated by other users before calling oRs:Update() method. Normally oRs:Resync( adAffectCurrent, adResyncUnderlyingValues ) method helps us to know this. But unfortunately not all providers support this method. I very much ...

... 2 WHERE FIRST = "Ali"'   oCn:Execute( cSql )   oRs:Close()   oCn:Close()return nil There is also another method ReSync(). This method is much faster and has many options. But please use this with extreme caution. Not all providers support this method and even ...

There is no Refresh method for RecordSet in ADO. There are only ReSync() and ReQuery() methods. You can change the source of a RecordSet ( oRs:Souce := <cNewSource> ) and do oRs:ReQuery(), but not Refresh(). This can work: oBrw:oRs:Source := <cNewSQL ...

... hours 0 mins 4 secs Error occurred at: 12/31/09, 12:00:27 Error description: Error ADODB.Recordset/16389 E_FAIL: PROPERTIES Args: [ 1] = C Update Resync Stack Calls =========== Called from: win32ole.prg => TOLEAUTO:PROPERTIES(0) Called from: xSqlQuery.prg => (b)XSQLQUERY:XSQLQUERY(74) Called ...

... hours 0 mins 4 secs Error occurred at: 12/31/09, 12:00:27 Error description: Error ADODB.Recordset/16389 E_FAIL: PROPERTIES Args: [ 1] = C Update Resync Stack Calls =========== Called from: win32ole.prg => TOLEAUTO:PROPERTIES(0) Called from: xSqlQuery.prg => (b)XSQLQUERY:XSQLQUERY(74) Called ...

... comparisons. Every field has OriginalValue, UnderlyingValue and Value. Comparing Value with OriginalValue tells us if our user has modified data. Resync method to update only underlyingvalues reads the current data into this value. Comparing Value with UnderlyingValues tells is if other user modified ...

Manuel Here is an example of using resync() .. Lets say you have two workstations accesing the same table using the same SQL code .. so basically both workstations have identical copies of their local recordset. Workstation 1 changes row 2 ...

oRs:Requery() is a useful tool as well as oRs:ReSync(1,2) .. do not leave the resync parameters out .. and you MUST have a 'primary key' set on your table for the Resync method to work. ReSync is a must in a networked environment especially for ...