as title. and if deadlock is happened. Then how to solve?

First, note that 'C++' is a programming language. Programming languages do
not access a database -- applications do. Nevertheless, the language in
which an application is written is compeltely irrelevant for this matter.

So, when an application issues a query that gets aborted by the ASE server
because the query runs into a deadlock, then the application can do two
things: (i) present an error to the user (ii) re-submit the same transaction
again and hope it works out OK this time (you may want to put a maximum to
the number of re-submits). As an application programmer, it's your choice
which of the two you take.
You may want to check out http://www.sybase.com/detail?id=1001342 for some
more background.

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase Replication Server Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"

mailto:rob (AT) YOUR (DOT) SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

<Matthew> wrote