Sql Server Transaction issue

[Capri]

vfp9sp2/sqlserver2k

When i pass

sqlexec(hn,"begin transacton") or sqlsetprop(hn,"transactions",2)

and insert data into table then

Im not able to select records from other connection if table is same.

pls help

Thanks

[Pavel Celba]

You should study and test different TRANSACTION ISOLATION LEVELs setting.

E.g. if you issue
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
from other connection
then you may read even uncommitted changes (which can be rolled back later,
of course).

Default behavior can block some resources after BEGIN TRAN is issued, so the
situation you are describing is possible. You should not leave the
transaction open for long time. More info is e.g. here:
http://msdn.microsoft.com/en-us/library/aa259216(SQL.80).aspx

P.C.

"Capri" <NoE...@NoDomain.com> wrote in message
news:32665440-F7C4-4523...@microsoft.com...