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 ?
Problem with TMSConnection.StartTransaction
-
- Devart Team
- Posts: 925
- Joined: Thu 17 Nov 2005 10:53