Re: [Firebird-net-provider] Problem Inserting Boolean Values asCharsinto DB

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > On Behalf Of Dean Harding > Sent: Monday, November 06, 2006 18:07 > To: 'For users and developers of the Firebird .NET providers' > Subject: Re: [Firebird-net-provider] Problem Inserting > Boolean Values asChars

Re: [Firebird-net-provider] Problem Inserting Boolean Values as Chars into DB

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > On Behalf Of Jiri Cincura > Sent: Monday, November 06, 2006 17:57 > To: For users and developers of the Firebird .NET providers > Subject: Re: [Firebird-net-provider] Problem Inserting > Boolean Values as Chars

Re: [Firebird-net-provider] Problem Inserting Boolean Values as Charsinto DB

>CREATE TABLE FSBSRun ( >... >Maintenance CHAR NOT NULL, >Availability CHAR NOT NULL, >... >) I think the problem is that CHAR in the database is not the same as the char data type in code. In the database, a CHAR is actually a string that is one character l

Re: [Firebird-net-provider] Problem Inserting Boolean Values as Chars into DB

Kwok, Marcus B. wrote: >char maint = (run.maintenance) ? 'T' : 'F'; >command->Parameters->Add(S"@maint", __box(maint)); > >char avail = (run.availability) ? 'T' : 'F'; >command->Parameters->Add(S"@avail", __box(avail)); > Well, I'm not familiar with C++/CLI. But try to force para

[Firebird-net-provider] Problem Inserting Boolean Values as Chars into DB

Hi! This is my first post to the list. I've tried to trim it down to what seems the most relevant. I am having a problem inserting into my database using the Firebird .NET provider. I am using Visual Studio .NET 2003 SP1 and thus the .NET provider 1.7 and Firebird 1.5, and I am coding in Manage

[Firebird-net-provider] Generating error on dataset using PLAN

Hi I'm using Firebird 2.0 RC5 server and Firebird .net provider 2.0.1 . I have this sql statement in dataset (xsd): select * from sys_mu where visible='Y' PLAN (SYS_MU ORDER SYS_MU_NAME INDEX (SYS_MU_VISIBLE)) order by uni_name When is trying to generate select generate error because PLAN word

Re: [Firebird-net-provider] Little problem with stored proc

> > Did you close the reader after reading? Thanks jiri the problem was here ! - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your j

Re: [Firebird-net-provider] Little problem with stored proc

Le roy Arnaud wrote: > FbConnection conn = new FbConnection(myconnection); > FbCommand cmd = new FbCommand(); > cmd.Connection = conn; > cmd.CommandType = CommandType.StoredProcedure; > cmd.CommandText = "GET_PLAGES"; > cmd.Parameters.Add(new FbParameter("@IDPLAGE", FbDbType.Integer)); > cmd.Parame

[Firebird-net-provider] Little problem with stored proc

Hello, I have a sp that do an insert and after that a for select. Ex: CREATE PROCEDURE GET_PLAGES (IDPLAGE INTEGER) RETURNS ( IDPLAGE INTEGER, DEBUT INTEGER, FIN INTEGER, SHORTDESCIPTION VARCHAR(2000)) AS begin insert into plage(debut, fin, shortdesciption) values (:debut, :fin

Re: [Firebird-net-provider] FbDataAdapter problem

Hello: > Regarding > http://sourceforge.net/mailarchive/forum.php?thread_id=30866705&forum_id=12591 > > > > the problem is in this method: > protected override int Update(DataRow[] dataRows, DataTableMapping > t

[Firebird-net-provider] Documentation on FbException and FbError codes (V2.0.1)

Hi, I am seeking documentation and advice on handling errors when using the FirebirdClient-2.0.1 driver (against Firebird 1.5.3 database). Upon executing a bit of invalid SQL, an FbException is returned. It contains a collection of FbErrors. For example on executing 'Select rubbish;' I receiv

Re: [Firebird-net-provider] Create or update a table

k, thanks .- Original Message From: paul.mercea <[EMAIL PROTECTED]>To: For users and developers of the Firebird .NET providers Sent: Monday, November 6, 2006 8:59:45 AMSubject: Re: [Firebird-net-provider] Create or update a table Hi   I use this scenario. In database I have one ta

Re: [Firebird-net-provider] Connection Pool

Pham Huu Le Quoc Phuc wrote: > Hi! > > Can I use connection pool with “using keyword”. Is it leak memory? > > > > Using(FbConnection Connection = new FbConnection(ConnectionString) > > { > > } > Yes you can. It's not a memory leak. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | ht

[Firebird-net-provider] Connection Pool

Hi! Can I use connection pool with “using keyword”. Is it leak memory?   Using(FbConnection Connection = new FbConnection(ConnectionString) { }   Thanks. - Using Tomcat but need to do more? Need to support

Re: [Firebird-net-provider] How to get Generator value

Thanks for your reply, I will try it! Phucphlq -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of paha Sent: Monday, November 06, 2006 2:57 PM To: firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] How to get Generator value If