Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Program Hangs up when doing batch update

Status
Not open for further replies.
2969

2969

IS-IT--Management
Oct 18, 2001
107
US
Hi

I have this routine where I do recodrsed.update, I am using the following commands

rs.Open sSQL, conn,adOpenKeyset, adLockBatchOptimistic

After I add a new record to this recordset when I go for udpate using rs.updatebatch, the program hangs up. Most of the time the program works fine but it hangs up once every 5-7 times. What couold be the cause or how can i catch what's happening.
 
Status
Not open for further replies.

Similar threads

Andrzejek
  • Question
Update SQL's varbinary(max) field from VB6
Replies
4
Views
264
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
UPDATE DAO RECORDSET 1
Replies
11
Views
735
strongm
strongm
BigTG
  • Locked
  • Question
Converting an old XP VB6 program to run on Windows 7 & Windows 10
Replies
5
Views
650
vb5prgrmr
vb5prgrmr
Ken01
  • Locked
  • Question
I have a program, developed in VB6
Replies
6
Views
897
Ken01
Ken01
BigTG
  • Locked
  • Question
Legacy VB6 program
Replies
4
Views
657
xwb
xwb

Part and Inventory Search

Sponsor

Back
Top