Hi,what can i use Transaction by DBexpress of Sybase.

[nzfboy]

Hi,what can i use Transaction by DBexpress of Sybase.

any time ,i cant 't rollback .

i use 1.24

[VISOCO Support]

Hello.

There is a problem with rollback with cloned connections. It's a problem of Borland dbExpress components. If you have more than one active command SQLConnection opens additional connections internally. You cannot control transactions for this cloned connections. So, this transactions will be autocommited.
See also this topic

You must use ClientDataset's. It reads all records till the end than closes a command. In this case no additional connections will be created.

[nzfboy]

i can't understant it all.

in my project .only 1 connection,1 Provied,1 ClientDataset.

all of my change suport with ClientDataset.

but ,anytime i can't run TransLaction .

in my this job,i must use it .

=======================
in my this Project :
1.i must Write a IC Card by Com1.
2.i wite some data to database.
3.if Write Card Error.i wont rollback it .

what can i do it ???
i must write to Database first To get error in writing IC Card.

[VISOCO Support]

Can you send us a little sample ? (in most common form, without details)

[nzfboy]

thanks, may you tell me how to compelete it ?

[nzfboy]

give me your E-MAIL Please. visoco@visoco.com is Error Mail.

[VISOCO Support]

[nzfboy]

did you recedive My sample?can you send me your modifiy film

my E-mail: nzfboy@21cn.com

[VISOCO Support]

We are still working on it. We met with some unexpected troubles with ClientDataSet

[VISOCO Support]

ClientDataset starts a transaction on one connection then uses another (cloned) connection to apply changes. You need to set SQLConnection.KeepConnection to False to prevent this behaviour. It may cause a performance disadvantage so you can use different SQLConnections for changes' applying and data receiving. We know, it's no a very wise solution, but another way is to apply changes manually (not by ClientDataset).

[anandarya]

Tansations work in sync with the database.But in BD Express is it reliable on complex transaction effecting around 20 tables..How can we deal with this complexity if something goes bad.. .Please help with some example with code .... Database Env-Sybase ASC12.5 ..