Problem with TMSConnection.StartTransaction

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Dimonis
Posts: 2
Joined: Fri 21 Dec 2007 09:19

Problem with TMSConnection.StartTransaction

Post by Dimonis » Tue 19 Feb 2008 16:05

Delphi6 + SDAC4.30.0.13 + M$ SQL Server 2000
I have Table :
Create Table Tabl (
ID Bigint Identity(1,1) not null,
Kodtabl Smallint null,
Naimtabl Char(38) null
)
component TMSQuery
has properties, SQL:
Select ID, Kodtabl, Naimtabl From Tabl

UpdateSQL:
Upd_tbl

Connection:
Db

Db - this is component TMSConnection.
--

component TMSUpdateSQL with name Upd_tbl
has properties
DeleteSQL:
Delete from Tabl where ID=:Old_ID
InsertSQL:
Insert into Tabl (Kodtabl,Naimtabl) Values (:Kodtabl,:Naimtabl)
UpdateSQL:
Update Tabl set Kodtabl=:Kodtabl, Naimtabl=:Naimtabl where ID=:ID
RefreshSQL:
Select ID, Kodtabl, Naimtabl From Tabl where ID=:ID

program cod
Tabl.Delete;
runs without errors

program cod
db.StartTransaction;
Tabl.Delete;

creates error
Update failed. Found 0 records.

Question : How correct run transaction in SDAC ?

Challenger
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Fri 22 Feb 2008 07:32

We couldn't reproduce this error. Please send to SDAC support address complete sample that demonstrates this problem.

Post Reply