| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
