firebird-net-provider — All about development of the MS .Net provider

RE: [Firebird-net-provider] Provider for embeded

[Vadym <va...@ca...>]

> > Can provider-1.6-alpha.1 be used for embedded version?
> 
> Yes, add ServerType=1 to your connection string.

Works excellent, thanks!

Vadim.

Re: [Firebird-net-provider] FbCommandBuilder incorrect behaivor in where clause generation on nullable fields!

[<car...@te...>]

Hello:

>     Hmmmm... no, it's don't work, because
>        @B2 = CAST(NULL AS DATE)))
>        NULL = NULL --> NULL (false), no match comparison
>            ^^^ binary operator for NULL arguments result always NULL.
>        in this may use only IS NULL check, but in this construction
>        parameter can't be used... :) COALESCE... ;)))))))
>        

Ok with COALESCE ;), i will try to do the changes as soon as possible ( 
probably next week, i want to release beta 1 this weekend )




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re[2]: [Firebird-net-provider] FbCommandBuilder incorrect behaivor in where clause generation on nullable fields!

[Dmitry A. <fd...@ua...>]

Hello Carlos,

Thursday, March 25, 2004, 5:06:59 PM, you wrote:

CGÁ> Hello:

>> Carlos: you to do work for this feature? :)
CGÁ> Yes i only need to decide how i'm going to fix it :)

CGÁ> Huumm what about this?? :

CGÁ> SELECT EMP_NO FROM EMPLOYEE WHERE (HIRE_DATE=@B1 OR (HIRE_DATE IS NULL
CGÁ> AND @B2 = CAST(NULL AS DATE)))
    Hmmmm... no, it's don't work, because
       @B2 = CAST(NULL AS DATE)))
       NULL = NULL --> NULL (false), no match comparison
           ^^^ binary operator for NULL arguments result always NULL.
       in this may use only IS NULL check, but in this construction
       parameter can't be used... :) COALESCE... ;)))))))
       
-- 
Best regards,
 Dmitry                            mailto:fd...@ua...

Re: [Firebird-net-provider] Provider for embeded

[<car...@te...>]

Hello:

> I am trying to replace MS JET engine with Firebird embedded version in 
> C# project I’m working on.
> 
> Can provider-1.6-alpha.1 be used for embedded version?

Yes, add ServerType=1 to your connection string.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Fwd: FirebirdNETProvider1.5-RC5-NET1.1

[<car...@te...>]

Hello:

> Forwarded for your attention - I haven't a clue.

Thanks very much, for forward it.

>> I am using the FirebirdNETProvider1.5-RC5-NET1.1 downloaded
>> off  the ibphoenix website.
>> I have found that when I try to insert or update an email
>> address it replaces everything from the @ to the "period"
>> with a question mark. eg. yu...@ma... is inserted
>> as yumna?.co.za in the database. The database field is a
>> varchar so this shouldn't be a problem.

It's fixed in the 1.5 final version ( 1.5.1 or 1.5.2 )




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Provider for embeded

[Vadym <va...@ca...>]

Hello there,

 

I am trying to replace MS JET engine with Firebird embedded version in C#
project I'm working on.

Can provider-1.6-alpha.1 be used for embedded version?

I found embedded project in sources but not in installation. Should I
compile it on my own? Is it known to work?

 

Thanks

Vadim Chekan.

[Firebird-net-provider] Fwd: FirebirdNETProvider1.5-RC5-NET1.1

[Ann W. H. <aha...@ib...>]

Forwarded for your attention - I haven't a clue.

Ann



>From: "Yumna Matvad" <yu...@ma...>
>Subject: FirebirdNETProvider1.5-RC5-NET1.1
>To: aha...@ib...
>X-Mailer: CommuniGate Pro WebUser Interface v.4.1.8
>Date: Thu, 25 Mar 2004 09:53:02 +0200
>
>Hi Ann.
>
>I am not really sure who to contact regarding this
>matter...please could you forward to the correct persons.
>
>I am using the FirebirdNETProvider1.5-RC5-NET1.1 downloaded
>off  the ibphoenix website.
>I have found that when I try to insert or update an email
>address it replaces everything from the @ to the "period"
>with a question mark. eg. yu...@ma... is inserted
>as yumna?.co.za in the database. The database field is a
>varchar so this shouldn't be a problem.
>
>When I run the same SQL in IB Console the correct email
>address is inserted.
>
>Please could you advise what I should do regarding this
>problem.
>
>Many Thanks.
>Regards,
>Yumna
>
>Most people don't recognize opportunity when it comes,
>because it's usually dressed in overalls and looks a lot
>like work
>__________________________________________________________________________
>http://www.webmail.co.za/dialup Webmail ISP - Cool Connection, Cool Price

Regards,

Ann
www.ibphoenix.com
We have answers.

[Firebird-net-provider] Installing FB .NET Provider 1.5.2 into Delphi 8

[Peter M. J. <pe...@tc...>]

Hi!  New guy here!

Can someone please tell me how to use the FB 1.5.2 .NET Provider in a 
Delphi 8 VCL Forms App?  I installed the FB 1.5.2 .NET Provider assembly 
and it's accessible in a Windows Forms App, but not in a VCL Forms app.


Peter M. Jagielski
Senior Software Engineer
TCS Software, Inc.
Columbus, Ohio
tel:  614.451.5010

Pe...@TC...
<http://www.associationsoftware.com/>www.AssociationSoftware.com
Helping Associations Grow with Technology  

Re: [Firebird-net-provider] FbCommandBuilder incorrect behaivor in where clause generation on nullable fields!

[<car...@te...>]

Hello:

> Carlos: you to do work for this feature? :)

Yes i only need to decide how i'm going to fix it :)

Huumm what about this?? :

SELECT EMP_NO FROM EMPLOYEE WHERE (HIRE_DATE=@B1 OR (HIRE_DATE IS NULL 
AND @B2 = CAST(NULL AS DATE)))




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re[2]: [Firebird-net-provider] FbCommandBuilder incorrect behaivor in where clause generation on nullable fields!

[Dmitry A. <fd...@ua...>]

Hello Carlos,

Thursday, March 25, 2004, 4:35:30 PM, you wrote:

CGÁ> Hello:

>>      And i'm don't know true... COALESCE its unsupported 1.0.x and
>>      Interbase 6? Or supported?!?! If not supported -- it's may be
>>      realised as feature for Firebird 1.5!
CGÁ> It's new in 1.5
     Hummmmm... this in general interests anyone except me?!?!?! :)))

     2Carlos: you to do work for this feature? :)

-- 
Best regards,
 Dmitry                            mailto:fd...@ua...

Re[2]: [Firebird-net-provider] Query Analyzer

[Dmitry A. <fd...@ua...>]

Hello Carlos,

Thursday, March 25, 2004, 4:19:44 PM, you wrote:

CGÁ> If there are more people interested on this i can try to add something
CGÁ> to the provider for track executed commands.
     Okey, but i think what, it's you work must be have a lowe priority.  ;)

-- 
Best regards,
 Dmitry                            mailto:fd...@ua...

Re: [Firebird-net-provider] FbCommandBuilder incorrect behaivor in where clause generation on nullable fields!

[<car...@te...>]

Hello:

>      And i'm don't know true... COALESCE its unsupported 1.0.x and
>      Interbase 6? Or supported?!?! If not supported -- it's may be
>      realised as feature for Firebird 1.5!

It's new in 1.5




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re[2]: [Firebird-net-provider] FbCommandBuilder incorrect behaivor in where clause generation on nullable fields!

[Dmitry A. <fd...@ua...>]

Hello Carlos,

Thursday, March 25, 2004, 2:41:01 PM, you wrote:

CGÁ> I think i can do a change do the generation of the where clausule using
CGÁ> coalesce ( have you reviewed how the use of coalesce affects the query
CGÁ> plan ?? maybe it have no effect ... i will try to check it ) for 1.5+
CGÁ> and using Pk fields only on all other versions ( 1.0.x and Interbase 6 )
     Hummmmmm... I think that this will render the negative influence
     upon building plan, but as it were there was not -- must work
     pravilino. better NATURAL plan, than incorrect result.

     And i'm don't know true... COALESCE its unsupported 1.0.x and
     Interbase 6? Or supported?!?! If not supported -- it's may be
     realised as feature for Firebird 1.5!
     
CGÁ> Opinions ?????
     Is it my opinion! ;)


-- 
Best regards,
 Dmitry                            mailto:fd...@ua...

Re: [Firebird-net-provider] Query Analyzer

[<car...@te...>]

Hello:

>     I don't have any idea. But debug programs with monitor, several
>     easier. Now some-time execute own function what prints SQL query,
>     and parameters, but this approach not possible if I use
>     DataAdapter, but I his use :)

If there are more people interested on this i can try to add something 
to the provider for track executed commands.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FbCommandBuilder incorrect behaivor in where clause generation on nullable fields!

[<car...@te...>]

Hello:

>    In SqlClient use template ({0}=? OR ({0} IS NULL AND ? IS NULL)),
>    but it's not work on fbserver. But if we work on firebird 1.5 we
>    can release correct work thru, for example COALESCE keyword. When
>    all be works fine! (May be CASE works too, but need 3 params, but
>    not 2).
> 
>    I think that in server this feature will else long, but we already
>    can get correct work, if using coalesce keyword, on FB1.5 at least
>    once! 

Hummmmmmmm ... not sure about what to do !! :)

I think i can do a change do the generation of the where clausule using 
coalesce ( have you reviewed how the use of coalesce affects the query 
plan ?? maybe it have no effect ... i will try to check it ) for 1.5+ 
and using Pk fields only on all other versions ( 1.0.x and Interbase 6 )



Opinions ?????



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re[2]: [Firebird-net-provider] Query Analyzer

[Dmitry A. <fd...@ua...>]

Hello Carlos,

Thursday, March 25, 2004, 2:08:10 PM, you wrote:

CGÁ> What do you mean to add a FbMonitor class ?? ( i was thinking on this
CGÁ> some time ago, i think there are some Delphi components that have a
CGÁ> monitor class but never used it :) , my previous experience with 
CGÁ> firebird before start the .NET Provider project was using ODBC :P )

    May be commands, parameter values of each executed command :)
    transactions... i interested great in this on server level,
    because not need any changes in source codes. results interested
    too. may be realesation FbMonitor... and... some external utility
    what may be "connect" to my program... but... ;) Hummmmmm.... it's
    all can't be realized on provider level (without performance
    cutses)?
    I don't have any idea. But debug programs with monitor, several
    easier. Now some-time execute own function what prints SQL query,
    and parameters, but this approach not possible if I use
    DataAdapter, but I his use :)

-- 
Best regards,
 Dmitry                            mailto:fd...@ua...

Re: [Firebird-net-provider] Wanted: Firebird-Programmer for Open Source project (app. 6 hours work)

[<car...@te...>]

Hello:

Sorry for the delay.

> The currently available release on SourceForge is 1.3.1 but I will 
> provide you with the RC for 1.4 which contains many enhancements 
> regarding database compatibility (sequence support, improved mapping 
> abilities and ID handling). If you're interested in implementing the 
> DAO, please contact me.

I can try to implement it.







--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] FbCommandBuilder incorrect behaivor in where clause generation on nullable fields!

[Dmitry A. <fd...@ua...>]

Hello firebird-net-provider,

   [vb.net]
   _command.CommandText = "SELECT ID FROM EMPLOYES WHERE (BIRTHDAY=@B1 OR (BIRTHDAY IS NULL AND @B2 IS NULL))"
   _command.Parameters.Add("@ID", 1)
   _command.Parameters.Add("@B1", DBNull.Value)
   _command.Parameters.Add("@B2", DBNull.Value)
   Dim __id As Integer = _command.ExecuteScalar()

   and in execution gets exception: Data type unknown
   all right, because fbserver unknown type of @B2 parameter (it's he
   strange feautre of fbserver).

   but if rewrite on this:
        _command.CommandText = "SELECT ID FROM EMPLOYES WHERE " & _
        "BIRTHDAY=@B1 OR " & _
        "(BIRTHDAY IS NULL AND COALESCE(@B2, CAST(NULL AS DATE)) IS NULL)"
   all work :)
   
   When field is not null we may generate whereClausule2 template (as
   pk field).
   But when field nullable -- you generate whereClausule1, but this
   incorrect (when parameter not null -- in result set returned
   records and equal parameter value and field IS NULL. it's
   incorrect. and as result we got spare record).
         whereClausule1     = "(({0} IS NULL) OR ({0} = ?))";
         whereClausule2     = "({0} = ?)";

   In SqlClient use template ({0}=? OR ({0} IS NULL AND ? IS NULL)),
   but it's not work on fbserver. But if we work on firebird 1.5 we
   can release correct work thru, for example COALESCE keyword. When
   all be works fine! (May be CASE works too, but need 3 params, but
   not 2).

   I think that in server this feature will else long, but we already
   can get correct work, if using coalesce keyword, on FB1.5 at least
   once! 

-- 
Best regards,
 Dmitry                          mailto:fd...@ua...

Re: [Firebird-net-provider] Query Analyzer

[<car...@te...>]

Hello:

> I have other question: what organize SQL Monitor? ;-)

What do you mean to add a FbMonitor class ?? ( i was thinking on this 
some time ago, i think there are some Delphi components that have a 
monitor class but never used it :) , my previous experience with 
firebird before start the .NET Provider project was using ODBC :P )






--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Query Analyzer

[Dmitry A. <fd...@ua...>]

Hello Carlos,

Thursday, March 25, 2004, 12:23:58 PM, you wrote:

CGÁ> I have found a nice Query Analyzer for SQLLite (
CGÁ> http://www.monkeyshinez.net/SQLiteQA/ ), i'm thinking on modify it for
CGÁ> make it to work with the Firebird .NET Provider ( i think it's a little
CGÁ> and nice tool :) ).
     yes, small and nice tool :)

CGÁ> I want to know opinions before make anything, what do you think can be
CGÁ> useful or not ??
     and... imho, i think, what best database tool -- it's ibexpert :)
     I seem will little are used...
     on the other hand -- for simple execute requests, thing
     remarkable :) therefore as same ibexpert -- very heavy.

     I have other question: what organize SQL Monitor? ;-)

-- 
Best regards,
 Dmitry                            mailto:fd...@ua...

[Firebird-net-provider] Query Analyzer

[<car...@te...>]

Hello

I have found a nice Query Analyzer for SQLLite ( 
http://www.monkeyshinez.net/SQLiteQA/ ), i'm thinking on modify it for 
make it to work with the Firebird .NET Provider ( i think it's a little 
and nice tool :) ).

I have contacted the author, he told me that the sources aren't covered 
by any license and that i haven't problem if i open the sources.

I want to know opinions before make anything, what do you think can be 
useful or not ??





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] fbconnection.cs

[<car...@te...>]

Hello:

> In FbConneaction.cs:CreateDatabase(Hashtable)
> 
> The code “if (values.ContainsKey("ServerType"))” is repeated twice, in 
> lines 281 and 306.
> 
> Version: of provider: 1.6-alpha1

You are right, thanks very much, it's fixed yet in CVS, i will try to 
test it tomorrow ( it's a little late here now :) )




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] fbconnection.cs

[Vadym <va...@ca...>]

Hello there!

 

In FbConneaction.cs:CreateDatabase(Hashtable)

The code "if (values.ContainsKey("ServerType"))" is repeated twice, in lines
281 and 306.

Version: of provider: 1.6-alpha1

 

Vadim Chekan.

Re: [Firebird-net-provider] 'cast is not valid' error - can't insert rows to my FB :-(

[<car...@te...>]

Hello:

> Please help me, because I will have to look for another DB (I hope it will
> be not nessesery).

Have you checked that the sql statement works in other tool ( Like 
IBExpert or isql ), can you post the table structure ??





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] 'cast is not valid' error - can't insert rows to my FB :-(

[<car...@te...>]

Hello:

> Please help me, because I will have to look for another DB (I hope it will
> be not nessesery).

Ah and another thing :) have you tested it using parametrized querys ??




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain