Back

VB042

BeginTrans without commit or rollback

Visual Basic 6
Warning
VB6

A transaction never committed or rolled back in its procedure keeps its locks until the connection dies

a transaction never committed or rolled back in its procedure keeps its locks until the connection dies.

Why this severity

a transaction never committed or rolled back in its procedure keeps its locks until the connection dies.


Known false positives

transactions deliberately completed by the caller — a contract worth a comment.

Remediation example

conn.BeginTrans
conn.Execute sql
conn.CommitTrans

Reconnecting… Connection lost. Reload