dbTalk Databases Forums  

Need clarification on use of Transaction statements

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss Need clarification on use of Transaction statements in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Shobha
 
Posts: n/a

Default Need clarification on use of Transaction statements - 10-22-2009 , 01:25 AM






Hi


I am using .Net CF 2.0 and ASA10 db for pocket PC application

In my application i have not used any transaction statements(like
beginTransaction , commit and Rollback etc.. methods)

I directly executed all ADO.Net statements(CRUD operations) against the DB like



Dim cmd As Data.Common.DbCommand = New
iAnywhere.Data.SQLAnywhere.SACommand

cmd.Connection = mConnection

cmd.CommandType = Data.CommandType.Text

cmd.CommandText = "update Employee set first_name ='FIRST'"

cmd.ExecuteNonQuery()



1. If this is the case, does the executed CRUD operations against the
database will commit for each statement (or) not? (As there is a chances of
restart of the Pocket PC .)

---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp

Reply With Quote
  #2  
Old   
Chris Keating (Sybase iAnywhere)
 
Posts: n/a

Default Re: Need clarification on use of Transaction statements - 10-22-2009 , 06:03 AM






If you are not using SATransaction, your connection will be running in
autocommit mode.

Shobha wrote:
Quote:
Hi


I am using .Net CF 2.0 and ASA10 db for pocket PC application

In my application i have not used any transaction statements(like
beginTransaction , commit and Rollback etc.. methods)

I directly executed all ADO.Net statements(CRUD operations) against the DB like



Dim cmd As Data.Common.DbCommand = New
iAnywhere.Data.SQLAnywhere.SACommand

cmd.Connection = mConnection

cmd.CommandType = Data.CommandType.Text

cmd.CommandText = "update Employee set first_name ='FIRST'"

cmd.ExecuteNonQuery()



1. If this is the case, does the executed CRUD operations against the
database will commit for each statement (or) not? (As there is a chances of
restart of the Pocket PC .)

---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.