Debugging in VB when error only occurs in compiled program
Posted on 2003-03-04
I need some help with debugging a VB6 app. How would be the best way to go about debugging when the error only occurs on certain computers (not the computer complied on). Can not be duplicated inside of VB, i.e. only occurs in the program when its compiled.
Please help me! I will reward everyone who helps with points! The code follows were the error is occuring.
Dim found As Boolean
Dim rsTemp As New ADODB.RecordSet
rsTemp.Open "Select * from [PartsInv] where [InventoryNum]=" & Str$(rec.inventorynum), m_Connection, adOpenDynamic, adLockOptimistic
found = Not rsTemp.EOF
If found Then
SaveRec rsTemp, rec
'error occurs here "rsTemp.Update"
Dim initialPosition, x2 As Integer
initialPosition = m_Recordset.AbsolutePosition
m_Recordset.Move initialPosition - 1
x2 = m_Recordset.AbsolutePosition
MsgBox ("Error Attempting to Update Non-Existant Part")