Devart Forums

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 ?

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