Re: [Firebird-net-provider] How to detect transaction failure due to a conflict?

2008-01-11 Thread Jiri Cincura
On 1/11/08, Martin Fay <[EMAIL PROTECTED]> wrote: > Can anyone suggest what logical test I should use on this? Checking error code is the best way. You can also distinguish what exactly happend. > Also are the error codes defined anywhere in the .net provider source? Error codes and messages for

[Firebird-net-provider] How to detect transaction failure due to a conflict?

2008-01-11 Thread Martin Fay
I'm currently trying to write a transaction handler which will retry the transaction if there has been a conflict with another transaction... however... I'm failing to find any solid documentation on how to detect this state. The FbException I get when an update conflict occurs contains: FbExcepti

[Firebird-net-provider] FbConnection.GetSchema() bool values not consistent

2008-01-11 Thread VS-Polis
Hi Jiri, in addition to the GetSchema methods, I started to write a documentation like http://msdn2.microsoft.com/en-us/library/ms254969(VS.80).aspx. I found out that some bool values are returned as bool, others as short, others as integer. Is it useful to change the related fields in the ret

Re: [Firebird-net-provider] Bug in FbConnection.GetSchema("Columns")

2008-01-11 Thread Jiri Cincura
On 1/11/08, VS-Polis <[EMAIL PROTECTED]> wrote: > If you have more important things to do, you can wait until I set a > corrected version of the SELECT command in Schema\FbColumns.cs into > DNET-151. No problem, it's just a simple case statement. I hope DNET-151 and 152 will be resolved during we

Re: [Firebird-net-provider] Bug in FbConnection.GetSchema("Columns")

2008-01-11 Thread Jiri Cincura
On 1/11/08, Helen Borrie <[EMAIL PROTECTED]> wrote: > >OK, now I see. I missed, that the column will be evaluated only for > >column definition without domain. > > Incorrect. All column definitions have a domain, including those that are > defined independently of a user-defined domain. All of t

Re: [Firebird-net-provider] Bug in FbConnection.GetSchema("Columns")

2008-01-11 Thread Helen Borrie
>On 1/11/08, André Knappstein, Controlling <[EMAIL PROTECTED]> wrote: >> Once you remove the "NOT NULL" from the domain, this column would >> still remain "not nullable". You cannot remove the NOT NULL constraint. At 09:33 PM 11/01/2008, Jiri wrote: >OK, now I see. I missed, that the column wi

[Firebird-net-provider] Bug in FbConnection.GetSchema("Columns")

2008-01-11 Thread VS-Polis
Hi, Jiri Cincura wrote: > "is_nullable" means, that column accepts NULL values. So it should be > (keep eyes on me Helen :)): > 1. domain has "NOT NULL" clause (no matter what's on column > definition) > is_nullable = false > 2. column has "NOT NULL" clause > is_nullable = false > 3. Othervise is_

Re: [Firebird-net-provider] Bug in FbConnection.GetSchema("Columns")

2008-01-11 Thread Jiri Cincura
On 1/11/08, André Knappstein, Controlling <[EMAIL PROTECTED]> wrote: > Once you remove the "NOT NULL" from the domain, this column would > still remain "not nullable". OK, now I see. I missed, that the column will be evaluated only for column definition without domain. PS: I haven't looked to the

Re: [Firebird-net-provider] Misprint in FbDataReader.cs of latest build

2008-01-11 Thread Jiri Cincura
On 1/11/08, paha <[EMAIL PROTECTED]> wrote: > > Hi Jiri, > > i found one little mistake in GetSchemaCommandText() function of > FbDataReader (i downloaded source and binary just few minutes ago) > so, we have following sql statement Sorry man, damn typo (during formating, rewriting to inner joins

Re: [Firebird-net-provider] Bug in FbConnection.GetSchema("Columns")

2008-01-11 Thread André Knappstein , Controlling
Hello Jiri, >> Maybe what you want and need is a (new?) property "NOT_NULL_SET" which >> could result to false for the column while "is_nullable" still _CAN_ >> return false because of the underlying domain. JC> Isn't this just negation of is_nullable? BTW in schema table are some JC> well-known

[Firebird-net-provider] Misprint in FbDataReader.cs of latest build

2008-01-11 Thread paha
Hi Jiri, i found one little mistake in GetSchemaCommandText() function of FbDataReader (i downloaded source and binary just few minutes ago) so, we have following sql statement SELECT fld.rdb$computed_blr AS computed_blr, fld.rdb$compu

Re: [Firebird-net-provider] Bug in FbConnection.GetSchema("Columns")

2008-01-11 Thread Jiri Cincura
On 1/11/08, André Knappstein, Controlling <[EMAIL PROTECTED]> wrote: > Looking at a column which is not nullable because you set "NOT NULL" > to the column, you would EXPECT the property "is_nullable" to be > true, where "true" is represented by the numeric value 1. > I would NOT, because literally

Re: [Firebird-net-provider] Bug in FbConnection.GetSchema("Columns")

2008-01-11 Thread Dean Harding
André Knappstein wrote: > I am a bit worried, in any case, that you would expect different > results for the 2 cases, because in both cases the column literally > "is not nullable". > > Maybe what you want and need is a (new?) property "NOT_NULL_SET" which > could result to false for the column wh

Re: [Firebird-net-provider] Bug in FbConnection.GetSchema("Columns")

2008-01-11 Thread André Knappstein , Controlling
Jürgen, reading this I am quite glad that I have not needed this property in .net provider so far, because I admit it would exceed my comprehension of FB internals. Just in case I need it in future, I would like to get an additional clarification: Looking at a column which is not nullable becau