Re: ADO\SQLServer\Transactions

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 06/06/04

  • Next message: mem1: "Import Activex problem???" 
    Date: Sat, 05 Jun 2004 20:40:47 -0500

    >I use the ADODatasets in the application to select, insert, update and
    >delete records. Is the correct place to setup the
    >ADOConnect.BeginTrans, ADOConnect.CommitTrans and ADOConnect.rollback in
    >the onclick event of the save button.

    It might be. Depends on what you are trying to do. The code you posted does
    nothing since you begin then commit the transaction before any before any code
    runs that would create a change that needs committing.
    Also your code has a problem in that the crSQLWait cursor will be the active
    cursor when an error has occurred. 

    --
Brian Bushay (TeamB)
Bbushay@NMPLS.com
  • Next message: mem1: "Import Activex problem???"