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:
<car...@te...> - 2003-12-10 09:50:59
|
Hello: > I have a search screen (WinForm app) where I show the result in a > DataGrid. If the user enters some search criteria then the number of > records returned is less. But if the user doesn't specify anything all > records are returned and this slows down the server. What I want to > achieve is to have some kind of paging so that the DataGrid fetches only > records it can show in grid and then does another fetch when the user > scrolls. Is it possible? If yes, could anyone point me in the right > direction. I think you can try to do this using the FIRST/SKIP syntax of Firebird. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From:
<car...@te...> - 2003-12-10 09:50:55
|
Hello: > I have a search screen (WinForm app) where I show the result in a > DataGrid. If the user enters some search criteria then the number of > records returned is less. But if the user doesn't specify anything all > records are returned and this slows down the server. What I want to > achieve is to have some kind of paging so that the DataGrid fetches only > records it can show in grid and then does another fetch when the user > scrolls. Is it possible? If yes, could anyone point me in the right > direction. I think you can try to do this using the FIRST/SKIP sintax of Firebird. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Sandeep C. <sa...@cf...> - 2003-12-10 00:03:32
|
I have a search screen (WinForm app) where I show the result in a DataGrid. If the user enters some search criteria then the number of records returned is less. But if the user doesn't specify anything all records are returned and this slows down the server. What I want to achieve is to have some kind of paging so that the DataGrid fetches only records it can show in grid and then does another fetch when the user scrolls. Is it possible? If yes, could anyone point me in the right direction. Regards Sandeep |
From:
<car...@te...> - 2003-12-09 21:22:45
|
Thomas wrote: > Is it possible to define a firebird.log file with the FbLog Class ? > > It don't want to retrive the log file. I want to define it. > (define a file that the Firebird server must log to). No, it allows only to get the log contents. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Thomas <ja...@ma...> - 2003-12-09 20:09:54
|
Is it possible to define a firebird.log file with the FbLog Class ? It don't want to retrive the log file. I want to define it. (define a file that the Firebird server must log to). Thanks Regards Thomas |
From:
<car...@te...> - 2003-12-09 15:44:46
|
Hello: > Is it preferred that I close my connection every time I commit? > Or not? Huummm ... i think this depends on how you have designed your application, ( ADO.NET is designed for work in disconnect mode ), probably people working on real world applications using ADO.NET can give better answer on this :) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Thomas <ja...@ma...> - 2003-12-09 13:37:57
|
Hi Carlos Is it preferred that I close my connection every time I commit? Or not? Regards Thomas |
From: Thomas <ja...@ma...> - 2003-12-09 11:46:11
|
Hi Is it preferred that I close my connection every time I commit? Or not? Regards Thomas |
From:
<car...@te...> - 2003-12-08 18:49:53
|
Hello: > But there is still one question remaining. If I use a sqlDataAdapter of > C# I can right-click on it and then select fill Dataset to get a > Dataset, which is available for development and can be used to bind it > to controls or reports. With the Firebird-net-provider is this not > possible. How can I get a design time dataset to see and arrange the date ? > Is there any possibility to do that? No, design time support for the FbDataAdapter component is not implemented yet. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Oliver E. <oe...@en...> - 2003-12-08 16:35:14
|
Hi all, first of all thanks for the advices you gave me to my last questions. But there is still one question remaining. If I use a sqlDataAdapter of C# I can right-click on it and then select fill Dataset to get a Dataset, which is available for development and can be used to bind it to controls or reports. With the Firebird-net-provider is this not possible. How can I get a design time dataset to see and arrange the date ? Is there any possibility to do that? Thanks in advance Oliver |
From:
<car...@te...> - 2003-12-08 12:27:29
|
Hello: Firebird .NET Data Provider 1.5 Release Candidate 1 available for download. Release Changes: - Bug fixes. - Better fit to ADO.NET. - Improved blob reads. - Improved character sets handling. - Performance improvements. - Added support for Firebird-like connection strings, an example: Database=localhost/3050:D:\TESTDB.GDB;User=SYSDBA;Password=masterkey;Dialect=3;... --------------------------------------------------- You can download binarys for .NET 1.0 at: http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-RC1-NET1.0.exe?download You can download binarys for .NET 1.1 at: http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-RC1-NET1.1.exe?download You can download sources at: http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-RC1-Src.zip?download You can download documentation at: http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-RC1-Doc.zip?download CVS Tag: NP_1_5_RC1 -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Seymour N. <zs1...@ya...> - 2003-12-07 01:53:08
|
FUEL SAVER PRO This revolutionary device Boosts Gas Mileage 27%+ by helping fuel burn bet= ter using three patented processes from General Motors. www.eoei.com?axel=3D49 PROVEN TECHNOLOGY A certified U.S. Environmental Protection Agency (EPA) laboratory recently= completed tests on the new Fuel Saver. The results were astounding! Maste= r Service, a subsidiary of Ford Motor Company, also conducted extensive em= issions testing and obtained similar, unheard of results. The achievements= of the Fuel Saver is so noteworthy to the environmental community, that C= ommercial News has featured it as their cover story in their June, 2000 ed= ition. Take a test drive Today - www.eoei.com?axel=3D49 No more advertisements, thanks - http://www.5jzd.org/out5s/pre-rem2e.asp tm wh i xkp mkhwvuhpegmprfds rqhqmjwniy i gm nw fjde f |
From:
<car...@te...> - 2003-12-05 17:57:28
|
Hello: As 1.5 Release Candidate 1 is going to be released this weekend, or in the beginning of the next week, i am working yet in the next 1.6 source code, i have in mind to use a new directory structure, like this: + NETProvider_16 + documentation + examples + setup + Windows + Linux (**) + source + FirebirdSql.Data.Common + FirebirdSql.Data.Common.UnitTest (*) + FirebirdSql.Data.Embedded + FirebirdSql.Data.Embedded.UnitTest (*) + FirebirdSql.Data.Firebird + FirebirdSql.Data.Firebird.UnitTest (*) + FirebirdSql.Data.Gds + FirebirdSql.Data.Gds.UnitTest(*) (*) For sources of NUnit test suites. (**) If needed, for make an rpm or deb packages in the future. As always opinions are welcome. -- Best regards Carlos Guzmán Álvarez Vigo-Spain P.S: I have abstracted the actual GDS implementation in my 1.6 local tree, and i'm working yet in the PInvoke implementation for the embedded server. |
From:
<car...@te...> - 2003-12-04 11:22:32
|
Hello: > (4) FirebirdSql.Data.FbClient.dll As Pierre Arnaud has suggested to me i'm going to change this assembly name to: FirebirdSql.Data.Embedded.dll In first place i was thinking on use it for the fbclient.dll too but as the primary goal is to get support for the embedded server second name is more correct. For know which client assembly to use i will use a "ServerType" parameter in the connection string: * ServerType = 0 For Super Server and Classic Server using the pure C# GDS. * ServerType = 1 For Embedded server using the PInvoke GDS. As always opinions are very welcome. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From:
<car...@te...> - 2003-12-03 21:07:56
|
Hello: > It is possible to expect introduction of support of parallel transactions? > The server, as is known, allows it. Yes, Firebird allow it, but it's not allowed in ADO.NET. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Alexander H. <ale...@sa...> - 2003-12-03 18:11:07
|
Hi Carlos: Excuse me for bad English, but one more question. It is possible to expect introduction of support of parallel transactions? The server, as is known, allows it. Thanks... |
From:
<car...@te...> - 2003-12-03 12:46:12
|
Hello: > When, approximately, it will be realized? If finally i decide to implement it ;) , in 1.6 version. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Alexander H. <ale...@sa...> - 2003-12-03 12:34:52
|
Hello "Carlos Guzmán Álvarez" <car...@te...> schrieb im Newsbeitrag news:3F8...@te...... > Yes, this can be made using a new overload of the > > FbConnection.BeginTransaction method, it's another option. > When, approximately, it will be realized? Best regards |
From:
<car...@te...> - 2003-12-03 11:55:04
|
Hello: > Is this the right time to lay the groundwork for this design as you decide > how to arrange the assemblies and namespaces? Or am I getting way ahead of > myself? I think this would be of interest in the future, but at this moment, as i know, there are nothing decided on if this is really going to be implemented in the engine and if it's going to be made, nothing known about how it's going to be done, or there are anything decided yet ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Wendell W. <wjw...@ho...> - 2003-12-03 09:06:49
|
Hi, "Carlos Guzmán Álvarez" wrote: > With the need of give support to the embedded server i'm thinking in > redistribute the classes in some assemblys, for the next version, 1.6 or > 2.0 i have not decided it yet :), my first thought is : > I have been reading some posts on the Firebird-Architect list from 10/2003 regarding 'External "procedural engine" modules' and possible future directions for hosting the Java VM as a Stored Procedure execution environment. Is anyone else interested in hosting the .NET Runtime as an environment for Stored Procedures and Triggers? Has anyone considered how much of the existing C# code can be reused for such a project? I assume that part of it will have to be a managed C++ wrapper of some sort that hosts the runtime in the FB engine, but I have not looked into the details yet. I expect it will be a Win specific build of FB (perhaps post FB 1.5 after it is RC is done) since I'm not sure if Mono:: is ready to be hosted like this yet on linux. I'm relatively new to Firebird and have not examined its internal design a lot, but I am not new to programming and could brush up my C++ skills of old if time allowed. Is this the right time to lay the groundwork for this design as you decide how to arrange the assemblies and namespaces? Or am I getting way ahead of myself? Sincerely, Wendell Wilkie |
From:
<car...@te...> - 2003-12-02 19:46:15
|
Hello: With the need of give support to the embedded server i'm thinking in redistribute the classes in some assemblys, for the next version, 1.6 or 2.0 i have not decided it yet :), my first thought is : (1) FirebirdSql.Data.Firebird.dll With ADO.NET classes. (2) FirebirdSql.Data.Common.dll With common classes for all GDS implementations (3) FirebirdSql.Data.Gds.dll Witch classes for the native C# GDS implementation. (4) FirebirdSql.Data.FbClient.dll Witch classes for the PInvoke GDS implementation. Opinions are wellcome!!! :D -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Miha M. <miham@NO!SPAM.spin.si> - 2003-12-02 19:30:46
|
Hi Carlos, It is ok by me. You have my approval ;-) I am not a speed freak - rather have a reasonable working version. -- Miha Markic - RightHand .NET consulting & development miha at rthand com "Carlos Guzmán Álvarez" <car...@te...> wrote in message news:bqftkk$1fr$1...@ne...... > Hello: > > I have made a little test ( at the end of this email ) with embedded > server using PInvoke, it's a very simple test but it's working ( it's > not using ADO.NET yet ;) ). > > Pierre Arnaud told to me some time ago that PInvoke has some performance > penalties but i have decided to start the tests with PInvoke for 3 reasons: > > 1. It can be used in mono::, this will allow to use it in linux, > and i think this is a very interesting issue. > > 2. As the embedded server works only in local i think that if the > performance penalty is not great, we can assume it. > > 3. It's much more easy for me than write a wrapper in C++ :D |
From: Thomas <ja...@ma...> - 2003-12-02 18:54:49
|
Hi Carlos I am really looking forward to the support of the embedded database. I don't have big knowledge about PInvoke, so I cannot comment your post. Regards Thomas |
From: Josauro S.J. <jo...@ca...> - 2003-12-02 18:23:33
|
Carlos I found the error, sorry my key in table RECIBO is numeric 18.0 and in = procedure GET_RECIBO I get parameter numeric 15.2 Feed back selectCmd =3D "GET_RECIBO"=20 don't work in my instalation, I need to put SELECT * FROM GET_RECIBO. In procedure don't need to put FOR ....DO.. Tank's...=20 Josauro S.J. Diretor e-mail: jo...@ca... site: www.casasoft.inf.br Portal de im=F3veis www.IndicadorDeImoveis.com.br O =FAnico Portal de im=F3veis 100% on-line com as imobili=E1rias, = im=F3veis atualizados minuto a minuto a certeza de que o im=F3vel = anunciado realmente esta Dispon=EDvel. ----- Original Message -----=20 From: Carlos Guzm=E1n =C1lvarez=20 To: Josauro S.J.=20 Cc: fir...@li...=20 Sent: Tuesday, December 02, 2003 3:27 PM Subject: Re: [Firebird-net-provider] I need to return only one record = to a DataSet Hello: > It's a new problema, the last work fine (To return many record's) . > this problem is than I execute a procedure to get one record but it=20 > return nothing in a dataset, if a execute in IBExpert with the same = key=20 > it's return one record. > Look at the list above to see some problem? Ok, Can you try it to change this: selectCmd =3D "EXECUTE PROCEDURE GET_RECIBO(@REC_CODIGO)" with selectCmd =3D "GET_RECIBO" and with this SP please. CREATE PROCEDURE GET_RECIBO ( REC_CODIGO NUMERIC(15,2)) RETURNS ( REC_CLIENTE NUMERIC(15,2), REC_DATA DATE, REC_DATA_LIMITE DATE, REC_VALOR_ALUGUEL NUMERIC(15,2), REC_VALOR_TAXA NUMERIC(15,2), REC_VALOR_MULTA_DESCONTO NUMERIC(15,2), VR_VALOR_LIQUIDO NUMERIC(15,2), VR_VALOR_BRUTO NUMERIC(15,2), REC_DESCRICAO_PERIODO VARCHAR(40), REC_NUMERO_RECIBO INTEGER, REC_NUMERO_BANCARIO VARCHAR(15)) AS DECLARE VARIABLE VR_MULTA_DESCONTO CHAR(1); BEGIN /* Procedure Text */ FOR SELECT REC_CLIENTE, REC_DATA, REC_DATA_LIMITE, REC_VALOR_ALUGUEL, REC_VALOR_TAXA, REC_MULTA_DESCONTO, REC_VALOR_MULTA_DESCONTO, REC_DESCRICAO_PERIODO, REC_NUMERO_RECIBO, REC_NUMERO_BANCARIO FROM RECIBO WHERE REC_CODIGO =3D :REC_CODIGO INTO :REC_CLIENTE, :REC_DATA, :REC_DATA_LIMITE, :REC_VALOR_ALUGUEL, :REC_VALOR_TAXA, :VR_MULTA_DESCONTO, :REC_VALOR_MULTA_DESCONTO, :REC_DESCRICAO_PERIODO, :REC_NUMERO_RECIBO, :REC_NUMERO_BANCARIO DO BEGIN IF (VR_MULTA_DESCONTO =3D 'D') THEN BEGIN VR_VALOR_BRUTO =3D :REC_VALOR_ALUGUEL + :REC_VALOR_TAXA; VR_VALOR_LIQUIDO =3D VR_VALOR_BRUTO - REC_VALOR_MULTA_DESCONTO; END ELSE BEGIN VR_VALOR_BRUTO =3D :REC_VALOR_ALUGUEL + :REC_VALOR_TAXA + :REC_VALOR_MULTA_DESCONTO; VR_VALOR_LIQUIDO =3D VR_VALOR_BRUTO - :REC_VALOR_MULTA_DESCONTO; END SUSPEND; END END -- Best regards Carlos Guzm=E1n =C1lvarez Vigo-Spain |
From:
<car...@te...> - 2003-12-02 17:27:13
|
Hello: > It's a new problema, the last work fine (To return many record's) . > this problem is than I execute a procedure to get one record but it > return nothing in a dataset, if a execute in IBExpert with the same key > it's return one record. > Look at the list above to see some problem? Ok, Can you try it to change this: selectCmd = "EXECUTE PROCEDURE GET_RECIBO(@REC_CODIGO)" with selectCmd = "GET_RECIBO" and with this SP please. CREATE PROCEDURE GET_RECIBO ( REC_CODIGO NUMERIC(15,2)) RETURNS ( REC_CLIENTE NUMERIC(15,2), REC_DATA DATE, REC_DATA_LIMITE DATE, REC_VALOR_ALUGUEL NUMERIC(15,2), REC_VALOR_TAXA NUMERIC(15,2), REC_VALOR_MULTA_DESCONTO NUMERIC(15,2), VR_VALOR_LIQUIDO NUMERIC(15,2), VR_VALOR_BRUTO NUMERIC(15,2), REC_DESCRICAO_PERIODO VARCHAR(40), REC_NUMERO_RECIBO INTEGER, REC_NUMERO_BANCARIO VARCHAR(15)) AS DECLARE VARIABLE VR_MULTA_DESCONTO CHAR(1); BEGIN /* Procedure Text */ FOR SELECT REC_CLIENTE, REC_DATA, REC_DATA_LIMITE, REC_VALOR_ALUGUEL, REC_VALOR_TAXA, REC_MULTA_DESCONTO, REC_VALOR_MULTA_DESCONTO, REC_DESCRICAO_PERIODO, REC_NUMERO_RECIBO, REC_NUMERO_BANCARIO FROM RECIBO WHERE REC_CODIGO = :REC_CODIGO INTO :REC_CLIENTE, :REC_DATA, :REC_DATA_LIMITE, :REC_VALOR_ALUGUEL, :REC_VALOR_TAXA, :VR_MULTA_DESCONTO, :REC_VALOR_MULTA_DESCONTO, :REC_DESCRICAO_PERIODO, :REC_NUMERO_RECIBO, :REC_NUMERO_BANCARIO DO BEGIN IF (VR_MULTA_DESCONTO = 'D') THEN BEGIN VR_VALOR_BRUTO = :REC_VALOR_ALUGUEL + :REC_VALOR_TAXA; VR_VALOR_LIQUIDO = VR_VALOR_BRUTO - REC_VALOR_MULTA_DESCONTO; END ELSE BEGIN VR_VALOR_BRUTO = :REC_VALOR_ALUGUEL + :REC_VALOR_TAXA + :REC_VALOR_MULTA_DESCONTO; VR_VALOR_LIQUIDO = VR_VALOR_BRUTO - :REC_VALOR_MULTA_DESCONTO; END SUSPEND; END END -- Best regards Carlos Guzmán Álvarez Vigo-Spain |