Thank You. Let me check.
On Friday, 13 January 2017 1:13 PM, "liviuslivius
liviusliv...@poczta.onet.pl [firebird-support]"
wrote:
Hi, dbClick on IBTransaction component and you got Transaction editor -
and there you have all valuesgoogle for each value regards,Karol Bieniaszewski
W dniu 2017-01-13 07:08:19 użytkownik Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support] napisał:
I am using TIBSQL, TIBDatabase and TIBTransaction components. This code is not
fitting there. Would you please provide me Firebird Tools Group mail ID?
On Friday, 13 January 2017 11:15 AM, "Maya Opperman m...@omniaccounts.co.za
[firebird-support]" wrote:
Hi Vishal, >I need to understand how to set Wait/No Wait Transaction in
firebird. I think you mean in Delphi? Might be better to ask on the Firebird
tools group, but I have replied below >Also I have one doubt that I when we
start transaction through code as shown below, the transaction locks particular
rows in the table or it locks entire table?I think you will be fine as long as
you use generator to get your ID’s if you use auto-incremented numeric primary
keys. Delphi code snippet for FIBPlus would be: sqlMain.Transaction.TPBMode
:= tpbDefault;sqlMain.Transaction.TRParams.Clear;
sqlMain.Transaction.TRParams.Add('read_committed');sqlMain.Transaction.TRParams.Add('rec_version');
sqlMain.Transaction.TRParams.Params.Add('nowait'); //try
sqlMain.Transaction.StartTransaction; try //Have Insert SQL Execution here
sqlMain.Transaction.Commit; except on E: Exception do begin
sqlMain.Transaction.Rollback; raise; end;end; FireDac would be quite
similar. CheersMaya
#yiv2519871971 #yiv2519871971 -- #yiv2519871971ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2519871971
#yiv2519871971ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2519871971
#yiv2519871971ygrp-mkp #yiv2519871971hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2519871971 #yiv2519871971ygrp-mkp #yiv2519871971ads
{margin-bottom:10px;}#yiv2519871971 #yiv2519871971ygrp-mkp .yiv2519871971ad
{padding:0 0;}#yiv2519871971 #yiv2519871971ygrp-mkp .yiv2519871971ad p
{margin:0;}#yiv2519871971 #yiv2519871971ygrp-mkp .yiv2519871971ad a
{color:#ff;text-decoration:none;}#yiv2519871971 #yiv2519871971ygrp-sponsor
#yiv2519871971ygrp-lc {font-family:Arial;}#yiv2519871971
#yiv2519871971ygrp-sponsor #yiv2519871971ygrp-lc #yiv2519871971hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2519871971
#yiv2519871971ygrp-sponsor #yiv2519871971ygrp-lc .yiv2519871971ad
{margin-bottom:10px;padding:0 0;}#yiv2519871971 #yiv2519871971actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2519871971
#yiv2519871971activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2519871971
#yiv2519871971activity span {font-weight:700;}#yiv2519871971
#yiv2519871971activity span:first-child
{text-transform:uppercase;}#yiv2519871971 #yiv2519871971activity span a
{color:#5085b6;text-decoration:none;}#yiv2519871971 #yiv2519871971activity span
span {color:#ff7900;}#yiv2519871971 #yiv2519871971activity span
.yiv2519871971underline {text-decoration:underline;}#yiv2519871971
.yiv2519871971attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2519871971 .yiv2519871971attach div a
{text-decoration:none;}#yiv2519871971 .yiv2519871971attach img
{border:none;padding-right:5px;}#yiv2519871971 .yiv2519871971attach label
{display:block;margin-bottom:5px;}#yiv2519871971 .yiv2519871971attach label a
{text-decoration:none;}#yiv2519871971 blockquote {margin:0 0 0
4px;}#yiv2519871971 .yiv2519871971bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2519871971
.yiv2519871971bold a {text-decoration:none;}#yiv2519871971 dd.yiv2519871971last
p a {font-family:Verdana;font-weight:700;}#yiv2519871971 dd.yiv2519871971last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2519871971
dd.yiv2519871971last p span.yiv2519871971yshortcuts
{margin-right:0;}#yiv2519871971 div.yiv2519871971attach-table div div a
{text-decoration:none;}#yiv2519871971 div.yiv2519871971attach-table
{width:400px;}#yiv2519871971 div.yiv2519871971file-title a, #yiv2519871971
div.yiv2519871971file-title a:active, #yiv2519871971
div.yiv2519871971file-title a:hover, #yiv2519871971 div.yiv2519871971file-title
a:visited {text-decoration:none;}#yiv2519871971 div.yiv2519871971photo-title a,
#yiv2519871971 div.yiv2519871971photo-title a:active, #yiv2519871971
div.yiv2519871971photo-title a:hover, #yiv2519871971
div.yiv2519871971photo-title a:visited {text-decoration:none;}#yiv2519871971
div#yiv2519871971ygrp-mlmsg #yiv2519871971ygrp-msg p a
span.yiv2519871971yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2519871971
.yiv2519871971green {color:#628c2a;}#yiv25