Em Andamento

ADO BAtch Update

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

Habilidades: Engenharia, MySQL, Oracle, PHP, Arquitetura de software, Teste de Software, Visual Basic

Ver mais: marty, eof, batch, ado, recordset, php print error, code batch, php window print, select oracle, php loops, php print window, vb text update, debug update, batch print, additem php, visual basic oracle, visual basic batch, basic update php, ado php, batch visual basic, execute php update, 2003 oracle, Shipper

Acerca do Empregador:
( 1 comentário ) United States

ID do Projeto: #2966360

Premiar a:

vw884283vw

See private message.

$3 USD em 3 dias
(7 Avaliações)
2.7

18 freelancers estão ofertando em média $12 para este trabalho

derektpvw

See private message.

$8.5 USD in 3 dias
(108 Comentários)
6.5
brookssolutions

See private message.

$12.75 USD in 3 dias
(25 Comentários)
6.1
tobsvw

See private message.

$17 USD in 3 dias
(67 Comentários)
6.0
pursca

See private message.

$8.5 USD in 3 dias
(30 Comentários)
5.2
vbcodepro

See private message.

$8.5 USD in 3 dias
(52 Comentários)
5.0
johngalanopoulos

See private message.

$8.5 USD in 3 dias
(15 Comentários)
3.4
mrityunjayvw

See private message.

$21.25 USD in 3 dias
(5 Comentários)
2.6
williamwhitevw

See private message.

$8.5 USD in 3 dias
(6 Comentários)
2.1
wrady

See private message.

$8.5 USD in 3 dias
(5 Comentários)
1.9
vw935550vw

See private message.

$12.75 USD in 3 dias
(3 Comentários)
1.1
faragoa

See private message.

$21.25 USD in 3 dias
(0 Comentários)
0.0
rapidfire09

See private message.

$11.05 USD in 3 dias
(0 Comentários)
0.0
wbunker

See private message.

$8.5 USD in 3 dias
(0 Comentários)
0.0
nigadesg

See private message.

$17 USD in 3 dias
(0 Comentários)
0.0
joeldcruzvw

See private message.

$12.75 USD in 3 dias
(0 Comentários)
0.0
vw932402vw

See private message.

$10.2 USD in 3 dias
(0 Comentários)
0.0
devagnanam

See private message.

$15.3 USD in 3 dias
(0 Comentários)
0.0