i’m using VB6 and SQL Server 7.0
i realised that i can’t do a sql query SELECT statement after i’ve issued either UPDATE or DELETE or INSERT to the database.
the connection will hang when it reaches the SELECT query.
this only happened if my connection has a BeginTrans but haven’t reach until CommitTrans.
is this a meant to be feature or it’s a bug?
if it’s a feature, pls teach me how to overcome it.
