ADO Transaction problem

[martinm]

Hi all,

D6, XP Pro, Sybase ASE 12.xx

I have multiple TADOStoredProcs, all of which need to be executed within a
transaction, so have something along these lines:


FconConnection.BeginTrans;
try
sp1.execproc;
sp2.execproc;
sp3.execproc;
sp4.execproc;
FconConnection.CommitTrans;
except
FconConnection.RollbackTrans;
end;

However, the first execproc causes the following exception:

' Transaction cannot have multiple recordsets with this cursor type. Change
the cursor type, commit the transaction, or close one of the recordsets'

I've set the CursorTypes to ctStatic, but no change.
Works fine without the transaction control.

A bit confusing for a Tuesday.....

 

[LucieLastic]

Do you have cursors with the same names in the different procedures?

 

[martinm]

No - no cursors are used.