Home » Server Options » Replication » Access Violation SnapshotGroup Refresh
Access Violation SnapshotGroup Refresh [message #366552] Thu, 16 November 2000 14:10
Jim C. Burns
Messages: 1
Registered: November 2000
Junior Member
I am using VB6 with a for...next loop to refresh data. On a fast Win2k machine it generates a Windows access violation unless I put in a one second pause between iterations. Anybody have an idea how to add something other than a pause to make it wait & not step on itself.
Code below:

For Each varTable In mMasterTable
Call mObjReplication.SnapshotGroupReset
Call mObjReplication.SnapshotGroupAdd(mStrLocalDBUser, varTable, kRepOptimumRefresh)
If False = mObjReplication.SnapshotGroupRefresh(kRepContinueOnError) Then
'Show error: Could not refresh snapshot for master data
'This will show if there is an error and kRepStopOnError is used above instead of kRepContinueOnError
Call ShowOracleError(512)
Exit Function
End If
' '******************************************
' 'Added to prevent Win2K Access Exception error on fast computer
' PauseTime = 1
' Start = Timer
' Do While Timer < Start + PauseTime
' DoEvents
' Loop
' '******************************************
Next varTable
Previous Topic: database replication between Oracle 8.0.4 and 8.1.5
Next Topic: Multi Master issue in Oracle 8i for Linux
Goto Forum:
  


Current Time: Thu Mar 28 04:55:09 CDT 2024