Thank You. Let me check. 

    On Friday, 13 January 2017 1:13 PM, "liviuslivius 
liviusliv...@poczta.onet.pl [firebird-support]" 
<firebird-support@yahoogroups.com> 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] <firebird-support@yahoogroups.com> 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]" <firebird-support@yahoogroups.com> 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:#0000ff;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;}#yiv2519871971 .yiv2519871971MsoNormal 
{margin:0 0 0 0;}#yiv2519871971 o {font-size:0;}#yiv2519871971 
#yiv2519871971photos div {float:left;width:72px;}#yiv2519871971 
#yiv2519871971photos div div {border:1px solid 
#666666;height:62px;overflow:hidden;width:62px;}#yiv2519871971 
#yiv2519871971photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2519871971
 #yiv2519871971reco-category {font-size:77%;}#yiv2519871971 
#yiv2519871971reco-desc {font-size:77%;}#yiv2519871971 .yiv2519871971replbq 
{margin:4px;}#yiv2519871971 #yiv2519871971ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv2519871971 #yiv2519871971ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2519871971 
#yiv2519871971ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2519871971 
#yiv2519871971ygrp-mlmsg select, #yiv2519871971 input, #yiv2519871971 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2519871971 
#yiv2519871971ygrp-mlmsg pre, #yiv2519871971 code {font:115% 
monospace;}#yiv2519871971 #yiv2519871971ygrp-mlmsg * 
{line-height:1.22em;}#yiv2519871971 #yiv2519871971ygrp-mlmsg #yiv2519871971logo 
{padding-bottom:10px;}#yiv2519871971 #yiv2519871971ygrp-msg p a 
{font-family:Verdana;}#yiv2519871971 #yiv2519871971ygrp-msg 
p#yiv2519871971attach-count span {color:#1E66AE;font-weight:700;}#yiv2519871971 
#yiv2519871971ygrp-reco #yiv2519871971reco-head 
{color:#ff7900;font-weight:700;}#yiv2519871971 #yiv2519871971ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv2519871971 #yiv2519871971ygrp-sponsor 
#yiv2519871971ov li a {font-size:130%;text-decoration:none;}#yiv2519871971 
#yiv2519871971ygrp-sponsor #yiv2519871971ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2519871971 
#yiv2519871971ygrp-sponsor #yiv2519871971ov ul {margin:0;padding:0 0 0 
8px;}#yiv2519871971 #yiv2519871971ygrp-text 
{font-family:Georgia;}#yiv2519871971 #yiv2519871971ygrp-text p {margin:0 0 1em 
0;}#yiv2519871971 #yiv2519871971ygrp-text tt {font-size:120%;}#yiv2519871971 
#yiv2519871971ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv2519871971 

   
  • [firebird-supp... Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
    • RE: [fire... Maya Opperman m...@omniaccounts.co.za [firebird-support]
      • Re: [... Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
    • Re: Re: [... liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
      • Re: R... Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]

Reply via email to