Menu
▾
▴
firebird-net-provider — All about development of the MS .Net provider
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: Carlos G. A. <car...@te...> - 2003-10-01 14:13:58
|
Hello: > I try use "select * from AREAS; select * from PROJECTS"; > ant it works , just I must use table mapping for name Table and Table1 to my > needed tables. > > I thing that colum mapping must work to for select. > I look for some examples on the net and column mapping is use for select > too. I have reviewing this now :) i'm going to make tests using SqlClient provider too > Could you write me if is any problem with build NetProvider15? > I just get source from VCS and I cann't build version using build.bat As i tell yestarday i'm in the process of change the build system, but i have downloaded the latest cvs source ( using SSH not pserver ) and all is working fine for me. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Martin R. <ne...@mi...> - 2003-10-01 13:41:37
|
Thanks Carlos, I try use "select * from AREAS; select * from PROJECTS"; ant it works , just I must use table mapping for name Table and Table1 to my needed tables. I thing that colum mapping must work to for select. I look for some examples on the net and column mapping is use for select too. Could you write me if is any problem with build NetProvider15? I just get source from VCS and I cann't build version using build.bat Thanks Martin |
|
From: Carlos G. A. <car...@te...> - 2003-10-01 12:32:21
|
Hello: > After this I get in result table with 4 columns coUcet,UCET,coPopis,POPIS. > Is it a bug or I do something wrong? I have reviewed the documentation of DataAapter,TableMappings and seems to be used on table updating only, i will try to review it more later today. > And one question moore. > How I can make Command for make more than one datatable? > Like > FillTbl.CommandText="SELECT UCET ,POPIS FROM LUCTY; SELECT ABC ,DEF FROM > LTABLE"; If you are using 1.5 version you will need CVS sources, i have committed a fix today for NextResult method. I have made a little test using this ( i will try to add a nunit test case today too ): string sql = "select * from AREAS; select * from PROJECTS"; FbCommand command = new FbCommand(sql, connection, transaction); FbDataAdapter adapter = new FbDataAdapter(command); DataSet ds = new DataSet(); adapter.Fill(ds); Console.WriteLine(ds.Tables[0].Rows.Count); Console.WriteLine(ds.Tables[1].Rows.Count); -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Martin R. <ne...@mi...> - 2003-10-01 11:56:23
|
Hi,
I need use fbDataAdapter mappings, but Ii can't work.
This is my code:
LUCTY is table in database
UCTY is table in dataset
daFill.TableMappings.Add("LUCTY","UCTY");
daFill.TableMappings["LUCTY"].ColumnMappings.Add("coUcet","UCET");
daFill.TableMappings["LUCTY"].ColumnMappings.Add("coPopis","POPIS");
FillTbl.CommandText="SELECT UCET ,POPIS FROM LUCTY";
daFill.Fill(dsLookup,"UCTY");
After this I get in result table with 4 columns coUcet,UCET,coPopis,POPIS.
Is it a bug or I do something wrong?
And one question moore.
How I can make Command for make more than one datatable?
Like
FillTbl.CommandText="SELECT UCET ,POPIS FROM LUCTY; SELECT ABC ,DEF FROM
LTABLE";
Best regards Martin Radvansky
|
|
From: Carlos G. A. <car...@te...> - 2003-09-30 19:52:06
|
Hello: I'm in the process of rework the build system for Windows until i have finished it there can be some problem with the build system in the CVS ;) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Carlos G. A. <car...@te...> - 2003-09-30 13:58:22
|
Hello: > Just saw it and it seems to work great! :) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Luciano P. <pas...@on...> - 2003-09-30 12:55:03
|
Just saw it and it seems to work great!=20 Regards. Luciano. -----Original Message----- From: fir...@li... [mailto:fir...@li...] On Behalf Of Carlos Guzman Alvarez Sent: Tuesday, September 30, 2003 6:51 AM To: Firebird .Net Provider Subject: Re: [Firebird-net-provider] Re: Serialization of FbCommand.Parameters at design-time Hello: > The FbParameterCollection designer is on CVS yet :) but it's not=20 > finished i will try to finish it tomorrow. Latest changes are in CVS yet. -- Best regards Carlos Guzm=E1n =C1lvarez Vigo-Spain ------------------------------------------------------- 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-09-30 09:51:19
|
Hello: > The FbParameterCollection designer is on CVS yet :) but it's not > finished i will try to finish it tomorrow. Latest changes are in CVS yet. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Carlos G. A. <car...@te...> - 2003-09-29 19:36:08
|
Hello: > How this doesn't broke anything in the existing code ( developement of > new features is frezee ) i have added a new FbParameterConverter class > for allow automatic code generation at design time but this seems to be > not enough, if i'm not wrong a custom editor is needed for > FbParameterCollection class i will try to see this but not sure about > when ;) The FbParameterCollection designer is on CVS yet :) but it's not finished i will try to finish it tomorrow. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Carlos G. A. <car...@te...> - 2003-09-29 18:08:14
|
Hello: I'm thinking on remove ( adding comments ) FbCommand.CursorName property from 1.5 sources, but i want to know first if there are anybody using it ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Carlos G. A. <car...@te...> - 2003-09-29 15:35:41
|
Hello: > I checked the latest CVS and this doesn't seem to be fixed yet. > I create a list of parameters in the command control, and it does not get > serialized in code. > > I made a bit of investigation, and found out that this is more complex that > one might think. For information, see: > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm > l/cpconimplementingtypeconverter.asp > (session: "Type Converters That Generate Code for Property Initialization at > Run Time") > > Let me know if you intend to implement this. If not, maybe I can use some of > my spare time trying to do it. How this doesn't broke anything in the existing code ( developement of new features is frezee ) i have added a new FbParameterConverter class for allow automatic code generation at design time but this seems to be not enough, if i'm not wrong a custom editor is needed for FbParameterCollection class i will try to see this but not sure about when ;) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Carlos G. A. <car...@te...> - 2003-09-29 11:37:09
|
Hello: > I think this makes a lot of sense. > > How does it work today? Is the command implicitly associated with the > current pending transaction? Now ( in version 1.5 ) a implicit transaction is started always when the command has no transaction assigned. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Carlos G. A. <car...@te...> - 2003-09-29 09:46:14
|
Hello: > Is there gonna be an exe installation of the converted data provider for > firebird? There are no version 2.0 of the .NET Data Provider, actual development version is 1.5 you can find install packages at sourceforge: http://sourceforge.net/project/showfiles.php?group_id=9028&release_id=185393 -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Lee C. <lee...@ad...> - 2003-09-29 06:57:07
|
Hi Carlos, Is there gonna be an exe installation of the converted data provider for firebird? thanks |
|
From: Luciano P. <pas...@on...> - 2003-09-28 15:16:51
|
I think this makes a lot of sense. How does it work today? Is the command implicitly associated with the current pending transaction? -----Original Message----- From: fir...@li... [mailto:fir...@li...] On Behalf Of Carlos Guzman Alvarez Sent: Saturday, September 27, 2003 9:31 PM To: Firebird .Net Provider Subject: [Firebird-net-provider] Question about implicit transaction = support Hello: I'm making some tests using MSDE and SqlClient because i'm thinking on = make changes to the command builder for generate commands in the same way as SqlClient, testing this i have noticed that SqlClient doesn't allow to execute commands without a transaction when the connection have a = pending transaction and i'm thinking on change this in the Firbeird Provider for work in the same way, what do you think ?? -- Best regards Carlos Guzm=E1n =C1lvarez Vigo-Spain ------------------------------------------------------- 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-09-28 00:32:27
|
Hello: I'm making some tests using MSDE and SqlClient because i'm thinking on make changes to the command builder for generate commands in the same way as SqlClient, testing this i have noticed that SqlClient doesn't allow to execute commands without a transaction when the connection have a pending transaction and i'm thinking on change this in the Firbeird Provider for work in the same way, what do you think ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Carlos G. A. <car...@te...> - 2003-09-27 13:46:22
|
Hello: > This is an know issue for me but at this moment i don't know how to > solve it ;) I have committed into the CVS a change in FbParameter class that i think would be of help on this. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Carlos G. A. <car...@te...> - 2003-09-27 11:07:37
|
Hello: > When you say this is the expected behavior do you mean it's a known bug? It's not a bug, CommandTimeout is not implemented because it's not supported by Firebird ( the exception raised is an NotSupportedException ). > Also, playing a little more with 1.5, I noticed that the Parameters property > in the FbCommand does not get persisted (if I save and reopen the project, > it's all gone). This is an know issue for me but at this moment i don't know how to solve it ;) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Luciano P. <pas...@on...> - 2003-09-27 01:02:01
|
It does work in 1.5 if I don't touch the property in the designer. If I touch it, I get the same exception at design time. When you say this is the expected behavior do you mean it's a known bug? Also, playing a little more with 1.5, I noticed that the Parameters = property in the FbCommand does not get persisted (if I save and reopen the = project, it's all gone). Are these already known bugs?=20 Thanks! Luciano. -----Original Message----- From: fir...@li... [mailto:fir...@li...] On Behalf Of Carlos Guzman Alvarez Sent: Friday, September 26, 2003 7:36 PM To: fir...@li... Subject: Re: [Firebird-net-provider] Problem setting CommandTimeOut in FbCommand at design-time Hello: > I added the Firebird components in the Visual Studio toolbox, so I can = > configure their properties using the design-time property window. > =20 > All goes fine, except when I try to configure the CommandTimeOut=20 > propery in the FbCommand. > It generates an exception saying that the "method is not implemented". This is expected behavior if you modfiy the property. > =20 > Even if I don't touch the property at design time, the expection is=20 > generated at runtime when the assembly is loaded. > Is this a bug? If i'm not wrong this is fixed in version 1.5 of the .NET Data Provider. -- Best regards Carlos Guzm=E1n =C1lvarez Vigo-Spain ------------------------------------------------------- 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-09-26 22:37:28
|
Hello: > I added the Firebird components in the Visual Studio toolbox, so I can > configure their properties using the design-time property window. > > All goes fine, except when I try to configure the CommandTimeOut propery in > the FbCommand. > It generates an exception saying that the "method is not implemented". This is expected behavior if you modfiy the property. > > Even if I don't touch the property at design time, the expection is > generated at runtime when the assembly is loaded. > Is this a bug? If i'm not wrong this is fixed in version 1.5 of the .NET Data Provider. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Luciano P. <pas...@on...> - 2003-09-26 21:48:11
|
I added the Firebird components in the Visual Studio toolbox, so I can configure their properties using the design-time property window. All goes fine, except when I try to configure the CommandTimeOut propery in the FbCommand. It generates an exception saying that the "method is not implemented". Even if I don't touch the property at design time, the expection is generated at runtime when the assembly is loaded. Is this a bug? FYI, I'm using firebird-net-provider 1.0 for 1.1 framework. Thanks in advance!! Luciano. |
|
From: Carlos G. A. <car...@te...> - 2003-09-26 10:00:04
|
Hello: > I'm going to make a test using this in the ORDER BY clausule : > > rdb$procedure_name > rdb$parameter_type > rdb$parameter_number Change is in CVS yet. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Carlos G. A. <car...@te...> - 2003-09-26 09:16:51
|
Hello:
> When I use the function "FbCommandBuilder.DeriveParameters(command)" to get
> the parameters of a Stored Procedure, I expected to have the input
> parameters before and after the output parameters, but the parameters are
> mixed. For instance for a stored procedure with several input parameters and
> with one output parameter, as first I find the first input parameter
> followed by the output parameter and then the other input paramaters.
>
> Is this the correct behaviour?
If you are using version 1.5 it can be :) i'm using this to retrieve
parameter information:
DataTable spSchema =
command.Connection.GetDbSchemaTable(FbDbSchemaType.Procedure_Parameters,
new object[] {command.CommandText});
This execs a select against rdb$procedure_parameter table ordered by:
rdb$procedure_name
rdb$parameter_number
I'm going to make a test using this in the ORDER BY clausule :
rdb$procedure_name
rdb$parameter_type
rdb$parameter_number
--
Best regards
Carlos Guzmán Álvarez
Vigo-Spain
|
|
From: Jack <sof...@di...> - 2003-09-26 07:46:01
|
Hello, When I use the function "FbCommandBuilder.DeriveParameters(command)" to get the parameters of a Stored Procedure, I expected to have the input parameters before and after the output parameters, but the parameters are mixed. For instance for a stored procedure with several input parameters and with one output parameter, as first I find the first input parameter followed by the output parameter and then the other input paramaters. Is this the correct behaviour? Thanks, Jack |
|
From: Mark E. S. Jr. <ms...@sc...> - 2003-09-25 14:13:36
|
I haven't found any good OleDB driver. They all seem to be broken to one extent or another. =20 Mark E. Scott Jr. ms...@sc... =20 -----Original Message----- From: Luciano Passuello [mailto:pas...@on...]=20 Sent: Thursday, September 25, 2003 8:35 AM To: fir...@li... Subject: [Firebird-net-provider] Schema generation on Visual Studio =20 Hi all. =20 Sorry if this is off-topic, but since I believe a lot of people here are using Visual Studio for development, you can problably answer. =20 Does anyone have experience generating xsd schemas based on Firebird databases? I tried using a couple of OleDB drivers for Firebird in order to use the "Server Explorer" window and drag-n-drop tables to the schema, but I always get errors using these drivers.=20 Does anyone know a way of doing that?=20 =20 Maybe there's a way of doing this using the provider, and not rely on other connectivity drivers (OLEDB) ? =20 If you know a better list to be sending these messages to, please let me know. Thanks in advance!! =20 Luciano. |
211 messages has been excluded from this view by a project administrator.
