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: Josauro S.J. <jo...@ca...> - 2003-12-02 17:16:35
|
Hello Carlos 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?=20 Private Sub Page_Load(ByVal sender As System.Object, ByVal e As = System.EventArgs) Handles MyBase.Load 'Put user code to initialize the page here Dim objRecibo =3D New RecibosDB Dim dr As FbDataReader =3D objRecibo.GetRecibo(100100.0) DataList1.DataSource =3D dr DataList1.DataBind() End Sub ******** GET RECIBO(100100) **************** Public Function GetRecibo(ByVal Codigo As Double) As FbDataReader Dim myConnection =3D New FbConnection(GetFBConnectionString) myConnection.Open() Dim myTxn As FbTransaction myTxn =3D myConnection.BeginTransaction() Dim selectCmd As String selectCmd =3D "EXECUTE PROCEDURE GET_RECIBO(@REC_CODIGO)" Dim myCommand =3D New FbCommand(selectCmd, myConnection, myTxn) myCommand.CommandType =3D CommandType.StoredProcedure myCommand.parameters.add("@REC_CODIGO", FbType.Double).Value =3D Codigo Dim Result As FbDataReader =3D = myCommand.executeReader(CommandBehavior.CloseConnection) Return Result myTxn.Rollback() myTxn.Dispose() myCommand.Dispose() myConnection.Close() End Function ********** FIREBIRD *************** 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 */ 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 ; 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 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 2:50 PM Subject: Re: [Firebird-net-provider] I need to return only one record = to a DataSet Hello: > Why it's don't work, I need to return only one record to a DataSet = but=20 > it's return nothing.See code below > (In BD had a record with key 100100.0 (I run procedure in IBExpert = with=20 > key 100100 and it's return a record) I think this was solved yet some time ago, or it's a new problem you = are=20 having ?? -- Best regards Carlos Guzm=E1n =C1lvarez Vigo-Spain |
From:
<car...@te...> - 2003-12-02 16:50:13
|
Hello: > Why it's don't work, I need to return only one record to a DataSet but > it's return nothing.See code below > (In BD had a record with key 100100.0 (I run procedure in IBExpert with > key 100100 and it's return a record) I think this was solved yet some time ago, or it's a new problem you are having ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Josauro S.J. <jo...@ca...> - 2003-12-02 16:29:17
|
Why it's don't work, I need to return only one record to a DataSet but = it's return nothing.See code below (In BD had a record with key 100100.0 (I run procedure in IBExpert with = key 100100 and it's return a record) Private Sub Page_Load(ByVal sender As System.Object, ByVal e As = System.EventArgs) Handles MyBase.Load 'Put user code to initialize the page here Dim objRecibo =3D New RecibosDB Dim dr As FbDataReader =3D objRecibo.GetRecibo(100100.0) DataList1.DataSource =3D dr DataList1.DataBind() End Sub ******** GET RECIBO(100100) **************** Public Function GetRecibo(ByVal Codigo As Double) As FbDataReader Dim myConnection =3D New FbConnection(GetFBConnectionString) myConnection.Open() Dim myTxn As FbTransaction myTxn =3D myConnection.BeginTransaction() Dim selectCmd As String selectCmd =3D "EXECUTE PROCEDURE GET_RECIBO(@REC_CODIGO)" Dim myCommand =3D New FbCommand(selectCmd, myConnection, myTxn) myCommand.CommandType =3D CommandType.StoredProcedure myCommand.parameters.add("@REC_CODIGO", FbType.Double).Value =3D Codigo Dim Result As FbDataReader =3D = myCommand.executeReader(CommandBehavior.CloseConnection) Return Result myTxn.Rollback() myTxn.Dispose() myCommand.Dispose() myConnection.Close() End Function ********** FIREBIRD *************** 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 */ 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 ; 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 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. 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. |
From:
<car...@te...> - 2003-12-02 15:09:29
|
Hello: > I’m new to .NET, so please be patient with me. No problem :) >Why does the provider not appear in the connect to database >dialog ? Did you mean the server explorer ?? if yes, because it works only with OleDB providers. > Could someone please give me a hint, how to use the connection in vc++ > projects? I’m using the visual studio 2003. I'm not using vc++, but you can try to add the .net provider components to the toolbox, and drop the FbConnection component into a form, after this you can configure the FbConnection properties in the properties panel. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Josauro S.J. <jo...@ca...> - 2003-12-02 15:03:23
|
Why it's don't work, I need to return only one record to a DataSet but = it's return nothing.See code below (In BD had a record with key 100100.0 (I run procedure in IBExpert with = key 100100 and it's return a record) Private Sub Page_Load(ByVal sender As System.Object, ByVal e As = System.EventArgs) Handles MyBase.Load 'Put user code to initialize the page here Dim objRecibo =3D New RecibosDB Dim dr As FbDataReader =3D objRecibo.GetRecibo(100100.0) DataList1.DataSource =3D dr DataList1.DataBind() End Sub ******** GET RECIBO(100100) **************** Public Function GetRecibo(ByVal Codigo As Double) As FbDataReader Dim myConnection =3D New FbConnection(GetFBConnectionString) myConnection.Open() Dim myTxn As FbTransaction myTxn =3D myConnection.BeginTransaction() Dim selectCmd As String selectCmd =3D "EXECUTE PROCEDURE GET_RECIBO(@REC_CODIGO)" Dim myCommand =3D New FbCommand(selectCmd, myConnection, myTxn) myCommand.CommandType =3D CommandType.StoredProcedure myCommand.parameters.add("@REC_CODIGO", FbType.Double).Value =3D Codigo Dim Result As FbDataReader =3D = myCommand.executeReader(CommandBehavior.CloseConnection) Return Result myTxn.Rollback() myTxn.Dispose() myCommand.Dispose() myConnection.Close() End Function ********** FIREBIRD *************** 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 */ 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 ; 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 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. |
From:
<car...@te...> - 2003-12-02 13:17:47
|
Hello: > I'm trying to do a Insert using Parameters but get the following error: > > [FirebirdDA.SaveData] Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 181 @ > > > Have also tried using Stored Procedure and get similar error. > > Can anyone tell me what I'm doing wrong? I'm going to try to test it later today, which version of the .NET data provider are you using ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Oliver E. <oe...@en...> - 2003-12-02 12:05:57
|
I'm new to .NET, so please be patient with me. I installed the .NET provider with the standard install routine, shipped around the problem with the missing msvcr70.dll by copying it to the windows/system32 directory and then wondered, how to use the firebird provider to make a database connection in my demo vc++.net application. Could someone please give me a hint, how to use the connection in vc++ projects? I'm using the visual studio 2003. Thanks in advance Oliver |
From: <mic...@fr...> - 2003-12-02 10:11:02
|
Hi! I'm trying to do a Insert using Parameters but get the following error: [FirebirdDA.SaveData] Dynamic SQL Error SQL error code =3D -104 Token = unknown - line 1, char 181 @=20 Have also tried using Stored Procedure and get similar error. Can anyone tell me what I'm doing wrong? You can se the code below. Michael H=E5kansson ------------------------------------ mic...@fr... 070-545 28 99 ------------------------------------ strInsert =3D "INSERT INTO VEHICLE (VEHICLEVIN, VEHICLETACO, = VEHICLETACODATE, VEHICLEREGNR, VEHICLEMODEL, VEHICLEYEAR, VEHICLECOLOR, = VEHICLEGSM, VEHICLEGSMVOICE, VEHICLEPULS, VEHICLEISPOOL, VEHICLEREQUEST, = VEHICLERESPONSE, VEHICLESERVICE, VEHICLESERVED, VEHICLECONTROL, = VEHICLECONTROLLED, VEHICLEINFO, RADIOID, USERID, LOCATIONID, BRANDID, = TYPEID, FUELTYPEID, MOBIBOXID, MOBIBOXIDPREV, USERIDCRE) VALUES = (@VEHICLEVIN, @VEHICLETACO, @VEHICLETACODATE, @VEHICLEREGNR, = @VEHICLEMODEL, @VEHICLEYEAR, @VEHICLECOLOR, @VEHICLEGSM, = @VEHICLEGSMVOICE, @VEHICLEPULS, @VEHICLEISPOOL, @VEHICLEREQUEST, = @VEHICLERESPONSE, @VEHICLESERVICE, @VEHICLESERVED, @VEHICLECONTROL, = @VEHICLECONTROLLED, @VEHICLEINFO, @RADIOID, @USERID, @LOCATIONID, = @BRANDID, @TYPEID, @FUELTYPEID, @MOBIBOXID, @MOBIBOXIDPREV, @USERIDCRE)" insertParams(1) =3D New FbParameter("@VEHICLEVIN", FbType.VarChar, = "VEHICLEVIN") insertParams(2) =3D New FbParameter("@VEHICLETACO", FbType.Integer, = "VEHICLETACO") insertParams(3) =3D New FbParameter("@VEHICLETACODATE", = FbType.TimeStamp, "CUSTOMERADDRESS") insertParams(4) =3D New FbParameter("@VEHICLEREGNR", FbType.VarChar, = "VEHICLEREGNR") insertParams(5) =3D New FbParameter("@VEHICLEMODEL", FbType.VarChar, = "VEHICLEMODEL") insertParams(6) =3D New FbParameter("@VEHICLEYEAR", FbType.VarChar, = "VEHICLEYEAR") insertParams(7) =3D New FbParameter("@VEHICLECOLOR", FbType.VarChar, = "VEHICLECOLOR") insertParams(8) =3D New FbParameter("@VEHICLEGSM", FbType.VarChar, = "VEHICLEGSM") insertParams(9) =3D New FbParameter("@VEHICLEGSMVOICE", FbType.VarChar, = "VEHICLEGSMVOICE") insertParams(10) =3D New FbParameter("@VEHICLEPULS", FbType.Double, = "VEHICLEPULS") insertParams(11) =3D New FbParameter("@VEHICLEISPOOL", FbType.SmallInt, = "VEHICLEISPOOL") insertParams(12) =3D New FbParameter("@VEHICLEREQUEST", = FbType.TimeStamp, "VEHICLEREQUEST") insertParams(13) =3D New FbParameter("@VEHICLERESPONSE", = FbType.TimeStamp, "VEHICLERESPONSE") insertParams(14) =3D New FbParameter("@VEHICLESERVICE", FbType.Date, = "VEHICLESERVICE") insertParams(15) =3D New FbParameter("@VEHICLESERVED", FbType.Date, = "VEHICLESERVED") insertParams(16) =3D New FbParameter("@VEHICLECONTROL", FbType.Date, = "VEHICLECONTROL") insertParams(17) =3D New FbParameter("@VEHICLECONTROLLED", FbType.Date, = "VEHICLECONTROLLED") insertParams(18) =3D New FbParameter("@VEHICLEINFO", FbType.VarChar, = "VEHICLEINFO") insertParams(19) =3D New FbParameter("@VEHICLEISPOOL", FbType.SmallInt, = "VEHICLEISPOOL") insertParams(20) =3D New FbParameter("@RADIOID", FbType.Integer, = "RADIOID") insertParams(21) =3D New FbParameter("@USERID", FbType.Integer, = "USERID") insertParams(22) =3D New FbParameter("@LOCATIONID", FbType.Integer, = "LOCATIONID") insertParams(23) =3D New FbParameter("@BRANDID", FbType.Integer, = "BRANDID") insertParams(24) =3D New FbParameter("@TYPEID", FbType.Integer, = "TYPEID") insertParams(25) =3D New FbParameter("@FUELTYPEID", FbType.Integer, = "FUELTYPEID") insertParams(26) =3D New FbParameter("@MOBIBOXID", FbType.Integer, = "MOBIBOXID") insertParams(27) =3D New FbParameter("@USERIDCRE", FbType.Integer, = "USERIDCRE") myCmdBuilder =3D New FbCommandBuilder(myDataAdapt) myDataAdapt.InsertCommand =3D New FbCommand(strInsCommand, myConn, = myTrans) myDataAdapt.InsertCommand.CommandType =3D cmdType Dim i As Integer For i =3D 0 To insertParams.Length - 1 myDataAdapt.InsertCommand.Parameters.Add(insertParams(i)) Next myDataAdapt.InsertCommand.UpdatedRowSource =3D UpdRowSource insertedRows =3D updatedDataSet.GetChanges(DataRowState.Added) If (Not (insertedRows) Is Nothing) Then rowsAffected =3D rowsAffected + myDataAdapt.Update(insertedRows, = SourceTable) End If myTrans.Commit() myTrans.Dispose() Return rowsAffected |
From:
<car...@te...> - 2003-12-02 09:05:51
|
Hello: > That is, once I call the objDR.Read() method, I only get a true value at the > first call. Subsequent call always return false, hence I only get one record > every time. > > Any ideas? Try what Alan McDonald and Stevyn Dembo has told to you yet or try filling the CommandText with the Stored Procedure name only ( if you are using the 1.5 version ). -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Wendell W. <wjw...@ho...> - 2003-12-02 07:34:34
|
> Class Library > > using System; > using FirebirdSql.Data.Firebird; > > public class TestClass > { > public TestClass() > { > } > > public static void RunTest() { > > Code 1. > > } > } > > > Program > > public void myMethod() { > TestClass.RunTest(); > } Have you tried calling TestClass.RunTest() twice, and only timing it the second time? Have you used any other objects in the Class Library .dll to ensure that the .NET Framework has already loaded it? I suspect that the following is happening when you call TestClass.RunTest(): 1) .NET Framework must load your Class Library .dll 2) the Framework looks in TestClass for a static .ctor because the RunTest() is static 3) the Framework detects the FirebirdSql.Data.Firebird.dll assembly dependency and loads it 4) the test actually runs Certainly items 1 and 2 are added when you put the code in the Class Library and they take time Item 3 may be delayed and taking some of the extra time also. Hope this helps, Wendell |
From:
<car...@te...> - 2003-12-02 03:20:19
|
Hello: > How insert double quotes between simple quotes? > This SQL Command > select * from usuarios where band = 'Guns''n''Roses' > show me a error: I have added a change into the CVS, that i think will fix this, if you want to test it, you get a copy of the CVS sources or replace the regex used in the FbCommand.splitBatchCommands method by this: "([^';]+('.*'))*[^';]*(?=;*)" -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From:
<car...@te...> - 2003-12-01 17:49:55
|
Hello: > If you know the solution, please tell me. I don't know what can be the problem, i will try to take a look at this as soon as possible. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: <CAR...@te...> - 2003-12-01 17:49:42
|
Hello=3A I have made a little test ( at the end of this email ) with embedded server using PInvoke=2C it=27s a very simple test but it=27s working ( it= =27s not using ADO=2ENET yet =3B) )=2E 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 reason= s=3A 1=2E It can be used in mono=3A=3A=2C this will allow to use it in linux=2C= and i think this is a very interesting issue=2E = 2=2E As the embedded server works only in local i think that if the performance penalty is not great=2C we can assume it=2E 3=2E It=27s much more easy for me than write a wrapper in C++ =3AD I want to hear comments about this issue=2E What do you think about give the embedded support using PInvoke =3F=3F -- Best regards Carlos Guzm=E1n =C1lvarez Vigo-Spain Example using PInvoke=3A int=5B=5D isc=5Fstatus =3D new int=5B20=5D=3B int db=5Fhandle =3D 0=3B byte=5B=5D param =3D new byte=5B0=5D=3B string connString =3D =40=22c=3A=5Cbugtracker=2Efdb=22=3B FbDpbBuffer dpb =3D new FbDpbBuffer()=3B dpb=2EAppend(1)=3B dpb=2EAppend(58=2C new byte=5B=5D =7B120=2C 10=2C 0=2C 0=7D)=3B dpb=2EAppend(63=2C new byte=5B=5D =7B3=2C 0=2C 0=2C 0=7D)=3B dpb=2EAppend(48=2C =22NONE=22)=3B dpb=2EAppend(28=2C =22SYSDBA=22)=3B dpb=2EAppend(29=2C =22masterkey=22)=3B byte=5B=5D dpbArray =3D dpb=2EToArray()=3B // Attach to database int result =3D FbClient=2Eisc=5Fattach=5Fdatabase( isc=5Fstatus=2C (short)connString=2ELength=2C connString=2C ref db=5Fhandle=2C (short)dpbArray=2ELength=2C dpbArray)=3B Console=2EWriteLine(=22Database handle=3A =7B0=7D=22=2C db=5Fhandle)=3B // Start transaction int tr=5Fhandle =3D 0=3B isc=5Fstatus =3D new int=5B20=5D=3B result =3D FbClient=2Eisc=5Fstart=5Ftransaction( isc=5Fstatus=2C ref tr=5Fhandle=2C 1=2C ref db=5Fhandle=2C 0=2C new byte=5B0=5D)=3B Console=2EWriteLine(=22Transaction handle=3A =7B0=7D=22=2C tr=5Fhandle)=3B= // Allocate statement int stmt=5Fhandle =3D 0=3B isc=5Fstatus =3D new int=5B20=5D=3B result =3D FbClient=2Eisc=5Fdsql=5Fallocate=5Fstatement( isc=5Fstatus=2C ref db=5Fhandle=2C ref stmt=5Fhandle)=3B Console=2EWriteLine(=22Statement handle=3A =7B0=7D=22=2C stmt=5Fhandle)=3B= // Prepare statement string stmt =3D =22select * from USERS=22=3B = isc=5Fstatus =3D new int=5B20=5D=3B // XSQLDA sqlda =3D new XSQLDA()=3B sqlda=2Eversion =3D 1=3B sqlda=2Esqln =3D 1=3B sqlda=2Esqld =3D 0=3B sqlda=2Esqldaid =3D new String(new char=5B8=5D)=3B // int size =3D XSQLDA=2EComputeLength(sqlda=2Esqln)=3B IntPtr xsqlda =3D Marshal=2EAllocHGlobal(size)=3B Marshal=2EStructureToPtr(sqlda=2C xsqlda=2C true)=3B XSQLVAR var =3D new XSQLVAR()=3B var=2EsqlData =3D IntPtr=2EZero=3B var=2EsqlInd =3D IntPtr=2EZero=3B Marshal=2EStructureToPtr( var=2C = new IntPtr(xsqlda=2EToInt32() + XSQLDA=2EComputeLength(0))=2C = true)=3B result =3D FbClient=2Eisc=5Fdsql=5Fprepare( isc=5Fstatus=2C ref tr=5Fhandle=2C ref stmt=5Fhandle=2C (short)stmt=2ELength=2C stmt=2C 3=2C xsqlda)=3B sqlda =3D (XSQLDA)Marshal=2EPtrToStructure(xsqlda=2C typeof(XSQLDA))=3B sqlda=2Esqln =3D sqlda=2Esqld=3B // size =3D XSQLDA=2EComputeLength(sqlda=2Esqln)=3B Marshal=2EFreeHGlobal(xsqlda)=3B xsqlda =3D Marshal=2EAllocHGlobal(size)=3B Marshal=2EStructureToPtr(sqlda=2C xsqlda=2C true)=3B for (int i =3D 0=3B i =3C sqlda=2Esqln=3B i++) =7B XSQLVAR wvar =3D new XSQLVAR()=3B wvar=2EsqlData =3D IntPtr=2EZero=3B wvar=2EsqlInd =3D IntPtr=2EZero=3B Marshal=2EStructureToPtr( wvar=2C = new IntPtr(xsqlda=2EToInt32() + XSQLDA=2EComputeLength(i))=2C true)=3B =7D = // Describe isc=5Fstatus =3D new int=5B20=5D=3B result =3D FbClient=2Eisc=5Fdsql=5Fdescribe( isc=5Fstatus=2C ref stmt=5Fhandle=2C 1=2C xsqlda)=3B sqlda =3D (XSQLDA)Marshal=2EPtrToStructure(xsqlda=2C typeof(XSQLDA))=3B XSQLVAR=5B=5D sqlvars =3D new XSQLVAR=5Bsqlda=2Esqln=5D=3B for (int i =3D 0=3B i =3C sqlda=2Esqln=3B i++) =7B sqlvars=5Bi=5D =3D new XSQLVAR()=3B sqlvars=5Bi=5D =3D (XSQLVAR)Marshal=2EPtrToStructure( new IntPtr(xsqlda=2EToInt32() + XSQLDA=2EComputeLength(i))=2C typeof(XSQLVAR))=3B =7D // Execute statement isc=5Fstatus =3D new int=5B20=5D=3B result =3D FbClient=2Eisc=5Fdsql=5Fexecute( isc=5Fstatus=2C ref tr=5Fhandle=2C ref stmt=5Fhandle=2C 1=2C IntPtr=2EZero)=3B // Fetch data isc=5Fstatus =3D new int=5B20=5D=3B size =3D XSQLDA=2EComputeLength(sqlda=2Esqln)=3B Marshal=2EFreeHGlobal(xsqlda)=3B xsqlda =3D Marshal=2EAllocHGlobal(size)=3B Marshal=2EStructureToPtr(sqlda=2C xsqlda=2C true)=3B for (int i =3D 0=3B i =3C sqlda=2Esqln=3B i++) =7B sqlvars=5Bi=5D=2EsqlData =3D Marshal=2EAllocHGlobal(sqlvars=5Bi=5D=2Esql= Len)=3B sqlvars=5Bi=5D=2EsqlInd =3D Marshal=2EAllocHGlobal(2)=3B Marshal=2EStructureToPtr( sqlvars=5Bi=5D=2C = new IntPtr(xsqlda=2EToInt32() + XSQLDA=2EComputeLength(i))=2C true)=3B =7D result =3D FbClient=2Eisc=5Fdsql=5Ffetch( isc=5Fstatus=2C ref stmt=5Fhandle=2C 1=2C xsqlda)=3B if (result !=3D 0) =7B byte=5B=5D buffer =3D new byte=5B1024=5D=3B = int length =3D FbClient=2Eisc=5Finterprete( buffer=2C ref isc=5Fstatus)=3B Console=2EWriteLine( Encoding=2EDefault=2EGetString(buffer=2C 0=2C length))=3B =7D // Interprete result sqlda =3D (XSQLDA)Marshal=2EPtrToStructure(xsqlda=2C typeof(XSQLDA))=3B byte=5B=5D=5B=5D data =3D new byte=5Bsqlda=2Esqln=5D=5B=5D=3B for (int i =3D 0=3B i =3C sqlda=2Esqln=3B i++) =7B sqlvars=5Bi=5D =3D (XSQLVAR)Marshal=2EPtrToStructure( new IntPtr(xsqlda=2EToInt32() + XSQLDA=2EComputeLength(i))=2C typeof(XSQLVAR))=3B data=5Bi=5D =3D new byte=5Bsqlvars=5Bi=5D=2EsqlLen=5D=3B Marshal=2ECopy(sqlvars=5Bi=5D=2EsqlData=2C data=5Bi=5D=2C 0=2C sqlvars=5B= i=5D=2EsqlLen)=3B =7D // Free memory for (int i =3D 0=3B i =3C sqlda=2Esqln=3B i++) =7B Marshal=2EFreeHGlobal(sqlvars=5Bi=5D=2EsqlData)=3B Marshal=2EFreeHGlobal(sqlvars=5Bi=5D=2EsqlInd)=3B =7D Marshal=2EDestroyStructure(xsqlda=2C typeof(XSQLDA))=3B Marshal=2EFreeHGlobal(xsqlda)=3B xsqlda =3D IntPtr=2EZero=3B = // Drop statement isc=5Fstatus =3D new int=5B20=5D=3B result =3D FbClient=2Eisc=5Fdsql=5Ffree=5Fstatement( isc=5Fstatus=2C ref stmt=5Fhandle=2C 2)=3B // Commit transaction isc=5Fstatus =3D new int=5B20=5D=3B result =3D FbClient=2Eisc=5Fcommit=5Ftransaction( isc=5Fstatus=2C ref tr=5Fhandle)=3B // Detach from database isc=5Fstatus =3D new int=5B20=5D=3B result =3D FbClient=2Eisc=5Fdetach=5Fdatabase( isc=5Fstatus=2C ref db=5Fhandle)=3B |
From: <car...@te...> - 2003-12-01 17:40:03
|
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 I want to hear comments about this issue. What do you think about give the embedded support using PInvoke ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain P.S.: Sorry for send this email two times, i'm having sending/receiving emails in the .net provider the list, i'm not sure if it's a sourceforge problem or a problem with my ISP. Example using PInvoke: int[] isc_status = new int[20]; int db_handle = 0; byte[] param = new byte[0]; string connString = @"c:\bugtracker.fdb"; FbDpbBuffer dpb = new FbDpbBuffer(); dpb.Append(1); dpb.Append(58, new byte[] {120, 10, 0, 0}); dpb.Append(63, new byte[] {3, 0, 0, 0}); dpb.Append(48, "NONE"); dpb.Append(28, "SYSDBA"); dpb.Append(29, "masterkey"); byte[] dpbArray = dpb.ToArray(); // Attach to database int result = FbClient.isc_attach_database( isc_status, (short)connString.Length, connString, ref db_handle, (short)dpbArray.Length, dpbArray); Console.WriteLine("Database handle: {0}", db_handle); // Start transaction int tr_handle = 0; isc_status = new int[20]; result = FbClient.isc_start_transaction( isc_status, ref tr_handle, 1, ref db_handle, 0, new byte[0]); Console.WriteLine("Transaction handle: {0}", tr_handle); // Allocate statement int stmt_handle = 0; isc_status = new int[20]; result = FbClient.isc_dsql_allocate_statement( isc_status, ref db_handle, ref stmt_handle); Console.WriteLine("Statement handle: {0}", stmt_handle); // Prepare statement string stmt = "select * from USERS"; isc_status = new int[20]; // XSQLDA sqlda = new XSQLDA(); sqlda.version = 1; sqlda.sqln = 1; sqlda.sqld = 0; sqlda.sqldaid = new String(new char[8]); // int size = XSQLDA.ComputeLength(sqlda.sqln); IntPtr xsqlda = Marshal.AllocHGlobal(size); Marshal.StructureToPtr(sqlda, xsqlda, true); XSQLVAR var = new XSQLVAR(); var.sqlData = IntPtr.Zero; var.sqlInd = IntPtr.Zero; Marshal.StructureToPtr( var, new IntPtr(xsqlda.ToInt32() + XSQLDA.ComputeLength(0)), true); result = FbClient.isc_dsql_prepare( isc_status, ref tr_handle, ref stmt_handle, (short)stmt.Length, stmt, 3, xsqlda); sqlda = (XSQLDA)Marshal.PtrToStructure(xsqlda, typeof(XSQLDA)); sqlda.sqln = sqlda.sqld; // size = XSQLDA.ComputeLength(sqlda.sqln); Marshal.FreeHGlobal(xsqlda); xsqlda = Marshal.AllocHGlobal(size); Marshal.StructureToPtr(sqlda, xsqlda, true); for (int i = 0; i < sqlda.sqln; i++) { XSQLVAR wvar = new XSQLVAR(); wvar.sqlData = IntPtr.Zero; wvar.sqlInd = IntPtr.Zero; Marshal.StructureToPtr( wvar, new IntPtr(xsqlda.ToInt32() + XSQLDA.ComputeLength(i)), true); } // Describe isc_status = new int[20]; result = FbClient.isc_dsql_describe( isc_status, ref stmt_handle, 1, xsqlda); sqlda = (XSQLDA)Marshal.PtrToStructure(xsqlda, typeof(XSQLDA)); XSQLVAR[] sqlvars = new XSQLVAR[sqlda.sqln]; for (int i = 0; i < sqlda.sqln; i++) { sqlvars[i] = new XSQLVAR(); sqlvars[i] = (XSQLVAR)Marshal.PtrToStructure( new IntPtr(xsqlda.ToInt32() + XSQLDA.ComputeLength(i)), typeof(XSQLVAR)); } // Execute statement isc_status = new int[20]; result = FbClient.isc_dsql_execute( isc_status, ref tr_handle, ref stmt_handle, 1, IntPtr.Zero); // Fetch data isc_status = new int[20]; size = XSQLDA.ComputeLength(sqlda.sqln); Marshal.FreeHGlobal(xsqlda); xsqlda = Marshal.AllocHGlobal(size); Marshal.StructureToPtr(sqlda, xsqlda, true); for (int i = 0; i < sqlda.sqln; i++) { sqlvars[i].sqlData = Marshal.AllocHGlobal(sqlvars[i].sqlLen); sqlvars[i].sqlInd = Marshal.AllocHGlobal(2); Marshal.StructureToPtr( sqlvars[i], new IntPtr(xsqlda.ToInt32() + XSQLDA.ComputeLength(i)), true); } result = FbClient.isc_dsql_fetch( isc_status, ref stmt_handle, 1, xsqlda); if (result != 0) { byte[] buffer = new byte[1024]; int length = FbClient.isc_interprete( buffer, ref isc_status); Console.WriteLine( Encoding.Default.GetString(buffer, 0, length)); } // Interprete result sqlda = (XSQLDA)Marshal.PtrToStructure(xsqlda, typeof(XSQLDA)); byte[][] data = new byte[sqlda.sqln][]; for (int i = 0; i < sqlda.sqln; i++) { sqlvars[i] = (XSQLVAR)Marshal.PtrToStructure( new IntPtr(xsqlda.ToInt32() + XSQLDA.ComputeLength(i)), typeof(XSQLVAR)); data[i] = new byte[sqlvars[i].sqlLen]; Marshal.Copy(sqlvars[i].sqlData, data[i], 0, sqlvars[i].sqlLen); } // Free memory for (int i = 0; i < sqlda.sqln; i++) { Marshal.FreeHGlobal(sqlvars[i].sqlData); Marshal.FreeHGlobal(sqlvars[i].sqlInd); } Marshal.DestroyStructure(xsqlda, typeof(XSQLDA)); Marshal.FreeHGlobal(xsqlda); xsqlda = IntPtr.Zero; // Drop statement isc_status = new int[20]; result = FbClient.isc_dsql_free_statement( isc_status, ref stmt_handle, 2); // Commit transaction isc_status = new int[20]; result = FbClient.isc_commit_transaction( isc_status, ref tr_handle); // Detach from database isc_status = new int[20]; result = FbClient.isc_detach_database( isc_status, ref db_handle); |
From: <car...@te...> - 2003-12-01 17:34:02
|
Test |
From: Cserna Z. <cs...@ho...> - 2003-12-01 11:34:21
|
Hi! I have a big problem. If I use the provider (RC7 in Windows XP, C# Builder), and my project has the provider, the speed is good Sample -------- Code 1.: FbConnection myConnection = new FbConnection( - Connection String - ); myConnection.Open(); FbTransaction myTransaction = MyConnection.BeginTransaction(); FbCommand myCommand = new FbCommand("select * from table", myConnection, myTransaction); FbDataReader myReader; myReader = myCommand.ExecuteReader(); while (myReader.Read()) { ... doing something ... } myReader.Close(); myTransaction.Commit(); myConnection.Close(); >> it's about 1.5 secound ------ But, if this code is in a Class Library (.dll), and my program call the class library's function, the program is very slow... I don't understand why ------ Code 2.: Class Library using System; using FirebirdSql.Data.Firebird; public class TestClass { public TestClass() { } public static void RunTest() { Code 1. } } Program public void myMethod() { TestClass.RunTest(); } >> it's takes me about 6 secounds ------- If you know the solution, please tell me. Thanks Zsombor Cserna (cs...@ho...) |
From: stevyn d. <sr...@ya...> - 2003-12-01 02:43:03
|
Hello: You should could your stored procedure // "EXECUTE PROCEDURE SP_BROWSE_USERS.." string as "SELECT * FROM SP_BROWSE_USERS...." regards "Mark S. Maglana" <mma...@ho...> wrote: Hello, I'm trying to retrieve a table of users using the following stored proc: ---------------------- CREATE PROCEDURE SP_BROWSE_USERS RETURNS ( USER_ID VARCHAR(38), SSS VARCHAR(256), NAME_FIRST VARCHAR(50), NAME_MIDDLE VARCHAR(50), NAME_LAST VARCHAR(50), NAME_USER VARCHAR(16), IS_DISABLED CHAR(1)) AS begin for select USER_ID, SSS, NAME_FIRST, NAME_MIDDLE, NAME_LAST, NAME_USER, IS_DISABLED from USERS into :USER_ID, :SSS, :NAME_FIRST, :NAME_MIDDLE, :NAME_LAST, :NAME_USER, :IS_DISABLED do suspend; end -------------------------------------------------------- Now when I tried this in the database, it works just fine. Returns all the records in the table, however, when I use the firebird .net provider using the following code, I always get a single record. --------------------------------------- objConn.Open(); FbTransaction objTrans = objConn.BeginTransaction(); // strCommandText contains the // "EXECUTE PROCEDURE SP_BROWSE_USERS.." string FbCommand objCommand = new FbCommand(strCommandText, this.GetConnection(), objTrans); objCommand.CommandType = CommandType.StoredProcedure; FbDataReader objDR = objCommand.ExecuteReader(); ----------------------------------- That is, once I call the objDR.Read() method, I only get a true value at the first call. Subsequent call always return false, hence I only get one record every time. Any ideas? Mark ------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. Does SourceForge.net help you be more productive? Does it help you create better code? SHARE THE LOVE, and help us help YOU! Click Here: http://sourceforge.net/donate/ _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. --------------------------------- Do you Yahoo!? Free Pop-Up Blocker - Get it now |
From: Alan M. <al...@me...> - 2003-12-01 01:55:07
|
you're using a selectable procedure so use SELECT * from syntax not execute > -----Original Message----- > From: fir...@li... > [mailto:fir...@li...]On Behalf Of > Mark S. Maglana > Sent: Monday, 1 December 2003 11:57 AM > To: fir...@li... > Subject: [Firebird-net-provider] DataReader always returns one record > > > Hello, > > I'm trying to retrieve a table of users using the following stored proc: > ---------------------- > CREATE PROCEDURE SP_BROWSE_USERS > RETURNS ( > USER_ID VARCHAR(38), > SSS VARCHAR(256), > NAME_FIRST VARCHAR(50), > NAME_MIDDLE VARCHAR(50), > NAME_LAST VARCHAR(50), > NAME_USER VARCHAR(16), > IS_DISABLED CHAR(1)) > AS > begin > for select USER_ID, SSS, NAME_FIRST, NAME_MIDDLE, NAME_LAST, > NAME_USER, IS_DISABLED > from USERS > into :USER_ID, :SSS, :NAME_FIRST, :NAME_MIDDLE, :NAME_LAST, > :NAME_USER, :IS_DISABLED > do > suspend; > end > -------------------------------------------------------- > > Now when I tried this in the database, it works just fine. Returns all the > records in the table, however, when I use the firebird .net provider using > the following code, I always get a single record. > > --------------------------------------- > > objConn.Open(); > > FbTransaction objTrans = objConn.BeginTransaction(); > > // strCommandText contains the > // "EXECUTE PROCEDURE SP_BROWSE_USERS.." string > FbCommand objCommand = new FbCommand(strCommandText, this.GetConnection(), > objTrans); > > objCommand.CommandType = CommandType.StoredProcedure; > FbDataReader objDR = objCommand.ExecuteReader(); > > ----------------------------------- > > That is, once I call the objDR.Read() method, I only get a true > value at the > first call. Subsequent call always return false, hence I only get > one record > every time. > > Any ideas? > > Mark > > > ------------------------------------------------------- > This SF.net email is sponsored by: SF.net Giveback Program. > Does SourceForge.net help you be more productive? Does it > help you create better code? SHARE THE LOVE, and help us help > YOU! Click Here: http://sourceforge.net/donate/ > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > |
From: Mark S. M. <mma...@ho...> - 2003-12-01 00:54:53
|
Hello, I'm trying to retrieve a table of users using the following stored proc: ---------------------- CREATE PROCEDURE SP_BROWSE_USERS RETURNS ( USER_ID VARCHAR(38), SSS VARCHAR(256), NAME_FIRST VARCHAR(50), NAME_MIDDLE VARCHAR(50), NAME_LAST VARCHAR(50), NAME_USER VARCHAR(16), IS_DISABLED CHAR(1)) AS begin for select USER_ID, SSS, NAME_FIRST, NAME_MIDDLE, NAME_LAST, NAME_USER, IS_DISABLED from USERS into :USER_ID, :SSS, :NAME_FIRST, :NAME_MIDDLE, :NAME_LAST, :NAME_USER, :IS_DISABLED do suspend; end -------------------------------------------------------- Now when I tried this in the database, it works just fine. Returns all the records in the table, however, when I use the firebird .net provider using the following code, I always get a single record. --------------------------------------- objConn.Open(); FbTransaction objTrans = objConn.BeginTransaction(); // strCommandText contains the // "EXECUTE PROCEDURE SP_BROWSE_USERS.." string FbCommand objCommand = new FbCommand(strCommandText, this.GetConnection(), objTrans); objCommand.CommandType = CommandType.StoredProcedure; FbDataReader objDR = objCommand.ExecuteReader(); ----------------------------------- That is, once I call the objDR.Read() method, I only get a true value at the first call. Subsequent call always return false, hence I only get one record every time. Any ideas? Mark |
From:
<car...@te...> - 2003-11-29 19:35:28
|
Hello: I have modified GdsAttachParams.cs for bring to work the code, originally ported from Jaybird, for allow the use of classical connections strings of Firebird, like: Database=localhost/3050:D:\TESTDB.GDB;User=SYSDBA;Password=masterkey;Dialect=3;... or Database=//localhost:3050/D:\TESTDB.GDB;User=SYSDBA;Password=masterkey;Dialect=3;... The database value will be parsed with this format when no specific datasource element was specified. (If i'm not wrong the second format is Java-Like, but as the code is ported from Jaybird i will allow it too) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Peter J. <pj...@wa...> - 2003-11-29 11:14:53
|
Hi All! > > How insert double quotes between simple quotes? > > This SQL Command > > select * from usuarios where band = 'Guns''n''Roses' > > show me a error: > > At this moment, for the limitations on the batch query execution, using > parametrized querys. Wouldn't one of these methods work: (from MSDN) <cite> and can contain any character literal, including escape sequences: string a = "\\\u0066\n"; // backslash, letter f, new line Note The escape code \udddd (where dddd is a four-digit number) represents the Unicode character U+dddd. Eight-digit Unicode escape codes are also recognized: \udddd\udddd. [...] The advantage of @-quoting is that escape sequences are not processed, which makes it easy to write, for example, a fully qualified file name: @"c:\Docs\Source\a.txt" // rather than "c:\\Docs\\Source\\a.txt" To include a double quotation mark in an @-quoted string, double it: @"""Ahoy!"" cried the captain." // "Ahoy!" cried the captain. </cite> I think, the complicated case would be single quotation marks. Regards, Peter Jacobi |
From:
<car...@te...> - 2003-11-28 23:11:40
|
From:
<car...@te...> - 2003-11-28 23:00:22
|
Hello: > How insert double quotes between simple quotes? > This SQL Command > select * from usuarios where band = 'Guns''n''Roses' > show me a error: At this moment, for the limitations on the batch query execution, using parametrized querys. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From:
<car...@te...> - 2003-11-28 23:00:21
|
Hello: I have modified GdsAttachParams.cs for bring to work the code, originally ported from Jaybird, for allow the use of classical connections strings of Firebird, like: Database=localhost/3050:D:\TESTDB.GDB;User=SYSDBA;Password=masterkey;Dialect=3;... or Database=//localhost:3050/D:\TESTDB.GDB;User=SYSDBA;Password=masterkey;Dialect=3;... The database value will be parsed with this format when no specific datasource element was specified. (If i'm not wrong the second format is Java-Like, but as the code is ported from Jaybird i will allow it too) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Cristiano A. C. <cri...@te...> - 2003-11-28 19:26:13
|
Hi, How insert double quotes between simple quotes? This SQL Command select * from usuarios where band = 'Guns''n''Roses' show me a error: FirebirdSql.Data.Firebird.FbException: Dynamic SQL Error SQL error code = -104 Unexpected end of command ---> FirebirdSql.Data.Firebird.Gds.GdsException: Exceção do tipo FirebirdSql.Data.Firebird.Gds.GdsException foi acionada. at FirebirdSql.Data.Firebird.Gds.GdsAttachment.ReadStatusVector() at FirebirdSql.Data.Firebird.Gds.GdsAttachment.ReceiveResponse() at FirebirdSql.Data.Firebird.Gds.GdsStatement.Prepare() at FirebirdSql.Data.Firebird.FbCommand.InternalPrepare() at FirebirdSql.Data.Firebird.FbCommand.ExecuteReader(CommandBehavior behavior) --- Fim do rastreamento de pilha de exceções internas --- at FirebirdSql.Data.Firebird.FbCommand.ExecuteReader(CommandBehavior behavior) at FirebirdSql.Data.Firebird.FbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at CasadaSaude.BuscaCep.PorEndereco(String sEndereco, String sCidade, String sUF) in c:\Inetpub\wwwroot\csws\buscacep.asmx.cs:line 163 Someone idea? -- Cristiano A. Costa é web developer e fundador do grupo Software Livre MS. Software Livre MS www.grupos.com.br/grupos/softwarelivrems e-mail: cri...@te... uin: 101778772 |