ADO BAtch Update

Completed Posted Aug 22, 2003 Paid on delivery
Completed 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

Engineering MySQL Oracle PHP Software Architecture Software Testing Visual Basic

Project ID: #2966360

About the project

18 proposals Remote project Active Aug 25, 2003

Awarded to:

vw884283vw

See private message.

$3 USD in 3 days
(7 Reviews)
2.7

18 freelancers are bidding on average $12 for this job

derektpvw

See private message.

$8.5 USD in 3 days
(108 Reviews)
6.5
brookssolutions

See private message.

$12.75 USD in 3 days
(25 Reviews)
6.1
tobsvw

See private message.

$17 USD in 3 days
(67 Reviews)
6.0
pursca

See private message.

$8.5 USD in 3 days
(30 Reviews)
5.2
vbcodepro

See private message.

$8.5 USD in 3 days
(52 Reviews)
5.0
johngalanopoulos

See private message.

$8.5 USD in 3 days
(15 Reviews)
3.4
mrityunjayvw

See private message.

$21.25 USD in 3 days
(5 Reviews)
2.6
williamwhitevw

See private message.

$8.5 USD in 3 days
(6 Reviews)
2.1
wrady

See private message.

$8.5 USD in 3 days
(5 Reviews)
1.9
vw935550vw

See private message.

$12.75 USD in 3 days
(3 Reviews)
1.1
devagnanam

See private message.

$15.3 USD in 3 days
(0 Reviews)
0.0
joeldcruzvw

See private message.

$12.75 USD in 3 days
(0 Reviews)
0.0
nigadesg

See private message.

$17 USD in 3 days
(0 Reviews)
0.0
faragoa

See private message.

$21.25 USD in 3 days
(0 Reviews)
0.0
rapidfire09

See private message.

$11.05 USD in 3 days
(0 Reviews)
0.0
wbunker

See private message.

$8.5 USD in 3 days
(0 Reviews)
0.0
vw932402vw

See private message.

$10.2 USD in 3 days
(0 Reviews)
0.0