please ignore first message.
my code is like follows.

begin transaction

---some updates

begin transaction

--more updates

sqlcommit(1)

end transaction

end transaction.

my problem is when i issued sqlcommit in second transaciont level , it commits first transaction's updates also to back-end.

anyone guide me where i am wrong??

thanks for help.

mark