You can subscribe to this list here.
2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(10) |
Nov
(55) |
Dec
(36) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2003 |
Jan
(38) |
Feb
(108) |
Mar
(79) |
Apr
(95) |
May
(64) |
Jun
(130) |
Jul
(146) |
Aug
(121) |
Sep
(96) |
Oct
(149) |
Nov
(161) |
Dec
(113) |
2004 |
Jan
(113) |
Feb
(163) |
Mar
(248) |
Apr
(132) |
May
(157) |
Jun
(160) |
Jul
(236) |
Aug
(284) |
Sep
(293) |
Oct
(277) |
Nov
(257) |
Dec
(356) |
2005 |
Jan
(203) |
Feb
(190) |
Mar
(220) |
Apr
(165) |
May
(124) |
Jun
(160) |
Jul
(190) |
Aug
(142) |
Sep
(152) |
Oct
(189) |
Nov
(187) |
Dec
(159) |
2006 |
Jan
(170) |
Feb
(151) |
Mar
(212) |
Apr
(262) |
May
(226) |
Jun
(196) |
Jul
(223) |
Aug
(165) |
Sep
(163) |
Oct
(348) |
Nov
(225) |
Dec
(141) |
2007 |
Jan
(261) |
Feb
(161) |
Mar
(222) |
Apr
(193) |
May
(121) |
Jun
(157) |
Jul
(151) |
Aug
(159) |
Sep
(61) |
Oct
(123) |
Nov
(172) |
Dec
(96) |
2008 |
Jan
(104) |
Feb
(138) |
Mar
(131) |
Apr
(131) |
May
(74) |
Jun
(107) |
Jul
(89) |
Aug
(89) |
Sep
(172) |
Oct
(158) |
Nov
(119) |
Dec
(86) |
2009 |
Jan
(52) |
Feb
(84) |
Mar
(78) |
Apr
(83) |
May
(54) |
Jun
(79) |
Jul
(60) |
Aug
(62) |
Sep
(50) |
Oct
(147) |
Nov
(50) |
Dec
(70) |
2010 |
Jan
(135) |
Feb
(113) |
Mar
(74) |
Apr
(93) |
May
(35) |
Jun
(71) |
Jul
(33) |
Aug
(110) |
Sep
(47) |
Oct
(18) |
Nov
(61) |
Dec
(34) |
2011 |
Jan
(46) |
Feb
(47) |
Mar
(25) |
Apr
(24) |
May
(21) |
Jun
(22) |
Jul
(20) |
Aug
(51) |
Sep
(31) |
Oct
(42) |
Nov
(22) |
Dec
(22) |
2012 |
Jan
(31) |
Feb
(19) |
Mar
(25) |
Apr
(55) |
May
(16) |
Jun
(28) |
Jul
(33) |
Aug
(25) |
Sep
(32) |
Oct
(25) |
Nov
(52) |
Dec
(35) |
2013 |
Jan
(43) |
Feb
(18) |
Mar
(36) |
Apr
(45) |
May
(22) |
Jun
(13) |
Jul
(31) |
Aug
(24) |
Sep
(19) |
Oct
(59) |
Nov
(47) |
Dec
(25) |
2014 |
Jan
(27) |
Feb
(15) |
Mar
(38) |
Apr
(10) |
May
(15) |
Jun
(36) |
Jul
(24) |
Aug
(28) |
Sep
(16) |
Oct
(6) |
Nov
(44) |
Dec
(40) |
2015 |
Jan
(52) |
Feb
(22) |
Mar
(13) |
Apr
(17) |
May
(22) |
Jun
(36) |
Jul
(18) |
Aug
(41) |
Sep
(71) |
Oct
(60) |
Nov
(49) |
Dec
(43) |
2016 |
Jan
(60) |
Feb
(13) |
Mar
(21) |
Apr
(28) |
May
(23) |
Jun
(39) |
Jul
(17) |
Aug
(37) |
Sep
(33) |
Oct
(15) |
Nov
(22) |
Dec
(20) |
2017 |
Jan
(27) |
Feb
(40) |
Mar
(48) |
Apr
(19) |
May
(29) |
Jun
(2) |
Jul
(19) |
Aug
(36) |
Sep
(18) |
Oct
(10) |
Nov
(11) |
Dec
(5) |
2018 |
Jan
(5) |
Feb
(4) |
Mar
(5) |
Apr
(3) |
May
(4) |
Jun
(17) |
Jul
(7) |
Aug
(7) |
Sep
(12) |
Oct
(8) |
Nov
(2) |
Dec
|
2019 |
Jan
(8) |
Feb
(5) |
Mar
(3) |
Apr
(5) |
May
(3) |
Jun
(2) |
Jul
(8) |
Aug
(7) |
Sep
(3) |
Oct
(12) |
Nov
(7) |
Dec
(1) |
2020 |
Jan
(8) |
Feb
(3) |
Mar
(7) |
Apr
(1) |
May
(2) |
Jun
(1) |
Jul
(3) |
Aug
(25) |
Sep
(5) |
Oct
(3) |
Nov
(7) |
Dec
(16) |
2021 |
Jan
(11) |
Feb
(10) |
Mar
(16) |
Apr
(8) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: stefano m. <ste...@fa...> - 2003-04-14 19:25:50
|
Hi, I got it. I compiled and tested it. Now it works fine for me. I tested the whole application and it's ok. Thanks a lot for your support. Stefano Mostarda ----- Original Message ----- From: "Carlos Guzman Alvarez" <car...@te...> To: "Carlos Guzman Alvarez" <car...@te...> Cc: "stefano mostarda" <ste...@fa...>; <fir...@li...> Sent: Sunday, April 13, 2003 11:43 PM Subject: Re: [Firebird-net-provider] re: re: problem with column alias > Hello: > > di this ) and exec nant in the .net framework directory. > > Sorry, in the provider sources directory :). > > > > > > -- > Best regards > > Carlos Guzm=E1n =C1lvarez > Vigo-Spain > > |
From: Nome r. <wa...@ic...> - 2003-04-14 18:50:06
|
FirebirtNetProvider is 100% compatible with Interbase 6.0? This exception are occurring: Exception Details: FirebirdSql.Data.INGDS.GDSException: Exception of type FirebirdSql.Data.INGDS.GDSException was thrown. |
From: Mike S. <mi...@mi...> - 2003-04-14 13:27:15
|
Hi Carlos I've been using .Net 1.1 since I started with the Firebird provider and it's worked without a problem. Mike. -----Original Message----- From: fir...@li... [mailto:fir...@li...]On Behalf Of Carlos Guzman Alvarez Sent: 14 April 2003 12:51 To: Firebird .Net Provider Subject: [Firebird-net-provider] Release candidate 2 build question Hello: I have reinstalled w2k in my machine and i'm thinking in install .NET Framework 1.1 on it and build release candidate 2 binaries with it ( if all NUnit tests run well with it ), but i want to know how much people is using .NET Framework 1.1 before install it?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain P.S.: Release candidate 2 will be released tomorrow :) ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Carlos G. A. <car...@te...> - 2003-04-14 11:41:25
|
Hello: I have reinstalled w2k in my machine and i'm thinking in install .NET Framework 1.1 on it and build release candidate 2 binaries with it ( if all NUnit tests run well with it ), but i want to know how much people is using .NET Framework 1.1 before install it?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain P.S.: Release candidate 2 will be released tomorrow :) |
From: Carlos G. A. <car...@te...> - 2003-04-13 21:34:20
|
Hello: > di this ) and exec nant in the .net framework directory. Sorry, in the provider sources directory :). -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Carlos G. A. <car...@te...> - 2003-04-13 21:29:39
|
Hello: > I've downloaded all the code from cvs, but now I don't know how to compile > the code to test it cause I've never done this. > :( > > Can you give me a little explanation about how to do this? You need to download and install NAnt http://nant.sourceforge.net/, open an msdos console, you need to have nant and .net framework in the pat ( for the .net framework ( you exec the sdkvars.bat that ships with it to di this ) and exec nant in the .net framework directory. Huummm if you want i can send to you a binary version built with latest sources. Best regards Carlos Guzmán Álvarez Vigo-España |
From: stefano m. <ste...@fa...> - 2003-04-13 19:59:08
|
Hi, I've downloaded all the code from cvs, but now I don't know how to compil= e the code to test it cause I've never done this. :( Can you give me a little explanation about how to do this? Thanks Bye ----- Original Message ----- From: "Carlos Guzman Alvarez" <car...@te...> To: "stefano mostarda" <ste...@fa...> Cc: <fir...@li...> Sent: Saturday, April 12, 2003 11:15 PM Subject: Re: [Firebird-net-provider] re: re: problem with column alias > Hello: > > > The query was just an example. going deeper in the problem I find out > > that the problem occurs only when I use dataset to store the > > information. If I use a DataReader the problem doesn't occur. > > > > Any IDEA?? > > Thanks very much, I have commited a fix to the CVS for this issue can > you give it a try an tel if it's working well, please ?? :) > > > > -- > Un saludo > > Carlos Guzm=E1n =C1lvarez > Vigo-Espa=F1a > > "No tengo dones especiales.S=F3lo soy apasionadamente curioso" > Albert Einstein, cient=EDfico. > > |
From: Carlos G. A. <car...@te...> - 2003-04-12 21:06:09
|
Hello: > The query was just an example. going deeper in the problem I find out > that the problem occurs only when I use dataset to store the > information. If I use a DataReader the problem doesn't occur. > > Any IDEA?? Thanks very much, I have commited a fix to the CVS for this issue can you give it a try an tel if it's working well, please ?? :) -- Un saludo Carlos Guzmán Álvarez Vigo-España "No tengo dones especiales.Sólo soy apasionadamente curioso" Albert Einstein, científico. |
From: stefano m. <ste...@fa...> - 2003-04-12 19:48:34
|
The query was just an example. going deeper in the problem I find out = that the problem occurs only when I use dataset to store the = information. If I use a DataReader the problem doesn't occur. Any IDEA?? |
From:
<car...@te...> - 2003-04-11 14:58:07
|
Hello: > Absolutely certain. Here's the IL for the second constructor of > FbConnection. Note the initialisation of the fields before the code > generated for the actual constructor source, which starts at offset 0054. I have added some changes for solve this to the CVS. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Mike S. <mi...@mi...> - 2003-04-11 14:21:58
|
Hi Carlos Yes, I already tried it with ExecuteNonQuery() :-) This is where it should be, as it doesn't return a cursor - ExecuteReader() implies something else. Yes, ExecuteScript is a great idea, as it means that the Firebird Provider becomes a "one-stop-solution" for anything you need to do with Firebird. I don't want to have to use a separate tool to manage DBs, because I need to code it into the unit tests and into the final application. You'll have to do something like SET TERM so that you can change the terminator as required. In which case, you'll need to parse the SQL properly so that you can ignore SET TERM inside quotes and comments. I'd strongly recommend using SET TERM because this is the standard for scripts, and we can take a script from IBObjects, ISQL or whatever, and run it unchanged using the provider - cool! Mike. -----Original Message----- From: fir...@li... [mailto:fir...@li...]On Behalf Of Carlos Guzman Alvarez Sent: 11 April 2003 15:17 To: mi...@mi... Cc: Firebird .Net Provider Subject: Re: [Firebird-net-provider] Re: How to CREATE DATABASE using .Net FB Provider Hello: > I don't think it's a good idea to have "magic values" in the source code - > in this case ';'. It's much more flexible if the user of the class can > change it. > > If it was a property before, then I wouldn't have had any problem with > creating a stored proc :-) With latest CVS sources you can do it using ExecuteNonQuery method ( now that you have it you can try by yourself :) ). I'm thinking in add an ExecuteScript method to FbCommand for version 1.1, any thoughts ??? -- Best regards Carlos Guzmán Álvarez Vigo-Spain "No tengo dones especiales.Sólo soy apasionadamente curioso" Albert Einstein, científico. ------------------------------------------------------- This SF.net email is sponsored by: Etnus, makers of TotalView, The debugger for complex code. Debugging C/C++ programs can leave you feeling lost and disoriented. TotalView can help you find your way. Available on major UNIX and Linux platforms. Try it free. www.etnus.com _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Carlos G. A. <car...@te...> - 2003-04-11 14:07:07
|
Hello: > I don't think it's a good idea to have "magic values" in the source code - > in this case ';'. It's much more flexible if the user of the class can > change it. > > If it was a property before, then I wouldn't have had any problem with > creating a stored proc :-) With latest CVS sources you can do it using ExecuteNonQuery method ( now that you have it you can try by yourself :) ). I'm thinking in add an ExecuteScript method to FbCommand for version 1.1, any thoughts ??? -- Best regards Carlos Guzmán Álvarez Vigo-Spain "No tengo dones especiales.Sólo soy apasionadamente curioso" Albert Einstein, científico. |
From: Carlos G. A. <car...@te...> - 2003-04-11 14:05:02
|
Helo: > Absolutely certain. Here's the IL for the second constructor of > FbConnection. Note the initialisation of the fields before the code > generated for the actual constructor source, which starts at offset 0054. Ok thanks very much, i'm going now to finish the cange and commit it to the CVS. -- Best regards Carlos Guzmán Álvarez Vigo-Spain "No tengo dones especiales.Sólo soy apasionadamente curioso" Albert Einstein, científico. |
From: Carlos G. A. <car...@te...> - 2003-04-11 14:02:47
|
Hello: > Sorry, got the correct source now - must have made a mistake during the > checkout - don't know how it happened :-( Ok no problem :) -- Best regards Carlos Guzmán Álvarez Vigo-Spain "No tengo dones especiales.Sólo soy apasionadamente curioso" Albert Einstein, científico. |
From: Mike S. <mi...@mi...> - 2003-04-11 13:58:15
|
Carlos Absolutely certain. Here's the IL for the second constructor of FbConnection. Note the initialisation of the fields before the code generated for the actual constructor source, which starts at offset 0054. Mike. .method public hidebysig specialname rtspecialname instance void .ctor(string cmdText, class FirebirdSql.Data.Firebird.FbConnection connection) cil managed { // Code size 99 (0x63) .maxstack 2 IL_0000: ldarg.0 IL_0001: newobj instance void FirebirdSql.Data.Firebird.FbParameterCollection::.ctor() IL_0006: stfld class FirebirdSql.Data.Firebird.FbParameterCollection FirebirdSql.Data.Firebird.FbCommand::parameters IL_000b: ldarg.0 IL_000c: ldc.i4.3 IL_000d: stfld valuetype [System.Data]System.Data.UpdateRowSource FirebirdSql.Data.Firebird.FbCommand::updatedRowSource IL_0012: ldarg.0 IL_0013: ldc.i4.0 IL_0014: stfld valuetype [System.Data]System.Data.CommandBehavior FirebirdSql.Data.Firebird.FbCommand::commandBehavior IL_0019: ldarg.0 IL_001a: ldc.i4.0 IL_001b: stfld bool FirebirdSql.Data.Firebird.FbCommand::disposed IL_0020: ldarg.0 IL_0021: ldc.i4.m1 IL_0022: stfld int32 FirebirdSql.Data.Firebird.FbCommand::actualCommand IL_0027: ldarg.0 IL_0028: ldc.i4.m1 IL_0029: stfld int32 FirebirdSql.Data.Firebird.FbCommand::recordsAffected IL_002e: ldarg.0 IL_002f: ldc.i4.0 IL_0030: stfld bool FirebirdSql.Data.Firebird.FbCommand::splitCommands IL_0035: ldarg.0 IL_0036: ldsfld string [mscorlib]System.String::Empty IL_003b: stfld string FirebirdSql.Data.Firebird.FbCommand::commandText IL_0040: ldarg.0 IL_0041: ldc.i4.1 IL_0042: stfld valuetype [System.Data]System.Data.CommandType FirebirdSql.Data.Firebird.FbCommand::commandType IL_0047: ldarg.0 IL_0048: ldc.i4.1 IL_0049: stfld bool FirebirdSql.Data.Firebird.FbCommand::designTimeVisible IL_004e: ldarg.0 IL_004f: call instance void [System]System.ComponentModel.Component::.ctor() IL_0054: ldarg.0 IL_0055: ldarg.1 IL_0056: call instance void FirebirdSql.Data.Firebird.FbCommand::set_CommandText(string) IL_005b: ldarg.0 IL_005c: ldarg.2 IL_005d: call instance void FirebirdSql.Data.Firebird.FbCommand::set_Connection(class FirebirdSql.Data.Firebird.FbConnection) IL_0062: ret } // end of method FbCommand::.ctor -----Original Message----- From: fir...@li... [mailto:fir...@li...]On Behalf Of Carlos Guzman Alvarez Sent: 11 April 2003 13:44 To: mi...@mi...; Firebird .Net Provider Subject: [Firebird-net-provider] Re: Initializing fields Mike Scott wrote: > Hi Carlos > > I see that the code has lots of field initialisers. This is not a good idea > as the initialisation IL is duplicated by the C# compiler for each > constructor, and prefixed in front of each constructors code. > > In other words, if you have 4 constructors, the output file will have the > same code to initialise the fields repeated 4 times. > > This is obviously wasteful and bloats code unnecessarily. It is recommended > to initialise your fields in your default constructor, then have all the > constructors call base(). Huummmm, i have no notice about this :), are you sure about it ( i have started to make the change in my local tree but i want to be sure about this before commit it, but in any case i think this can be good ) -- Best regards Carlos Guzmán Álvarez Vigo-Spain "No tengo dones especiales.Sólo soy apasionadamente curioso" Albert Einstein, científico. ------------------------------------------------------- This SF.net email is sponsored by: Etnus, makers of TotalView, The debugger for complex code. Debugging C/C++ programs can leave you feeling lost and disoriented. TotalView can help you find your way. Available on major UNIX and Linux platforms. Try it free. www.etnus.com _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Mike S. <mi...@mi...> - 2003-04-11 13:45:52
|
Carlos >> Well in first place i think this is not needed. << I don't think it's a good idea to have "magic values" in the source code - in this case ';'. It's much more flexible if the user of the class can change it. If it was a property before, then I wouldn't have had any problem with creating a stored proc :-) Mike. -----Original Message----- From: fir...@li... [mailto:fir...@li...]On Behalf Of Carlos Guzman Alvarez Sent: 11 April 2003 13:48 To: mi...@mi... Cc: Firebird .Net Provider Subject: Re: [Firebird-net-provider] Re: How to CREATE DATABASE using .Net FB Provider Hello: > I've been looking at the source code :-) > > I see that you use an explicit ';' to split batch commands. This is > essentially the same problem that the ISQL SET TERM command solves. > > Here's a proposed modification to FbCommand.cs that adds a CommandTerminator > property to allow the user to set the command terminator to something other > than semi-colon: > > // added these fields > > private string terminator = ";" ; > private char[] terminatorChars = { ';' } ; > > // new property > > public string CommandTerminator > { > get { return terminator ; } > set > { > if ( terminator != value ) > { > terminator = value ; > terminatorChars = value.ToCharArray() ; > } > } > } Well in first place i think this is not needed. But what are people toughts to add this for 1.1 release ?? ( actual branch is feature closed, and after RC2 i'm thinking in open a new developement branch for 1.1 version of the provider with the modifications needed to run with .Net Framework 1.1 too ) > // modified CommandText > > /// <include file='xmldoc/fbcommand.xml' > path='doc/member[@name="P:CommandText"]/*'/> > public string CommandText > { > get > { > return commands[actualCommand] == null ? "" : commands[actualCommand]; > } > set > { > if (statement != null && commandText != value && commandText != > String.Empty) > { > statement.DropStatement(); > } > > commandText = value; > commands = commandText.Split(terminatorChars); > actualCommand = 0; > } > } This piece of code do not match with actual CVS sources :) , i ask any more :) are you sure you are working with latest CVS sources ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain "No tengo dones especiales.Sólo soy apasionadamente curioso" Albert Einstein, científico. ------------------------------------------------------- This SF.net email is sponsored by: Etnus, makers of TotalView, The debugger for complex code. Debugging C/C++ programs can leave you feeling lost and disoriented. TotalView can help you find your way. Available on major UNIX and Linux platforms. Try it free. www.etnus.com _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Mike S. <mi...@mi...> - 2003-04-11 13:40:43
|
Hi Carlos Sorry, got the correct source now - must have made a mistake during the checkout - don't know how it happened :-( Mike. -----Original Message----- From: fir...@li... [mailto:fir...@li...]On Behalf Of Carlos Guzman Alvarez Sent: 11 April 2003 13:48 To: mi...@mi... Cc: Firebird .Net Provider Subject: Re: [Firebird-net-provider] Re: How to CREATE DATABASE using .Net FB Provider Hello: > I've been looking at the source code :-) > > I see that you use an explicit ';' to split batch commands. This is > essentially the same problem that the ISQL SET TERM command solves. > > Here's a proposed modification to FbCommand.cs that adds a CommandTerminator > property to allow the user to set the command terminator to something other > than semi-colon: > > // added these fields > > private string terminator = ";" ; > private char[] terminatorChars = { ';' } ; > > // new property > > public string CommandTerminator > { > get { return terminator ; } > set > { > if ( terminator != value ) > { > terminator = value ; > terminatorChars = value.ToCharArray() ; > } > } > } Well in first place i think this is not needed. But what are people toughts to add this for 1.1 release ?? ( actual branch is feature closed, and after RC2 i'm thinking in open a new developement branch for 1.1 version of the provider with the modifications needed to run with .Net Framework 1.1 too ) > // modified CommandText > > /// <include file='xmldoc/fbcommand.xml' > path='doc/member[@name="P:CommandText"]/*'/> > public string CommandText > { > get > { > return commands[actualCommand] == null ? "" : commands[actualCommand]; > } > set > { > if (statement != null && commandText != value && commandText != > String.Empty) > { > statement.DropStatement(); > } > > commandText = value; > commands = commandText.Split(terminatorChars); > actualCommand = 0; > } > } This piece of code do not match with actual CVS sources :) , i ask any more :) are you sure you are working with latest CVS sources ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain "No tengo dones especiales.Sólo soy apasionadamente curioso" Albert Einstein, científico. ------------------------------------------------------- This SF.net email is sponsored by: Etnus, makers of TotalView, The debugger for complex code. Debugging C/C++ programs can leave you feeling lost and disoriented. TotalView can help you find your way. Available on major UNIX and Linux platforms. Try it free. www.etnus.com _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Carlos G. A. <car...@te...> - 2003-04-11 12:38:44
|
Hello: > I've been looking at the source code :-) > > I see that you use an explicit ';' to split batch commands. This is > essentially the same problem that the ISQL SET TERM command solves. > > Here's a proposed modification to FbCommand.cs that adds a CommandTerminator > property to allow the user to set the command terminator to something other > than semi-colon: > > // added these fields > > private string terminator = ";" ; > private char[] terminatorChars = { ';' } ; > > // new property > > public string CommandTerminator > { > get { return terminator ; } > set > { > if ( terminator != value ) > { > terminator = value ; > terminatorChars = value.ToCharArray() ; > } > } > } Well in first place i think this is not needed. But what are people toughts to add this for 1.1 release ?? ( actual branch is feature closed, and after RC2 i'm thinking in open a new developement branch for 1.1 version of the provider with the modifications needed to run with .Net Framework 1.1 too ) > // modified CommandText > > /// <include file='xmldoc/fbcommand.xml' > path='doc/member[@name="P:CommandText"]/*'/> > public string CommandText > { > get > { > return commands[actualCommand] == null ? "" : commands[actualCommand]; > } > set > { > if (statement != null && commandText != value && commandText != > String.Empty) > { > statement.DropStatement(); > } > > commandText = value; > commands = commandText.Split(terminatorChars); > actualCommand = 0; > } > } This piece of code do not match with actual CVS sources :) , i ask any more :) are you sure you are working with latest CVS sources ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain "No tengo dones especiales.Sólo soy apasionadamente curioso" Albert Einstein, científico. |
From: Carlos G. A. <car...@te...> - 2003-04-11 12:34:34
|
Mike Scott wrote: > Hi Carlos > > I see that the code has lots of field initialisers. This is not a good idea > as the initialisation IL is duplicated by the C# compiler for each > constructor, and prefixed in front of each constructors code. > > In other words, if you have 4 constructors, the output file will have the > same code to initialise the fields repeated 4 times. > > This is obviously wasteful and bloats code unnecessarily. It is recommended > to initialise your fields in your default constructor, then have all the > constructors call base(). Huummmm, i have no notice about this :), are you sure about it ( i have started to make the change in my local tree but i want to be sure about this before commit it, but in any case i think this can be good ) -- Best regards Carlos Guzmán Álvarez Vigo-Spain "No tengo dones especiales.Sólo soy apasionadamente curioso" Albert Einstein, científico. |
From: Mike S. <mi...@mi...> - 2003-04-11 11:59:16
|
Carlos I've been looking at the source code :-) I see that you use an explicit ';' to split batch commands. This is essentially the same problem that the ISQL SET TERM command solves. Here's a proposed modification to FbCommand.cs that adds a CommandTerminator property to allow the user to set the command terminator to something other than semi-colon: // added these fields private string terminator = ";" ; private char[] terminatorChars = { ';' } ; // new property public string CommandTerminator { get { return terminator ; } set { if ( terminator != value ) { terminator = value ; terminatorChars = value.ToCharArray() ; } } } // modified CommandText /// <include file='xmldoc/fbcommand.xml' path='doc/member[@name="P:CommandText"]/*'/> public string CommandText { get { return commands[actualCommand] == null ? "" : commands[actualCommand]; } set { if (statement != null && commandText != value && commandText != String.Empty) { statement.DropStatement(); } commandText = value; commands = commandText.Split(terminatorChars); actualCommand = 0; } } Cheers, Mike. -----Original Message----- From: Carlos Guzman Alvarez [mailto:car...@te...] Sent: 11 April 2003 11:13 To: mi...@mi... Subject: Re: [Firebird-net-provider] Re: How to CREATE DATABASE using .Net FB Provider Hello: > But your last email suggested that you'd now got it to work with stored > procs. Here's some sample dialect 3 code to create a stored proc. Could you > try it and tell me how you got it to do it! :-) > > CREATE PROCEDURE "CreateUserKey" returns (AVALUE Integer) AS > begin > avalue = gen_id("UserID",1); > end You can do that using ExecuteNonQuery method, now batch command execution is restricted to ExecuteReader calls. A piece of code using your stored proc sample: FbConnection connection = new FbConnection(connectionString); connection.Open(); FbTransaction transaction = connection.BeginTransaction(); StringBuilder batchCommand = new StringBuilder(); batchCommand.Append( "CREATE PROCEDURE \"CreateUserKey\" returns (AVALUE Integer) AS \r\n" + "begin \r\n" + "\tavalue = gen_id(\"UserID\",1); \r\n" + "end"); FbCommand command = new FbCommand(batchCommand.ToString(), connection, transaction); command.ExecuteNonQuery(); command.Dispose(); transaction.Commit(); connection.Close(); > It seems that Firebird is using that semi-colon as a delimiter, so the only > way to get this to work is to change the delimiter, but I don't know how to > do that. It's not firebird it's the provider for allow batch command execution :) -- Best regards Carlos Guzmán Álvarez Vigo-Spain "No tengo dones especiales.Sólo soy apasionadamente curioso" Albert Einstein, científico. |
From: Carlos G. A. <car...@te...> - 2003-04-11 09:55:14
|
HEllo: > I'm still finding that your sample code you sent a few days ago gives: > > FbException: Dynamic SQL Error > SQL error code = -501 > Attempt to reclose a closed cursor There are a bug with my last commit ( yesterday ) it's fixed now, if you continue to have problems tell to me and i will send you a compiled version of the dll. -- Best regards Carlos Guzmán Álvarez Vigo-Spain "No tengo dones especiales.Sólo soy apasionadamente curioso" Albert Einstein, científico. |
From: Mike S. <mi...@mi...> - 2003-04-11 09:33:14
|
Hi Carlos I'm still finding that your sample code you sent a few days ago gives: FbException: Dynamic SQL Error SQL error code = -501 Attempt to reclose a closed cursor Here is the sample code exactly as I have it. If you have a moment, could you try it and see if it fails for you: File.Delete( @"c:\Temp\New.gdb" ) ; FbConnection.CreateDatabase( "localhost", 3050, @"c:\Temp\New.gdb", "SYSDBA", "masterkey", 3 ) ; FbConnection connection = new FbConnection(connectionString); connection.Open(); FbTransaction transaction = connection.BeginTransaction(); StringBuilder batchCommand = new StringBuilder(); batchCommand.Append("CREATE DOMAIN LOGICO AS SMALLINT DEFAULT 0;"); batchCommand.Append("CREATE DOMAIN NIF AS CHAR(10) DEFAULT '';"); batchCommand.Append("CREATE DOMAIN ID AS INTEGER DEFAULT 0"); FbCommand command = new FbCommand(batchCommand.ToString(), connection, transaction); FbDataReader reader = command.ExecuteReader(); while ( reader.NextResult() ) { } reader.Close(); transaction.Commit(); connection.Close(); Cheers, Mike. |
From: Carlos G. A. <car...@te...> - 2003-04-11 08:39:35
|
Hello: > All of the Interbase/Firebird connectivity components that I've used in the > past have supported SET TERM, and could also execute what I assumed to be a > DSQL script. > > Are you saying that these components must have interpreted the scripts > locally and made specific calls to Interbase? I can't tell you how they made because i can't see the sources, but yesterday i'm seeing IBConsole ( it's and application and not interface component but how i now that ibconsole allow to exec isql commands i see this ) sources of Firebird CVS and as i see (i don't see it in deep ) this made a parsing of the command. > What I want to do is have a complete script that creates my database and > sets up all the tables, stored procs, etc. so that I can run this either in > a tool such as IBExpert, or directly in my application both for unit testing > (current unit tests create the database fresh each run) and for > installation. > > Do you foresee a way of doing this with the .Net provider? Well you can make a little class for parse the script file and exec each command individually, i think it's not difficult task to do :) -- Best regards Carlos Guzmán Álvarez Vigo-Spain "No tengo dones especiales.Sólo soy apasionadamente curioso" Albert Einstein, científico. |
From: <car...@te...> - 2003-04-10 18:17:38
|
Hello: > The problem is that you cannot send a statement to create a trigger or other > stored procedure because the separator used by the stored proc code is a > semi-colon. Interbase has for years allowed you to change the separator with > the SET TERM statement. I'm reading interbase 6 beta documentation and SET TERM is isql command and it's not allowed in DSQL. > If you can't do that, then you can't create or edit > stored procs. Now with latest CVS sources you can, but not using an script. -- Best regards Carlos Guzmán Álvarez Vigo-Spain "No tengo dones especiales.Sólo soy apasionadamente curioso" Albert Einstein, científico. |
From: Carlos G.A. <car...@te...> - 2003-04-10 14:58:28
|
Hello: > For download the Redist see: > > http://www.microsoft.com/downloads/details.aspx?FamilyId=4C1B6B0B-439E-4DB4-849A-B72416F40300&displaylang=en This is bad :) sorry, it should be : http://www.microsoft.com/downloads/details.aspx?FamilyId=262D25E3-F589-4842-8157-034D1E7CF3A3&displaylang=en Best regards Carlos Guzman Alvarez Vigo-Spain |