1. °³¹ß/½ÇÇà Ç÷§Æû
(1) OS : Win10
(2) °³¹ßÅø : µ¨ÆÄÀÌ7
(3) »ç¿ë Database : MSSQL
2. °³¹ß ÁßÀÎ ÇÁ·Î±×·¥
3. Áú¹® ³»¿ë
µÑÁß¿¡ ¾î¶²°Ô Á¤´äÀÎÁö ¸ð¸£°Ú¾î¿ä..Á¦°¡ ±âº»ÀÌ ¾ÈµÇ¾î Àִ°ǰ¡¿ä?TT
try¿Í transactionÀ§Ä¡°¡ ¾î¶²°Ô ¸Â´ÂÁö ¸ð¸£°Ú¾î¿ä..
󸮽ô ÀÌ»ó¾øÀÌ µÇ´Âµ¥, Á¤È®È÷ ¾Ë°í ½Í¾î¼ ±Û ¿Ã¸³´Ï´Ù.
°³¹ßÇϽô ºÐµé °í»ýÀÌ ¸¹À¸¼¼¿ä..
(1) ÀúÀå
try
if not dm_1.DB.InTransaction then dm_1.DB.StartTransaction;
with qryTemp do begin
.................
execsql;
end;
dm_1.DB.Commit;
except
dm_1.DB.Rollback;
...........
¿¡·¯ ¸Þ½ÃÁö
exit;
end;
(2) ÀúÀå
if not dm_1.DB.InTransaction then dm_1.DB.StartTransaction;
try
with qryTemp do begin
.................
execsql;
end;
except
dm_1.DB.Rollback;
...........
¿¡·¯ ¸Þ½ÃÁö
exit;
end;
dm_1.DB.Commit;