RE: [firebird-support] info

2017-01-04 Thread Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support] 
I want to create a tablename in camelcase without using quotes. 

If I execute Create table MyTable(aField integer) then the tablename is saved 
as MYTABLE. And yes then you can use camelcase without quotes.

Can you find a solution ?

Nico Speleers
Analyst

Carfac bvba
Driving on experience

Rijksweg 53
9680 Maarkedal
Tel. +32 55 23 00 00
Fax +32 55 31 00 95
nico.spele...@carfac.com
www.carfac.be
 



-Oorspronkelijk bericht-
Van: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] 
Verzonden: woensdag 4 januari 2017 15:48
Aan: firebird-support@yahoogroups.com
Onderwerp: Re: [firebird-support] info

04.01.2017 15:41, Nico Speleers - Carfac BVBA nico.spele...@carfac.com 
[firebird-support]
wrote:
> We want to create table- and fieldnames (Firebird 3) in camelcase. If 
> we want to write a select statement we have to use quotes around a 
> tablename. This is not userfriendly. Is there a way that we don't have to use 
> the quotes in SQL-statements ?

   Just don't use double quotes:

Create table MyTable(aField integer);
Select aField from MyTable;

   No problem if you write queries by hand.
   On other hand, if you use a visual query builder, you'll have no problem 
with double quotes.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item on the main 
(top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

Re: [firebird-support] Insert SQL Deadlock Issue

2017-01-04 Thread Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] 
Got it from here:
http://api.256file.com/fbclient.dll/en-download-67763.html
 

On Thursday, 5 January 2017 9:40 AM, "Vishal Tiwari vishuals...@yahoo.co.in 
[firebird-support]"  wrote:
 

     @WBR: Are you saying, the fbclient.dll and (gds32.dll) are belonging to 
older version than the current firebird version?
If yes, then would you please tell, how shall I get them? by reinstalling 
FIrebird, or is there any link by which I could download them?
Thanks. 

On Thursday, 5 January 2017 9:09 AM, "Vishal Tiwari vishuals...@yahoo.co.in 
[firebird-support]"  wrote:
 

     Any other way? 

On Wednesday, 4 January 2017 6:11 PM, "Dimitry Sibiryakov 
s...@ibphoenix.com [firebird-support]"  wrote:
 

 04.01.2017 13:36, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] 
wrote:
> Error 3:
> *validation error for column VAT, value "*** null ***"*
> *                -sql_dialect        set database dialect n*
> *
> *

  First of all fix fbclient.dll(gds32.dll) - firebird.msg version mismatch.


-- 
  WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links





 

 #yiv5145219554 #yiv5145219554 -- #yiv5145219554ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5145219554 
#yiv5145219554ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5145219554 
#yiv5145219554ygrp-mkp #yiv5145219554hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv5145219554 #yiv5145219554ygrp-mkp #yiv5145219554ads 
{margin-bottom:10px;}#yiv5145219554 #yiv5145219554ygrp-mkp .yiv5145219554ad 
{padding:0 0;}#yiv5145219554 #yiv5145219554ygrp-mkp .yiv5145219554ad p 
{margin:0;}#yiv5145219554 #yiv5145219554ygrp-mkp .yiv5145219554ad a 
{color:#ff;text-decoration:none;}#yiv5145219554 #yiv5145219554ygrp-sponsor 
#yiv5145219554ygrp-lc {font-family:Arial;}#yiv5145219554 
#yiv5145219554ygrp-sponsor #yiv5145219554ygrp-lc #yiv5145219554hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5145219554 
#yiv5145219554ygrp-sponsor #yiv5145219554ygrp-lc .yiv5145219554ad 
{margin-bottom:10px;padding:0 0;}#yiv5145219554 #yiv5145219554actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5145219554 
#yiv5145219554activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5145219554
 #yiv5145219554activity span {font-weight:700;}#yiv5145219554 
#yiv5145219554activity span:first-child 
{text-transform:uppercase;}#yiv5145219554 #yiv5145219554activity span a 
{color:#5085b6;text-decoration:none;}#yiv5145219554 #yiv5145219554activity span 
span {color:#ff7900;}#yiv5145219554 #yiv5145219554activity span 
.yiv5145219554underline {text-decoration:underline;}#yiv5145219554 
.yiv5145219554attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv5145219554 .yiv5145219554attach div a 
{text-decoration:none;}#yiv5145219554 .yiv5145219554attach img 
{border:none;padding-right:5px;}#yiv5145219554 .yiv5145219554attach label 
{display:block;margin-bottom:5px;}#yiv5145219554 .yiv5145219554attach label a 
{text-decoration:none;}#yiv5145219554 blockquote {margin:0 0 0 
4px;}#yiv5145219554 .yiv5145219554bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5145219554 
.yiv5145219554bold a {text-decoration:none;}#yiv5145219554 dd.yiv5145219554last 
p a {font-family:Verdana;font-weight:700;}#yiv5145219554 dd.yiv5145219554last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5145219554 
dd.yiv5145219554last p span.yiv5145219554yshortcuts 
{margin-right:0;}#yiv5145219554 div.yiv5145219554attach-table div div a 
{text-decoration:none;}#yiv5145219554 div.yiv5145219554attach-table 
{width:400px;}#yiv5145219554 div.yiv5145219554file-title a, #yiv5145219554 
div.yiv5145219554file-title a:active, #yiv5145219554 
div.yiv5145219554file-title a:hover, #yiv5145219554 div.yiv5145219554file-title 
a:visited {text-decoration:none;}#yiv5145219554 div.yiv5145219554photo-title a, 
#yiv5145219554 div.yiv5145219554photo-title a:active, #yiv5145219554 
div.yiv5145219554photo-title a:hover, #yiv5145219554 
div.yiv5145219554photo-title a:visited {text-decoration:none;}#yiv5145219554 
div#yiv5145219554ygrp-mlmsg #yiv5145219554ygrp-msg p a 
span.yiv5145219554yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5145219554 
.yiv5145219554green {color:#628c2a;}#yiv5145219554 .yiv5145219554MsoNormal 
{margin:0 0 0 0;}#yiv5145219554 o {font-size:0;}#yiv5145219554 
#yiv5145219554photos div {float:left;width:72px;}#yiv5145219554

Re: [firebird-support] Insert SQL Deadlock Issue

2017-01-04 Thread Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] 
@WBR: Are you saying, the fbclient.dll and (gds32.dll) are belonging to older 
version than the current firebird version?
If yes, then would you please tell, how shall I get them? by reinstalling 
FIrebird, or is there any link by which I could download them?
Thanks. 

On Thursday, 5 January 2017 9:09 AM, "Vishal Tiwari vishuals...@yahoo.co.in 
[firebird-support]"  wrote:
 

     Any other way? 

On Wednesday, 4 January 2017 6:11 PM, "Dimitry Sibiryakov 
s...@ibphoenix.com [firebird-support]"  wrote:
 

 04.01.2017 13:36, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] 
wrote:
> Error 3:
> *validation error for column VAT, value "*** null ***"*
> *                -sql_dialect        set database dialect n*
> *
> *

  First of all fix fbclient.dll(gds32.dll) - firebird.msg version mismatch.


-- 
  WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links





 #yiv0403979453 #yiv0403979453 -- #yiv0403979453ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0403979453 
#yiv0403979453ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0403979453 
#yiv0403979453ygrp-mkp #yiv0403979453hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv0403979453 #yiv0403979453ygrp-mkp #yiv0403979453ads 
{margin-bottom:10px;}#yiv0403979453 #yiv0403979453ygrp-mkp .yiv0403979453ad 
{padding:0 0;}#yiv0403979453 #yiv0403979453ygrp-mkp .yiv0403979453ad p 
{margin:0;}#yiv0403979453 #yiv0403979453ygrp-mkp .yiv0403979453ad a 
{color:#ff;text-decoration:none;}#yiv0403979453 #yiv0403979453ygrp-sponsor 
#yiv0403979453ygrp-lc {font-family:Arial;}#yiv0403979453 
#yiv0403979453ygrp-sponsor #yiv0403979453ygrp-lc #yiv0403979453hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0403979453 
#yiv0403979453ygrp-sponsor #yiv0403979453ygrp-lc .yiv0403979453ad 
{margin-bottom:10px;padding:0 0;}#yiv0403979453 #yiv0403979453actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0403979453 
#yiv0403979453activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0403979453
 #yiv0403979453activity span {font-weight:700;}#yiv0403979453 
#yiv0403979453activity span:first-child 
{text-transform:uppercase;}#yiv0403979453 #yiv0403979453activity span a 
{color:#5085b6;text-decoration:none;}#yiv0403979453 #yiv0403979453activity span 
span {color:#ff7900;}#yiv0403979453 #yiv0403979453activity span 
.yiv0403979453underline {text-decoration:underline;}#yiv0403979453 
.yiv0403979453attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv0403979453 .yiv0403979453attach div a 
{text-decoration:none;}#yiv0403979453 .yiv0403979453attach img 
{border:none;padding-right:5px;}#yiv0403979453 .yiv0403979453attach label 
{display:block;margin-bottom:5px;}#yiv0403979453 .yiv0403979453attach label a 
{text-decoration:none;}#yiv0403979453 blockquote {margin:0 0 0 
4px;}#yiv0403979453 .yiv0403979453bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0403979453 
.yiv0403979453bold a {text-decoration:none;}#yiv0403979453 dd.yiv0403979453last 
p a {font-family:Verdana;font-weight:700;}#yiv0403979453 dd.yiv0403979453last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0403979453 
dd.yiv0403979453last p span.yiv0403979453yshortcuts 
{margin-right:0;}#yiv0403979453 div.yiv0403979453attach-table div div a 
{text-decoration:none;}#yiv0403979453 div.yiv0403979453attach-table 
{width:400px;}#yiv0403979453 div.yiv0403979453file-title a, #yiv0403979453 
div.yiv0403979453file-title a:active, #yiv0403979453 
div.yiv0403979453file-title a:hover, #yiv0403979453 div.yiv0403979453file-title 
a:visited {text-decoration:none;}#yiv0403979453 div.yiv0403979453photo-title a, 
#yiv0403979453 div.yiv0403979453photo-title a:active, #yiv0403979453 
div.yiv0403979453photo-title a:hover, #yiv0403979453 
div.yiv0403979453photo-title a:visited {text-decoration:none;}#yiv0403979453 
div#yiv0403979453ygrp-mlmsg #yiv0403979453ygrp-msg p a 
span.yiv0403979453yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0403979453 
.yiv0403979453green {color:#628c2a;}#yiv0403979453 .yiv0403979453MsoNormal 
{margin:0 0 0 0;}#yiv0403979453 o {font-size:0;}#yiv0403979453 
#yiv0403979453photos div {float:left;width:72px;}#yiv0403979453 
#yiv0403979453photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv0403979453 
#yiv0403979453photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:cen

Re: [firebird-support] Insert SQL Deadlock Issue

2017-01-04 Thread Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] 
Any other way? 

On Wednesday, 4 January 2017 6:11 PM, "Dimitry Sibiryakov 
s...@ibphoenix.com [firebird-support]"  wrote:
 

 04.01.2017 13:36, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] 
wrote:
> Error 3:
> *validation error for column VAT, value "*** null ***"*
> *                -sql_dialect        set database dialect n*
> *
> *

  First of all fix fbclient.dll(gds32.dll) - firebird.msg version mismatch.


-- 
  WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

[firebird-support] RE: info

2017-01-04 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] 


> We want to create table- and fieldnames (Firebird 3) in camelcase.

You can do that now, you can use whatever case you want.


> If we
> want to write a select statement we have to use quotes around a tablename.
> This is not userfriendly. Is there a way that we don't have to use the quotes
> in SQL-statements ?

By SQL standard Object names are case insensitive, so all objects are 
upper-cased.

There is an exception for objects created as "identifiers" which requires the 
use of double-quotes (another SQL standard) for all references to the Objects.


> We don't want to create our table- and fieldnames in lowercase or
> uppercase.

While the engine would return/display the object names in upper case, that does 
not stop you from using CamelCase in your SELECT statements, Triggers and SPs 
-- This is something that I do religiously, even after 20 years of using IB/FB.


Sean

Re: [firebird-support] info

2017-01-04 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support] 
Hello Nico,

If you want the case preserved, you have to use double quotes, always.


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.

We want to create table- and fieldnames (Firebird 3) in camelcase. If we 
want to write a select statement we have to use quotes around a tablename. 
This is not userfriendly. Is there a way that we don't have to use the 
quotes in SQL-statements ?
We don't want to create our table- and fieldnames in lowercase or uppercase.

Nico Speleers
Analyst





Carfac bvba

Driving on experience


Rijksweg 53
9680 Maarkedal
Tel. +32 55 23 00 00
Fax +32 55 31 00 95
nico.spele...@carfac.com
www.carfac.be
[cid:image001.jpg@01D11613.C23F19C0][cid:image002.jpg@01D11613.C23F19C0]
 
[cid:image003.jpg@01D11613.C23F19C0] 

[Beschrijving: Beschrijving: Beschrijving: CarfacAS 
(klein)]


)


[Non-text portions of this message have been removed]




Posted by: Nico Speleers - Carfac BVBA 


++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu 
there.

Also search the knowledgebases at 
http://www.ibphoenix.com/resources/documents/

++


Yahoo Groups Links

Re: [firebird-support] info

2017-01-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] 
04.01.2017 15:41, Nico Speleers - Carfac BVBA nico.spele...@carfac.com 
[firebird-support] 
wrote:
> We want to create table- and fieldnames (Firebird 3) in camelcase. If we want 
> to write a
> select statement we have to use quotes around a tablename. This is not 
> userfriendly. Is
> there a way that we don't have to use the quotes in SQL-statements ?

   Just don't use double quotes:

Create table MyTable(aField integer);
Select aField from MyTable;

   No problem if you write queries by hand.
   On other hand, if you use a visual query builder, you'll have no problem 
with double 
quotes.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] info

2017-01-04 Thread Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support] 
We want to create table- and fieldnames (Firebird 3) in camelcase. If we want 
to write a select statement we have to use quotes around a tablename. This is 
not userfriendly. Is there a way that we don't have to use the quotes in 
SQL-statements ?
We don't want to create our table- and fieldnames in lowercase or uppercase.

Nico Speleers
Analyst





Carfac bvba

Driving on experience


Rijksweg 53
9680 Maarkedal
Tel. +32 55 23 00 00
Fax +32 55 31 00 95
nico.spele...@carfac.com
www.carfac.be
[cid:image001.jpg@01D11613.C23F19C0][cid:image002.jpg@01D11613.C23F19C0]
 [cid:image003.jpg@01D11613.C23F19C0] 

[Beschrijving: Beschrijving: Beschrijving: CarfacAS 
(klein)]


)


[Non-text portions of this message have been removed]

Re: [firebird-support] Insert SQL Deadlock Issue

2017-01-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] 
04.01.2017 13:36, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] 
wrote:
> Error 3:
> *validation error for column VAT, value "*** null ***"*
> *-sql_dialect set database dialect n*
> *
> *

   First of all fix fbclient.dll(gds32.dll) - firebird.msg version mismatch.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Insert SQL Deadlock Issue

2017-01-04 Thread Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] 
Just checked in the code Transaction components are used. Sorry for mistake. 

On Wednesday, 4 January 2017 5:40 PM, "Vishal Tiwari 
vishuals...@yahoo.co.in [firebird-support]"  
wrote:
 

     Hi All,
 At production department, we are receiving below errors, not for all times, 
but frequently. We tried looking into code and found that there is a very 
simple insert statement which might cause that issue. Because functionality 
executes that Insert statement. 
Wondering how to resolve that issue, because as a developer we are not able to 
reproduce these error at least once.
We are using Delphi 6 and Firbird version is 2.5.2. I found that Transaction 
component in Delphi is not used while executing the SQL.
Error 1:There was an error processing this cancellation on mainserver.lock 
conflict on no wait transactiondeadlockupdate conflicts with concurrent 
updaterequires both input and output filenames 

Error 2:
There was an error RaiseFees.Unable to complete network request to host"".Error writing data to the connection.unknown Win32 error 10054
Error 3:
validation error for column VAT, value "*** null***"    
-sql_dialect set database dialect n

Please help in this regards, as it seems deadlock issue.
Trying hard to get the solution.

With Best Regards.
Vishal
  #yiv2723844364 #yiv2723844364 -- #yiv2723844364ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2723844364 
#yiv2723844364ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2723844364 
#yiv2723844364ygrp-mkp #yiv2723844364hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv2723844364 #yiv2723844364ygrp-mkp #yiv2723844364ads 
{margin-bottom:10px;}#yiv2723844364 #yiv2723844364ygrp-mkp .yiv2723844364ad 
{padding:0 0;}#yiv2723844364 #yiv2723844364ygrp-mkp .yiv2723844364ad p 
{margin:0;}#yiv2723844364 #yiv2723844364ygrp-mkp .yiv2723844364ad a 
{color:#ff;text-decoration:none;}#yiv2723844364 #yiv2723844364ygrp-sponsor 
#yiv2723844364ygrp-lc {font-family:Arial;}#yiv2723844364 
#yiv2723844364ygrp-sponsor #yiv2723844364ygrp-lc #yiv2723844364hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2723844364 
#yiv2723844364ygrp-sponsor #yiv2723844364ygrp-lc .yiv2723844364ad 
{margin-bottom:10px;padding:0 0;}#yiv2723844364 #yiv2723844364actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2723844364 
#yiv2723844364activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2723844364
 #yiv2723844364activity span {font-weight:700;}#yiv2723844364 
#yiv2723844364activity span:first-child 
{text-transform:uppercase;}#yiv2723844364 #yiv2723844364activity span a 
{color:#5085b6;text-decoration:none;}#yiv2723844364 #yiv2723844364activity span 
span {color:#ff7900;}#yiv2723844364 #yiv2723844364activity span 
.yiv2723844364underline {text-decoration:underline;}#yiv2723844364 
.yiv2723844364attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv2723844364 .yiv2723844364attach div a 
{text-decoration:none;}#yiv2723844364 .yiv2723844364attach img 
{border:none;padding-right:5px;}#yiv2723844364 .yiv2723844364attach label 
{display:block;margin-bottom:5px;}#yiv2723844364 .yiv2723844364attach label a 
{text-decoration:none;}#yiv2723844364 blockquote {margin:0 0 0 
4px;}#yiv2723844364 .yiv2723844364bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2723844364 
.yiv2723844364bold a {text-decoration:none;}#yiv2723844364 dd.yiv2723844364last 
p a {font-family:Verdana;font-weight:700;}#yiv2723844364 dd.yiv2723844364last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2723844364 
dd.yiv2723844364last p span.yiv2723844364yshortcuts 
{margin-right:0;}#yiv2723844364 div.yiv2723844364attach-table div div a 
{text-decoration:none;}#yiv2723844364 div.yiv2723844364attach-table 
{width:400px;}#yiv2723844364 div.yiv2723844364file-title a, #yiv2723844364 
div.yiv2723844364file-title a:active, #yiv2723844364 
div.yiv2723844364file-title a:hover, #yiv2723844364 div.yiv2723844364file-title 
a:visited {text-decoration:none;}#yiv2723844364 div.yiv2723844364photo-title a, 
#yiv2723844364 div.yiv2723844364photo-title a:active, #yiv2723844364 
div.yiv2723844364photo-title a:hover, #yiv2723844364 
div.yiv2723844364photo-title a:visited {text-decoration:none;}#yiv2723844364 
div#yiv2723844364ygrp-mlmsg #yiv2723844364ygrp-msg p a 
span.yiv2723844364yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2723844364 
.yiv2723844364green {color:#628c2a;}#yiv2723844364 .yiv2723844364MsoNormal 
{margin:0 0 0 0;}#yiv2723844364 o {font-size:0;}#yiv2723844364 
#yiv2723844364photos div {float:left;width:72px;}#yiv2723844364 
#yiv2723844364photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv2723844364 
#yiv2723844364photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#y

[firebird-support] Insert SQL Deadlock Issue

2017-01-04 Thread Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] 
Hi All,
 At production department, we are receiving below errors, not for all times, 
but frequently. We tried looking into code and found that there is a very 
simple insert statement which might cause that issue. Because functionality 
executes that Insert statement. 
Wondering how to resolve that issue, because as a developer we are not able to 
reproduce these error at least once.
We are using Delphi 6 and Firbird version is 2.5.2. I found that Transaction 
component in Delphi is not used while executing the SQL.
Error 1:There was an error processing this cancellation on mainserver.

lock conflict on no wait transaction

deadlock

update conflicts with concurrent update

requires both input and output filenames 

Error 2:
There was an error RaiseFees.

Unable to complete network request to host"".

Error writing data to the connection.

unknown Win32 error 10054


Error 3:
validation error for column VAT, value "*** null***"

    -sql_dialect set database dialect n



Please help in this regards, as it seems deadlock issue.
Trying hard to get the solution.

With Best Regards.
Vishal