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

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

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

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,

[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 >

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

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

[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

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

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,

[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