I trying to achieve a Batch Update on an Oracle Db with the following [login to view URL] loops through the recordset fine. The only way I can see the error is in the watch window. The error is "Either BOF or EOF is True" any pointers? Marty strsql = "select * from T WHERE INVEST_COMM_NUM= '" & [login to view URL] & "'" [login to view URL] = adUseClient [login to view URL] strsql, ObjDbCon, adOpenStatic, adLockBatchOptimistic, adCmdText '[login to view URL] = ObjDbRecsetT!AP_NUM MsgBox "FOUND" & [login to view URL] Do Until ([login to view URL]) [login to view URL] ObjDbRecsetT!AP_NUM STRAP = ObjDbRecsetT!AP_NUM [login to view URL] STRAP [login to view URL] "UPDATE T SET STATUS_CODE = '" & [login to view URL] & "', SHIPPER = '" & [login to view URL] & "', SHIPPED_DATE = '" & [login to view URL] & "', SOLD_DATE = '" & [login to view URL] & "' WHERE AP_NUM ='" & STRAP & "'" [login to view URL] [login to view URL] Loop
## Deliverables
1) Understanding on where I'm going wrong for the Update
## Platform
Winnt 4.0 Oracle 8 ADO 2.5 VB 6.0