[Firebird-net-provider] [FB-Tracker] Created: (DNET-152) FbBatchExecution.ConnectToDatabase fails to parse valid format CONNECT statement. Exception: "Cannot start parsing after the end of the string"

2008-01-10 Thread Dan MacKay (JIRA)
FbBatchExecution.ConnectToDatabase fails to parse valid format CONNECT statement. Exception: "Cannot start parsing after the end of the string" ---

[Firebird-net-provider] [FB-Tracker] Created: (DNET-151) FbConnection.GetSchema("Columns") has wrong values concerning not-null columns.

2008-01-10 Thread Juergen Thomas (JIRA)
FbConnection.GetSchema("Columns") has wrong values concerning not-null columns. --- Key: DNET-151 URL: http://tracker.firebirdsql.org/browse/DNET-151 Project: .NET Data provid

Re: [Firebird-net-provider] EnvDTE and VSLangProj80

2008-01-10 Thread Jiri Cincura
On 1/10/08, Carlos <[EMAIL PROTECTED]> wrote: > Hello: > > > > in FirebirdClient we have %subj% references. They are not needed to > > build provider in VS or any other provider stuff, isn't it? Looks like > > some orphans. > > > > May I remove it? > > > Sure, if i remember well they are needed onl

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

2008-01-10 Thread Jiri Cincura
On 1/10/08, VS-Polis <[EMAIL PROTECTED]> wrote: > Therefore I declare it a bug. Please report it into tracker (http://tracker.firebirdsql.org) and I will solve it ASAP. If you can, provide also small test-case. -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/jirka/ | http

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

2008-01-10 Thread Jiri Cincura
On 1/10/08, Helen Borrie <[EMAIL PROTECTED]> wrote: > It is wrong. The word "nullable" is not a synonym for NOT NULL, it is the > opposite. A field definition constrained NOT NULL is "non-nullable". Oh man, you're right. I missed, that we're talking about nullable and not about not null. --

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

2008-01-10 Thread VS-Polis
Thank you Jiri, alright, I know that's the correct way to check a column in Firebird. But when I want to check a DataColumn in a NET application, I want to know if this DataColumn allows DBNull or not. Beyond I want to convert the database structure to an xsd schema file and to a typed dataset

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

2008-01-10 Thread Helen Borrie
At 10:11 PM 10/01/2008, you wrote: >On 1/10/08, VS-Polis <[EMAIL PROTECTED]> wrote: >> If the database column itself is set to "not null" or if this column is >> part of the primary key, it returns is_nullable as correct value "1" resp. >> "true". If the database column is defined via domain and t

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

2008-01-10 Thread Jiri Cincura
On 1/10/08, Dean Harding <[EMAIL PROTECTED]> wrote: > I guess the question is, though, is that the behavior of Firebird > server? Obviously, GetSchema("Columns") should be returning whatever > Firebird *actually does*. I don't understand your explanation of the question. Can you provide more detai

[Firebird-net-provider] EnvDTE and VSLangProj80

2008-01-10 Thread Jiri Cincura
Hello Carlos (again and last for today), in FirebirdClient we have %subj% references. They are not needed to build provider in VS or any other provider stuff, isn't it? Looks like some orphans. May I remove it? -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/jirka/ | htt

[Firebird-net-provider] Missing files on SVN

2008-01-10 Thread Jiri Cincura
Hi Carlos, in project file for FirebirdClint (latest version) are two files that are not in SVN: StoreSchemaDefinition.ssdl StoreSchemaMapping.msl Could you please commit them? OT: Seems that you'll have no free time. ;) -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/j

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

2008-01-10 Thread Dean Harding
Jiri Cincura wrote: > This is right, imo. The NOT NULL work like this: > 1. If the domain is not null > not null = true > 2. If the domain isn't not null, look at the column definition; if the > column definition is not null > not null = true > 3. Othervise. > > So you cannot override not null to

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

2008-01-10 Thread Jiri Cincura
On 1/10/08, VS-Polis <[EMAIL PROTECTED]> wrote: > If the database column itself is set to "not null" or if this column is > part of the primary key, it returns is_nullable as correct value "1" resp. > "true". If the database column is defined via domain and the domain is set > to "not null", the c

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

2008-01-10 Thread VS-Polis
Title: Jürgen Thomas GetSchema("Columns") has wrong values concerning not-null columns. The result DataTable of the FbConnection.GetSchema("Columns") method sets the column "is_nullable" as follows: If the database column itself is set to "not null" or if this column is part of the primary ke