Re: [Firebird-net-provider] Enhacement for FBCommand

2007-06-27 Thread André Knappstein , Controlling
Paul, I still did not find a way to reply to this mail-list thingy from behind our proxy, so I hope this message will get through to you. The function you wish for does not belong into a command-feature or new method, but you can easily implement it yourself. To do that, connect with sufficient

Re: [Firebird-net-provider] Enhacement for FBCommand

2007-06-27 Thread Jiri Cincura
On 6/27/07, André Knappstein, Controlling [EMAIL PROTECTED] wrote: You can hand the procedure name in question to that query and if you receive a result, then a procedure with the same name exists in the database. Maybe it's better to try to run it and catch exception. You will save one trip

Re: [Firebird-net-provider] Enhacement for FBCommand

2007-06-27 Thread André Knappstein , Controlling
In addition I think I remember that only with classic server engine a listed stored proc is active already for the next connection to the database. JC What do you mean with listed? If I create a new SP, I will find it then listed in RDB$Procedures. On ClassicEngine, next user will be able to

[Firebird-net-provider] Installing DDEX 2

2007-06-27 Thread zakharov
Hello I see discussion in similar message post, but ... I've installed Firebird Client 2.1.0-RC1 and the DEX provider 2.0.2 and the FirebirdDDEXProviderPacakgeLess32.reg file. I've added the entries to the machine.cfg file. I'm using VS2005 Professional with SP2 The components are visible in

Re: [Firebird-net-provider] Enhacement for FBCommand

2007-06-27 Thread Mercea Paul
Thank you all for responses! Anyway, 2 query is needed to get the results. 1 to see if SP exist 1 to run. Best is to have a stored proc or function to give a true or false result for me. Thanks again, Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf

Re: [Firebird-net-provider] Installing DDEX 2

2007-06-27 Thread Carlos Guzmán Álvarez
Hello: But... 1) when I try to use fbConnection - no button appear in its ConnectionString property 2) When I try to use fbDataAdapter - no Dialog appear etc That features was part of the old design-time support that was removed in 2.1 sources. You can try to use TableAdapters or use

Re: [Firebird-net-provider] Enhacement for FBCommand

2007-06-27 Thread Jiri Cincura
On 6/27/07, Mercea Paul [EMAIL PROTECTED] wrote: Anyway, 2 query is needed to get the results. 1 to see if SP exist 1 to run. Just run SP and if you get erorr thst not exists do some steps to fix error. If exists, you save 1 trip. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ |

Re: [Firebird-net-provider] Mapping a database char column to

2007-06-27 Thread Carlos Guzmán Álvarez
Hello: this is the exception: System.ArgumentException: System.FormatException: String was not = recognized as a valid Boolean. As Dean has pointed out yet the field values should be valid for a boolean conversion in .net

[Firebird-net-provider] [FB-Tracker] Created: (DNET-99) timestamp handling not consistent when same date and time data is supplyed

2007-06-27 Thread luigi (JIRA)
timestamp handling not consistent when same date and time data is supplyed -- Key: DNET-99 URL: http://tracker.firebirdsql.org/browse/DNET-99 Project: .NET Data provider

[Firebird-net-provider] [FB-Tracker] Created: (DNET-100) FbCommandBuilder has problems with Calculated fields

2007-06-27 Thread Eduardo Gamboa (JIRA)
FbCommandBuilder has problems with Calculated fields Key: DNET-100 URL: http://tracker.firebirdsql.org/browse/DNET-100 Project: .NET Data provider Issue Type: Bug Components:

Re: [Firebird-net-provider] DNET-100

2007-06-27 Thread Jiri Cincura
Hi, I'll continue here. Funny stuff is, that we have the code for this. If we getting whether column is or isn't readonly we're checking the right value. So I propose these changes: 1. I'll modify code in FbDataReader.GetSchemaTable to correctly decide wheher is expression or not (it's similar

Re: [Firebird-net-provider] Help with the installation of the DDEX provider in Visual Studio 2005

2007-06-27 Thread Angel Ivorra
Thanks to all... I get this working... I combine the FirebirdDDEXProviderPackageLess32.reg file. I change the path a c:\FirebirdClient\ I Change the version number to 2.1.0.0 Otherwise not work. Without change the version number in the machine.config file, visual studio suddenly closes when

Re: [Firebird-net-provider] DNET-100

2007-06-27 Thread Carlos Guzmán Álvarez
Hello: I'll continue here. Funny stuff is, that we have the code for this. If we getting whether column is or isn't readonly we're checking the right value. Looks fine to me ( i ahev .net installed again ... while now i have the 64 bit version )

Re: [Firebird-net-provider] Enhacement for FBCommand

2007-06-27 Thread Dean Harding
Anyway, 2 query is needed to get the results. 1 to see if SP exist 1 to run. Best is to have a stored proc or function to give a true or false result for me. But how would that function work if not by making a roundtrip to the database? I think Jiri's idea is the best: just try executing it,

[Firebird-net-provider] [FB-Tracker] Created: (DNET-101) enlistment failure leaves innerConnection dangling

2007-06-27 Thread Barry Schwarz (JIRA)
enlistment failure leaves innerConnection dangling -- Key: DNET-101 URL: http://tracker.firebirdsql.org/browse/DNET-101 Project: .NET Data provider Issue Type: Bug Components: