ADO BAtch Update
$20-25 USD
Paid on delivery
I trying to achieve a Batch Update on an Oracle Db with the following [url removed, login to view] 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= '" & [url removed, login to view] & "'" [url removed, login to view] = adUseClient [url removed, login to view] strsql, ObjDbCon, adOpenStatic, adLockBatchOptimistic, adCmdText '[url removed, login to view] = ObjDbRecsetT!AP_NUM MsgBox "FOUND" & [url removed, login to view] Do Until ([url removed, login to view]) [url removed, login to view] ObjDbRecsetT!AP_NUM STRAP = ObjDbRecsetT!AP_NUM [url removed, login to view] STRAP [url removed, login to view] "UPDATE T SET STATUS_CODE = '" & [url removed, login to view] & "', SHIPPER = '" & [url removed, login to view] & "', SHIPPED_DATE = '" & [url removed, login to view] & "', SOLD_DATE = '" & [url removed, login to view] & "' WHERE AP_NUM ='" & STRAP & "'" [url removed, login to view] [url removed, login to view] 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
Project ID: #2966360