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: JS.staff <jsp...@ec...> - 2004-04-16 14:31:16
|
RG9uJ3Qga25vdyBpZiB0aGlzIGlzIGEgYnVnIG9yIGp1c3QgZXhwZWN0ZWQgYmVoYXZpb3VyOg0K IA0KSSBoYXZlIGEgRmJDb21tYW5kIG9iamVjdCBJJ20gdXNpbmcgaW4gdHdvIHRocmVhZHMuIE5v cm1hbGx5IGl0J3MgdXNlZCBpbiB0aGUgbWFpbiB0aHJlYWQsIGJ1dCBzb21ldGltZXMgSSBuZWVk IHRvIHNwYXduIGFub3RoZXIgdGhyZWFkLCB3aGljaCBvZiBjb3Vyc2UgY29udGFpbnMgaXQncyBv d24gY29ubmVjdGlvbiBhbmQgdHJhbnNhY3Rpb24gb2JqZWN0cy4gSG93ZXZlciBJIHVzZSB0aGUg c2FtZSBGYkNvbW1hbmQgb2JqZWN0IGluIHRoaXMgY2hpbGQgdGhyZWFkIChyZWFzc2lnbmluZyBj b25uZWN0aW9uIGFuZCB0cmFuc2FjdGlvbikuDQogDQpKdXN0IHRvIGNsYXJpZnksIEkgKm5ldmVy KiB1c2UgdGhlIEZiQ29tbWFuZCBvYmplY3QgaW4gYm90aCB0aHJlYWRzIHNpbXVsdGFuaW91c2x5 LiBUaGlzIGNvdWxkbid0IGhhcHBlbiB3aXRoIHRoZSBwcm9ncmFtIGRlc2lnbi4NCiANCk9uIGEg c2luZ2xlLUNQVSBtYWNoaW5lIGl0IHdvcmtzIGZpbmUsIGJ1dCBvbiBhIGR1YWwtQ1BVIHN5c3Rl bSBJIGdldCBhbiBleGNlcHRpb24gKCdHZHNFcnJvcicpIGZyb20gdGhlIGNoaWxkIHRocmVhZC4N CiANCkkgd29ya2VkIGFyb3VuZCB0aGUgcHJvYmxlbSBieSBhc3NpZ25pbmcgDQogDQpjb21tYW5k LlRyYW5zYWN0aW9uID0gbnVsbDsNCmNvbW1hbmQuQ29ubmVjdGlvbiA9IG51bGw7DQogDQpJbiB0 aGUgcGFyZW50IHRocmVhZCwgYmVmb3JlIHN0YXJ0aW5nIHRoZSBjaGlsZCB0aHJlYWQuDQogDQpT aG91bGQgSSBoYXZlIHRvIGRvIHRoaXM/IG1heWJlIHRoZSBwYXJlbnQgdGhyZWFkIGlzIGRvaW5n IHNvbWV0aGluZyB0byBGYkNvbW1hbmQgb2JqZWN0IHdoZW4gdGhlIHBhcmVudCB0cmFuc2FjdGlv biBpcyBjb21taXR0ZWQsIHdoaWNoIGlzIHNjcmV3aW5nIHVwIHRoZSBvcGVyYXRpb24gb2Y6DQog DQpjb21tYW5kLlRyYW5zYWN0aW9uID0gbXlzZWNvbmR0cmFuczsNCiANCmluIHRoZSBjaGlsZCB0 aHJlYWQ/Pz8NCiANClRoYW5rcywNCiANCkpvaG4NCg== |
From: JS.staff <jsp...@ec...> - 2004-04-16 14:31:15
|
RmlyZWJpcmQgZG9lc24ndCBkbyAndGltZW91dHMnISBJIHRoaW5rIElCNyBhZGRlZCBzdXBwb3J0 IGZvciB0aGlzLi4uIG1heWJlIGl0J3Mgc29tZXRoaW5nIHRoYXQgd2lsbCBhcHBlYXIgaW4gRkIy Pw0KIA0KSm9obg0KDQoJLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0gDQoJRnJvbTogU2FtIE1h Y2tyaWxsIFttYWlsdG86c2FtLm1hY2tyaWxsQGNsaWNrc3RyZWFtLmNvbV0gDQoJU2VudDogRnJp IDE2LzA0LzIwMDQgMTQ6NTAgDQoJVG86IGZpcmViaXJkLW5ldC1wcm92aWRlckBsaXN0cy5zb3Vy Y2Vmb3JnZS5uZXQgDQoJQ2M6IA0KCVN1YmplY3Q6IFtGaXJlYmlyZC1uZXQtcHJvdmlkZXJdIEZC Q29tbWFuZC5Db21tYW5kVGltZW91dCBub3Qgc2V0YWJsZVtTY2FubmVkXQ0KCQ0KCQ0KDQoJVGhp cyBpcyB3aXRoIDEuNS4yDQoJQWNjb3JkaW5nIHRvIHRoZSBkb2NzIEkgc2hvdWxkIGJlIGFibGUg dG8gc2V0IENvbW1hbmRUaW1lb3V0IGJ1dCBpdCByYWlzZXMNCgl0aGUgZm9sbG93aW5nIGV4Y2Vw dGlvbiB3aGVuIEkgdHJ5Og0KCQ0KCUEgZmlyc3QgY2hhbmNlIGV4Y2VwdGlvbiBvZiB0eXBlICdT eXN0ZW0uTm90U3VwcG9ydGVkRXhjZXB0aW9uJyBvY2N1cnJlZCBpbg0KCWZpcmViaXJkc3FsLmRh dGEuZmlyZWJpcmQuZGxsDQoJQWRkaXRpb25hbCBpbmZvcm1hdGlvbjogU3BlY2lmaWVkIG1ldGhv ZCBpcyBub3Qgc3VwcG9ydGVkLg0KCQ0KCUhlcmUgaXMgbXkgY29kZToNCgkNCglwcm90ZWN0ZWQg b2JqZWN0IEV4ZWN1dGVTY2FsYXIoc3RyaW5nIGNvbW1hbmQsIGJvb2wgdHJhbnNhY3Rpb25hbCwg Ym9vbA0KCWZyZWUpDQoJew0KCSAgdHJ5DQoJICB7DQoJICAgIEdldENtZCh0cmFuc2FjdGlvbmFs KTsNCgkgICAgaWYgKCFjb21tYW5kLkVuZHNXaXRoKCI7IikpDQoJICAgIHsNCgkgICAgICBjb21t YW5kICs9ICI7IjsNCgkgICAgfQ0KCSAgICBDbWQuQ29tbWFuZFRpbWVvdXQgPSA2MDA7DQoJICAg IENtZC5Db21tYW5kVGV4dCA9IGNvbW1hbmQ7DQoJICAgIHJldHVybiBDbWQuRXhlY3V0ZVNjYWxh cigpOw0KCSAgfQ0KCSAgZmluYWxseQ0KCSAgew0KCSAgICBpZiAoZnJlZSkNCgkgICAgew0KCSAg ICAgIEZyZWVDbWQoKTsNCgkgICAgfQ0KCSAgfQ0KCX0NCgkNCglLZWVwLXVwIHRoZSBncmVhdCB3 b3JrIENhcmxvcw0KCVRoYW5rcyENCgkNCglTYW0NCglfX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fDQoJTGEgbGxhbWEgZGUgbWUgbGxhbWEgc2UgbGxhbWEgTmln ZWwNCgkNCgkNCgkNCgkNCgktLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tDQoJVGhpcyBTRi5OZXQgZW1haWwgaXMgc3BvbnNvcmVkIGJ5OiBJQk0g TGludXggVHV0b3JpYWxzDQoJRnJlZSBMaW51eCB0dXRvcmlhbCBwcmVzZW50ZWQgYnkgRGFuaWVs IFJvYmJpbnMsIFByZXNpZGVudCBhbmQgQ0VPIG9mDQoJR2VuVG9vIHRlY2hub2xvZ2llcy4gTGVh cm4gZXZlcnl0aGluZyBmcm9tIGZ1bmRhbWVudGFscyB0byBzeXN0ZW0NCglhZG1pbmlzdHJhdGlv bi5odHRwOi8vYWRzLm9zZG4uY29tLz9hZF9pZD0xNDcwJmFsbG9jX2lkPTM2Mzgmb3A9Y2xpY2sN CglfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXw0KCUZpcmVi aXJkLW5ldC1wcm92aWRlciBtYWlsaW5nIGxpc3QNCglGaXJlYmlyZC1uZXQtcHJvdmlkZXJAbGlz dHMuc291cmNlZm9yZ2UubmV0DQoJaHR0cHM6Ly9saXN0cy5zb3VyY2Vmb3JnZS5uZXQvbGlzdHMv bGlzdGluZm8vZmlyZWJpcmQtbmV0LXByb3ZpZGVyDQoJDQoJDQoNCg== |
From: Sam M. <sam...@cl...> - 2004-04-16 13:50:25
|
This is with 1.5.2 According to the docs I should be able to set CommandTimeout but it raises the following exception when I try: A first chance exception of type 'System.NotSupportedException' occurred in firebirdsql.data.firebird.dll Additional information: Specified method is not supported. Here is my code: protected object ExecuteScalar(string command, bool transactional, bool free) { try { GetCmd(transactional); if (!command.EndsWith(";")) { command += ";"; } Cmd.CommandTimeout = 600; Cmd.CommandText = command; return Cmd.ExecuteScalar(); } finally { if (free) { FreeCmd(); } } } Keep-up the great work Carlos Thanks! Sam ______________________________________________ La llama de me llama se llama Nigel |
From:
<car...@te...> - 2004-04-15 21:29:34
|
Hello: >The following code throws an error: > >FbCommand cmd = null; >try { >FbConnection connection = new Connection(_connString); >cmd = connection.CreateCommand(); >cmd.CommandText = selectstring; >reader = cmd.ExecuteReader(); >} >catch (Exception ) {} >finally { > if(cmd!=null) > cmd.Dispose(); >} > > I have a fix in my local tree yet, but that code is not correct ;) can you try with this: FbConnection connection = new FbConnection(connectionString); FbCommand cmd = null; FbDataReader reader = null; try { connection.Open(); cmd = connection.CreateCommand(); cmd.CommandText = "SELECT * FROM tableName"; reader = cmd.ExecuteReader(); } catch (Exception) {} finally { if (reader != null) { reader.Close(); } if (cmd != null) { cmd.Dispose(); } connection.Close(); } -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Timothy S. <tim...@ya...> - 2004-04-15 20:46:18
|
The following code throws an error: FbCommand cmd = null; try { FbConnection connection = new Connection(_connString); cmd = connection.CreateCommand(); cmd.CommandText = selectstring; reader = cmd.ExecuteReader(); } catch (Exception ) {} finally { if(cmd!=null) cmd.Dispose(); } The error is thrown on the Dispose() method with the following message: Object reference not set to an instance of an object. Upon further investigation, I have found that this is because there is no Transaction object in the FbCommand. If I just put one in there, it works fine. I did not think that it was necessary for queries to require transaction objects. Is this expected behavior? -Tim __________________________________ Do you Yahoo!? Yahoo! Tax Center - File online by April 15th http://taxes.yahoo.com/filing.html |
From: Nico C. <nc...@pa...> - 2004-04-15 20:37:12
|
Hi Carlos, Thanks for your answer. I started with Visual Studio, but now I switched to SharpDevelop, the free IDE. Thanks, Nico ----- Original Message -----=20 From: "Carlos Guzm=E1n =C1lvarez" <car...@te...> To: "Nico Callewaert" <nc...@pa...> Cc: <fir...@li...> Sent: Thursday, April 15, 2004 9:42 PM Subject: Re: [Firebird-net-provider] Newbie > Hello: > > > Is there a article available how to set up a connection to Firebir= d from > >C# ? > > > > > > No, but 1.5 ships with some little samples, are you using an IDE ?? if > yes, what ?? > > You can review the help of the FbConnection class too. > > > > > > > -- > Best regards > > Carlos Guzm=E1n =C1lvarez > Vigo-Spain > > > ------------------------------------------------------- > This SF.Net email is sponsored by: IBM Linux Tutorials > Free Linux tutorial presented by Daniel Robbins, President and CEO of > GenToo technologies. Learn everything from fundamentals to system > administration.http://ads.osdn.com/?ad_id=3D1470&alloc_id=3D3638&op=3Dc= lick > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
From:
<car...@te...> - 2004-04-15 19:42:49
|
Hello: > Is there a article available how to set up a connection to Firebird from >C# ? > > No, but 1.5 ships with some little samples, are you using an IDE ?? if yes, what ?? You can review the help of the FbConnection class too. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Nico C. <nc...@pa...> - 2004-04-15 18:50:08
|
Hi, Is there a article available how to set up a connection to Firebird from C# ? Thanks ! Nico Callewaert |
From:
<car...@te...> - 2004-04-15 14:26:45
|
Hello: >using the OleDbDataReader, if the reader has no >records, hasrows returns false. using the Net provider >for Firebird, hasrows ALWAYS returns true, even if I >execute a query which I know has no rows. Of course, >this can be circumvented, but I figure this is >something that needs to be reported. > > I know, hasrows need to determine wheter a query returns rows or not but without fetch data, and there are now way (know by me at least) for get that info in firebird (for select statements, i can return false for non query statements) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Timothy S. <tim...@ya...> - 2004-04-15 14:11:50
|
Hi all, I'm a new subscriber to these lists so forgive me if this has already been brought up (I just started using firebird yesterday). In any case, I'm porting over some code to use the firebird .net provider and my code was something like this: FbDataReader reader = cmd.ExecuteQuery(); while(reader.Read()) { //do stuff } if(!reader.HasRows()) { empty = true; } using the OleDbDataReader, if the reader has no records, hasrows returns false. using the Net provider for Firebird, hasrows ALWAYS returns true, even if I execute a query which I know has no rows. Of course, this can be circumvented, but I figure this is something that needs to be reported. -Tim __________________________________ Do you Yahoo!? Yahoo! Tax Center - File online by April 15th http://taxes.yahoo.com/filing.html |
From:
<car...@te...> - 2004-04-15 08:30:57
|
Hello: > which file u refer in CVS ? FbDBTypes ? Do u mean it require me to > build the source? > Is there any new release on Firebird.net Data Provider with install > shield that available for me to install directly? > I currently using the copy of FirebirdNETProvider1.6-Beta1-NET1.1.exe. A new version will be released next week (I can send to you a new dll built from CVS sources if you need it) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: benny <be...@ch...> - 2004-04-15 08:22:44
|
> I have record e.g. > CSD_ID CSD_DOWNLOAD_VERSION > 1 1.1 > in line *** for textbox.Text I should have value 1.1 but what I get=20 > is 11000 !? why ? did I done anything wrong? > This is already fixed in CVS. which file u refer in CVS ? FbDBTypes ? Do u mean it require me to build = the source?=20 Is there any new release on Firebird.net Data Provider with install = shield that available for me to install directly? I currently using the copy of FirebirdNETProvider1.6-Beta1-NET1.1.exe.=20 TIA regards, benny ;) |
From:
<car...@te...> - 2004-04-15 07:49:28
|
Hello: > I have record e.g. > CSD_ID CSD_DOWNLOAD_VERSION > 1 1.1 > in line *** for textbox.Text I should have value 1.1 but what I get > is 11000 !? why ? did I done anything wrong? This is already fixed in CVS. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: benny <be...@ch...> - 2004-04-15 07:21:14
|
Hi, =20 While using firebird.net data provider 1.6 Beta on Delphi8 with = Firebird1.5, I couldn't fetch the field with large Int field correctly. My table :-=20 CREATE TABLE "DOWNLOAD"=20 ( "CSD_ID" "CS_AUTO_GEN_NO", "CSD_DOWNLOAD_VERSION" DECIMAL(8, 4)); And My code are as follow:- FbConnBiz.Open; FbBizTxn :=3D FbConnBiz.BeginTransaction; FbCommDownload :=3D FbCommand.Create('select * from DOWNLOAD where = CSD_ID =3D @CSD_ID' , FbConnBiz, FbBizTxn); FbCommDownload.CommandType :=3D CommandType.Text; parameterDownloadID :=3D FbParameter.Create('@CSD_ID', = FirebirdSql.Data.Firebird.FbDbType.Text); parameterDownloadID.Value :=3D DownloadID; FbCommDownload.Parameters.Add(parameterDownloadID); parameterDownloadVersion :=3D = FbParameter.Create('@CSD_DOWNLOAD_VERSION', = FirebirdSql.Data.Firebird.FbDbType.BigInt); FbCommDownload.Parameters.Add(parameterDownloadVersion); Reader :=3D FbCommDownload.ExecuteReader; Reader.Read; *** textbox.Text :=3D FloatToStr(Reader.GetInt64(6)); FbConnBiz.Close; I have record e.g.=20 CSD_ID CSD_DOWNLOAD_VERSION 1 1.1=20 in line *** for textbox.Text I should have value 1.1 but what I get is = 11000 !? why ? did I done anything wrong? The similiar result occur too while loading the data to datagrid ...=20 my code loading data to the datagrid:-=20 ...... FbdadptrMyOrder.SelectCommand :=3D FbCommMyOrder; FbdadptrMyOrder.Fill(dsMyOrder, 'TempInfo'); dgrdMyOrder.DataSource :=3D dsMyOrder.Tables['TempInfo']; dgrdMyOrder.DataBind; on field CSD_DOWNLOAD_VERSION I have data 11000 but actually I have = value 1.1 on database... TIA =20 regards, benny ;)=20 |
From:
<car...@te...> - 2004-04-14 17:50:55
|
Hello: >Well, this is probably a question for Carlos: > >Are you interested in source code for a design time CommandBuilder >component? > >It was inspired by Delphi's TUpdateSql and is currently implemented as an >SqlCommandBuilder but most of it could be of use for Firebird's provider. > >When connected to a SqlDataAdapter component it reads schema info from the >db and saves it as XML in a string property. You can then choose which >fields (changed or all) to include in UPDATE/INSERT and which fields (all, >PkAndRowVer, ...) to use for optimistic locking. You can also specify >whether to refresh records after UPDATE/INSERT. > >It comes with a basic testing environment, very few NUnit test, and even >some comments ;-). But testing has been very limited. > > Huummm .. in first place it can be interesting :) >The component will be published in a german magazine (dotnetpro) and the >publisher has agreed to make it available to open source projects. I have >also offered it to the mono project. > >I have just learned that you (carlos) beat me by 2 weeks - 1.6 incorporates >a CommandBuilderBehaviour property! Let me know if you are interested >despite this. > > Credits about the FbCommandbuilderBehavior idea needs to be given to Dimitry Azaraev ;) i only have implemeted it :) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Dieter B. <db...@sn...> - 2004-04-14 17:25:27
|
Well, this is probably a question for Carlos: Are you interested in source code for a design time CommandBuilder component? It was inspired by Delphi's TUpdateSql and is currently implemented as an SqlCommandBuilder but most of it could be of use for Firebird's provider. When connected to a SqlDataAdapter component it reads schema info from the db and saves it as XML in a string property. You can then choose which fields (changed or all) to include in UPDATE/INSERT and which fields (all, PkAndRowVer, ...) to use for optimistic locking. You can also specify whether to refresh records after UPDATE/INSERT. It comes with a basic testing environment, very few NUnit test, and even some comments ;-). But testing has been very limited. The component will be published in a german magazine (dotnetpro) and the publisher has agreed to make it available to open source projects. I have also offered it to the mono project. I have just learned that you (carlos) beat me by 2 weeks - 1.6 incorporates a CommandBuilderBehaviour property! Let me know if you are interested despite this. Thanks for providing firebird's .NET Data Provider and greetings from Berlin Dieter |
From:
<car...@te...> - 2004-04-12 08:05:36
|
Hello: > The error message is: "Object reference not set to an instance of an > object". Huummmm can you give a try with the CVS version ?? (i can send to you the assembly built from CVS soures if you don't have CVS access) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: work <she...@fo...> - 2004-04-12 06:37:37
|
Hello! When I set on pooling, I can't close connection. For example (it's real code): private string sСonnectionString = "User=sysdba;"+ "Password=masterkey;" + "Database=testbase;" + "DataSource=localhost;" + "Port=3050;" + "Dialect=3;" + "Charset=WIN1251;" + "Connection lifetime=15;" + "Pooling=true;" + // !!!!!!!!!!!!!!!!! "Packet Size=8192"; public short MayWork(string sUniqKey) { short stResult=0; FbConnection Connect=new FbConnection(sСonnectionString); try { Connect.Open(); try { FbTransaction Transact=Connect.BeginTransaction(FbTransactionOptions.Read|FbTransactionOptions.NoWait|FbTransactionOptions.ReadCommitted|FbTransactionOptions.RecVersion); try { FbCommand Command=new FbCommand(); Command.Connection=Connect; Command.Transaction=Transact; Command.CommandType=CommandType.StoredProcedure; Command.CommandText="MayWorkForos4User"; Command.Parameters.Add("@CUNIQKEY",FbDbType.Char,32).Value=sUniqKey; Command.Parameters.Add("@IRESULT",FbDbType.SmallInt); Command.Parameters[1].Direction=ParameterDirection.ReturnValue; Command.ExecuteNonQuery(); stResult=Convert.ToInt16(Command.Parameters[1].Value); Transact.Commit(); Command.Dispose(); } catch(Exception ex) { stResult=2; Transact.Rollback(); } } finally { Connect.Close(); // ERROR!!!!!!!!!!!!!!!!!!!!!!!! Connect.Dispose(); } } catch(Exception e) { stResult=2; } return stResult; } The error message is: "Object reference not set to an instance of an object". Best regards, Alex Shevelev mailto:she...@fo... |
From: Carlos G. A. <car...@te...> - 2004-04-10 13:53:21
|
Hello: > How do I go about using the provider on Mono? Will I need to recompile, = (guess I can't just use the .NET assembly??) You can build them using mono, there a makefile for monoon linux (if you want to build it in windows you will need NAnt). -- Best regards Carlos Guzm=C3=A1n =C3=81lvarez Vigo-Spain |
From: JS.staff <jsp...@ec...> - 2004-04-10 13:22:45
|
SG93IGRvIEkgZ28gYWJvdXQgdXNpbmcgdGhlIHByb3ZpZGVyIG9uICBNb25vPyBXaWxsIEkgbmVl ZCB0byByZWNvbXBpbGUsIChndWVzcyBJIGNhbid0IGp1c3QgdXNlIHRoZSAuTkVUIGFzc2VtYmx5 Pz8pDQogDQpUaGFua3MsDQogDQpKb2huDQo= |
From: Rolande A. <ajd...@zi...> - 2004-04-10 02:12:31
|
arbiter trochilics mustache avert bally drama minstrel victory password truckle pulicaria aftershaft behoove exactly terra physidae loyaut angusta ayatollah pranked glaucoma writes adorably magical ambivalent hexangular stitchwort revenue |
From: Dmitry A. <fd...@ua...> - 2004-04-09 13:53:26
|
Hello Carlos, Friday, April 9, 2004, 4:46:07 PM, you wrote: >> I recompile now it for .NET Framework 1.1 -- some new bugs %) >> But my problem -- anyway exists -- i'm don't understand where bug >> :( i have now 2 forms with same error behavior. strange... >> 3th update -- always with exception :( CGÁ> I'm sorry but i need a test case :( (are you testing it with 1.6 ??) yes i'm test it with todays cvs sources of 1.6. (with previous version of 1.6 don't work too), and on 1.5 i'm don't test... -- Best regards, Dmitry mailto:fd...@ua... |
From:
<car...@te...> - 2004-04-09 13:46:09
|
Hello: > I recompile now it for .NET Framework 1.1 -- some new bugs %) > But my problem -- anyway exists -- i'm don't understand where bug > :( i have now 2 forms with same error behavior. strange... > 3th update -- always with exception :( I'm sorry but i need a test case :( (are you testing it with 1.6 ??) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Dmitry A. <fd...@ua...> - 2004-04-09 13:37:55
|
Hello Dmitry, Friday, April 9, 2004, 3:53:16 PM, you wrote: CGÁ>> You can't do a test case ?? DA> I tried to do test case but me as well as not to manage to repeat DA> the mistake. In currently test case all beautifully work :( I recompile now it for .NET Framework 1.1 -- some new bugs %) But my problem -- anyway exists -- i'm don't understand where bug :( i have now 2 forms with same error behavior. strange... 3th update -- always with exception :( -- Best regards, Dmitry mailto:fd...@ua... |
From: Dmitry A. <fd...@ua...> - 2004-04-09 12:53:34
|
Hello Carlos, Friday, April 9, 2004, 3:28:49 PM, you wrote: CGÁ> It's giving in the DbDataAdapter class :P it's going to be a little CGÁ> difficult to know the problem. I know... :) CGÁ> You can't do a test case ?? I tried to do test case but me as well as not to manage to repeat the mistake. In currently test case all beautifully work :( -- Best regards, Dmitry mailto:fd...@ua... |