firebird-net-provider — All about development of the MS .Net provider

Re: [Firebird-net-provider] Developement status report

[Alessandro P. <pet...@in...>]

"Carlos Guzman Alvarez" <car...@te...> wrote in message
news:3F7...@te......
> Hello:
>
> > The cvs has been restored, I hope to be able to get this patch.
>
> If you want i can send to you a zip file with latest cvs sources.

No problem, the cvs has the correct version.

Thank you.

Ciao,
Alessandro Petrelli.

Re: [Firebird-net-provider] Developement status report

[Carlos G. A. <car...@te...>]

Hello:

> The cvs has been restored, I hope to be able to get this patch.

If you want i can send to you a zip file with latest cvs sources.

> No idea, sorry. I don't use the installer.

:)

> I think the 1.0 should be provided "on demand".

Thanks :)

> Have to find out some time to try it, sorry.

No problem i'm working on it little by little :)




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Datasets

[Carlos G. A. <car...@te...>]

Hello:

> I'm using the standard data grid with the FbReader and I get an error when I
> try to enable paging on the grids.
> 
> Is this something that is going to be looked at?

Can you send a test case ?? And the stack trace of the exception ??





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Developement status report

[Alessandro P. <pet...@in...>]

"Carlos Guzman Alvarez" <car...@te...> wrote in message
news:3F7...@te......
> Hello:
>
> 1. I have made today one fix to the FbDataReader class for a better
> handling of blob SUB_TYPE and added a new NUNit Text Fixture for blob
> fields.

The cvs has been restored, I hope to be able to get this patch.

> 2. I'm making some changes to the nant build file to test the msi task,
> i need to check some things but i'm thinking on use this for
> installation build instead of the Ghost installer (if msi nant task
> works ok), opinions are wellcome ??

No idea, sorry. I don't use the installer.

> 3. Another question is wich version of the .net framework will be used
> for future installations, as there are people working with both 1.0 and
> 1.1, opinions are wellcome ??

I think the 1.0 should be provided "on demand".

> 4. Finally i cotinue to work in the ASP.NET sample app that can be found
> in the CVS at:
>
> NETPRovider/SampleApplication/ASP.NET/BugTracker

Have to find out some time to try it, sorry.

Ciao,
Alessandro Petrelli.

[Firebird-net-provider] Datasets

[Mike N. <mi...@ta...>]

Hi,

I'm using the standard data grid with the FbReader and I get an error when I
try to enable paging on the grids.

Is this something that is going to be looked at?


Mike

[Firebird-net-provider] Developement status report

[Carlos G. A. <car...@te...>]

Hello:

1. I have made today one fix to the FbDataReader class for a better 
handling of blob SUB_TYPE and added a new NUNit Text Fixture for blob 
fields.

2. I'm making some changes to the nant build file to test the msi task, 
i need to check some things but i'm thinking on use this for 
installation build instead of the Ghost installer (if msi nant task 
works ok), opinions are wellcome ??

3. Another question is wich version of the .net framework will be used 
for future installations, as there are people working with both 1.0 and 
1.1, opinions are wellcome ??

4. Finally i cotinue to work in the ASP.NET sample app that can be found 
in the CVS at:

	NETPRovider/SampleApplication/ASP.NET/BugTracker





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

RE: [Firebird-net-provider] Stored Procedure returns dataset...

[Mike N. <mi...@ta...>]

Thanks a lot Carlos,

Thanks for your help with this, much appreciated. And about the code
formatting - I'm new to .NET so any advice is welcome :)


<SNIP>

Don't worry :), try:

FbCommand myCommand = new FbCommand("SELECT * FROM
GET_ALLOTMENTS_FORMATTED(?,?,?)", myConnection, myTxn);

And a little advice :), ParameterDirection.Input is the default
direction for new parameters, you can create input parameters as:

<SNIP>

Re: [Firebird-net-provider] Stored Procedure returns dataset...

[Carlos G. A. <car...@te...>]

Hello:

> I have a stored procedure that returns a recordset. Works fine when I call
> it from IBExpert, but when I call it from .NET I am only getting one row
> returned.
> 
> I am not sure I am using the correct syntax to call a stored proc that
> returns a recordset.
> 
> I'm displaying it in a grid, and my test code is below.  I'd appreciate it
> if someone could point me in the right direction here.. I'm new to .NET and
> only have a bit of firebird experience.

Don't worry :), try:

FbCommand myCommand = new FbCommand("SELECT * FROM 
GET_ALLOTMENTS_FORMATTED(?,?,?)", myConnection, myTxn);

Or if you are using Firebird .NET Provider 1.5:

FbCommand myCommand = new FbCommand("GET_ALLOTMENTS_FORMATTED", 
myConnection, myTxn);


And a little advice :), ParameterDirection.Input is the default 
direction for new parameters, you can create input parameters as:

myCommand.Parameters.Add("@ROOM_ID", FbType.Integer, "ROOM_ID").Value = 1;

myCommand.Parameters.Add("@DATE_FROM", FbType.Date, "DATE_FROM").Value = 
"1/1/2000";

myCommand.Parameters.Add("@DATE_TO", FbType.Date, "DATE_TO").Value = 
"1/1/2008";


that i think it's more easy and readable but it's your choice :)



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Stored Procedure returns dataset...

[Mike N. <mi...@ta...>]

Hello

I have a stored procedure that returns a recordset. Works fine when I call
it from IBExpert, but when I call it from .NET I am only getting one row
returned.

I am not sure I am using the correct syntax to call a stored proc that
returns a recordset.

I'm displaying it in a grid, and my test code is below.  I'd appreciate it
if someone could point me in the right direction here.. I'm new to .NET and
only have a bit of firebird experience.


Regards


Mike

----

FbConnection myConnection = new FbConnection(connectionString);
myConnection.Open();
FbTransaction myTxn = myConnection.BeginTransaction();
FbCommand myCommand = new FbCommand("EXECUTE PROCEDURE
GET_ALLOTMENTS_FORMATTED(?,?,?)", myConnection, myTxn);

myCommand.CommandType = CommandType.StoredProcedure;

myCommand.Parameters.Add("@ROOM_ID", FbType.Integer, "ROOM_ID").Direction =
ParameterDirection.Input;

myCommand.Parameters.Add("@DATE_FROM", FbType.Date, "DATE_FROM").Direction =
ParameterDirection.Input;

myCommand.Parameters.Add("@DATE_TO", FbType.Date, "DATE_TO").Direction =
ParameterDirection.Input;


myCommand.Parameters[0].Value = 1;
myCommand.Parameters[1].Value = "1/1/2000";
myCommand.Parameters[2].Value = "1/1/2008";

FbDataReader myReader;
myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
DataGrid1.DataSource = myReader;
DataGrid1.DataBind();
myReader.Dispose();

Re: [Firebird-net-provider] .net 1.0 vs. 1.1

[Karl S. <web...@st...>]

car...@te... (Carlos Guzman Alvarez) wrote in
news:3F6...@te...: 

> 
> Nothing special :), i can make all future installs using .NET 1.1 but
> i don't want to have both frameworks installed ( to avoid possible 
> problems ;) ) this means i will not make more releases ( installation 
> packages ) for .net 1.0, opinions are wellcome ??
> 
> 
> 
> 

Well, I'm for .net 1.1 for the same reasons as Alan said.

KS

Re: [Firebird-net-provider] .net 1.0 vs. 1.1

[Carlos G. A. <car...@te...>]

Hello:

> Carlos why are you fixed on 1.0 when the update is free and easy to
> install... is there some other technical reason why you want to stay with
> 1.0?
> For anyone getting into .NET right now (and for some time now) MS does not
> make it easy at all to acquire 1.0, it's 1.1 or no .NET

Nothing special :), i can make all future installs using .NET 1.1 but i 
don't want to have both frameworks installed ( to avoid possible 
problems ;) ) this means i will not make more releases ( installation 
packages ) for .net 1.0, opinions are wellcome ??




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] .net 1.0 vs. 1.1

[Karl S. <web...@st...>]

car...@te... (Carlos Guzman Alvarez) wrote in 
news:3F6...@te...:

> Hello:
> 
>> as a .net-Newbie I have a question relating the use of the firebird 
>> dataprovider.
>> 
>> The Provider is written for .net 1.0. Is he working under 1.1 too ??
> 
> The provider can be used with both 1.0 and 1.1, but i have installed 
> .net framework 1.0 only at this moment i have released installation 
> packages only for it, you can build the sources using .net framework 1.1 
> and nant ( nant.sourceforge .net ) it's easy to do :)
> 


Well, at the moment, the binaries makes it with .net 1.1

My first DataGrid-Form runs :-) 

RE: [Firebird-net-provider] .net 1.0 vs. 1.1

[Alan M. <al...@me...>]

Carlos why are you fixed on 1.0 when the update is free and easy to
install... is there some other technical reason why you want to stay =
with
1.0?
For anyone getting into .NET right now (and for some time now) MS doe=
s not
make it easy at all to acquire 1.0, it's 1.1 or no .NET
Alan

> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf=
 Of
> Carlos Guzman Alvarez
> Sent: Sunday, 21 September 2003 11:06 PM
> To: fir...@li...
> Subject: Re: [Firebird-net-provider] .net 1.0 vs. 1.1
>
>
> Hello:
>
> > as a .net-Newbie I have a question relating the use of the firebi=
rd
> > dataprovider.
> >
> > The Provider is written for .net 1.0. Is he working under 1.1 too=
 ??
>
> The provider can be used with both 1.0 and 1.1, but i have installe=
d
> .net framework 1.0 only at this moment i have released installation
> packages only for it, you can build the sources using .net framewor=
k 1.1
> and nant ( nant.sourceforge .net ) it's easy to do :)
>
>
>
>
>
>
> --
> 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
>
>

Re: [Firebird-net-provider] .net 1.0 vs. 1.1

[Carlos G. A. <car...@te...>]

Hello:

> as a .net-Newbie I have a question relating the use of the firebird 
> dataprovider.
> 
> The Provider is written for .net 1.0. Is he working under 1.1 too ??

The provider can be used with both 1.0 and 1.1, but i have installed 
.net framework 1.0 only at this moment i have released installation 
packages only for it, you can build the sources using .net framework 1.1 
and nant ( nant.sourceforge .net ) it's easy to do :)






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] .net 1.0 vs. 1.1

[Karl S. <web...@st...>]

Hello All,

as a .net-Newbie I have a question relating the use of the firebird 
dataprovider.

The Provider is written for .net 1.0. Is he working under 1.1 too ??

Thanks

KS

Re: [Firebird-net-provider] Use Dataset and Commands Delete,Update..

[Carlos G. A. <car...@te...>]

Hello:

>  but how I can resolve my problem?

Setting the DELETE FROM .. as command text.

> PS: Thank for your great work.

Thanks toy you :)





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Use Dataset and Commands Delete,Update..

[Martin R. <ne...@mi...>]

Thanks Carlos,
 but how I can resolve my problem?

"Additional information: Concurrency violation: the DeleteCommand affected 0
records."
I cann't use Update function of  DataAdapter.

OK I can cach the exception, and set ContinueUpdateErro=true.

Is it good idea?
What do you recommended to me?

Thank you.
Best regards
Martin Radvansky

PS: Thank for your great work.

> > What I do wrong. Please help me.
>
> Nothing, in the provider i'm using  a call to isc_dsql_sql_info and
> seems that this is not working when the delete ( and probably updates
> and inserts ) are made inside a stored proc, i have made a test and
> using a sp the returned affected rows are 0 and using the DELETE command
> as command text are 1.
>
>
>
>
>
> -- 
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>

Re: [Firebird-net-provider] Use Dataset and Commands Delete,Update.. error

[Carlos G. A. <car...@te...>]

Hello:

> What I do wrong. Please help me.

Nothing, in the provider i'm using  a call to isc_dsql_sql_info and
seems that this is not working when the delete ( and probably updates
and inserts ) are made inside a stored proc, i have made a test and
using a sp the returned affected rows are 0 and using the DELETE command
as command text are 1.





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Use Dataset and Commands Delete,Update.. error

[Martin R. <ne...@mi...>]

Hi, I try use dataset with fbCommand for Delete and Update.

Stored procedure is

CREATE PROCEDURE SP_LSTRED_D ( RID INTEGER)
AS
BEGIN
  DELETE FROM LSTRED
  WHERE (RID = :RID);
END

Source in C# VS2003
protected FirebirdSql.Data.Firebird.FbCommand fbCMainDelete;
*
private void SetupDeleteComm {
  fbCMainDelete.Connection=FGlobalData.PrikladConnection();
  FMainDataAdapter.DeleteCommand=fbCMainDelete;
  FMainDataAdapter.CommandText="EXECUTE PROCEDURE SP_LSTRED_D (?)";
  FMainDataAdapter.DeleteCommand.Parameters.Add("RID",
firebird.FbDbType.Integer,0,"RID");
}
*

When I fire
private void sbbtnDelete_ItemClick(object sender,
DevExpress.XtraBars.ItemClickEventArgs e) {
  FMainCurrencyManager.RemoveAt(FMainCurrencyManager.Position);
cause error ->  FMainDataAdapter.Update(MainDataSet,GetTblName());
}

then I every times get error message

" An unhandled exception of type 'System.Data.DBConcurrencyException'
occurred in system.data.dll
Additional information: Concurrency violation: the DeleteCommand affected 0
records."

Could anybody help me please?

if I fire this procedure than it works but affected rows is still 0

firebird.FbTransaction trans =
FGlobalData.PrikladConnection().BeginTransaction();
fbCMainDelete.Transaction = trans;
fbCMainDelete.Parameters["RID"].Value = 16;
MessageBox.Show(Convert.ToString(fbCMainDelete.ExecuteNonQuery()));
trans.Commit();
If I don't use transaction then it don't work too.

What I do wrong. Please help me.


Thank you very much.

[Firebird-net-provider] [ANN] Firebird .NET Data Provider 1.5 Beta 1 ( for .NET 1.0 ) released.

[Carlos G. A. <car...@te...>]

Hello:

Firebird .NET Data Provider 1.5 Beta 1 ( for .NET 1.0 ) available for 
download.

With this release the developement of new features is freeze and only 
bugfixes and minor improvements will be allowed.


Release Changes:

Beta 1 ( 2003-09-20 )
---- - --------------

- Bug fixes.

- Improved NUnit test suite.

- Improved FbScript class.

- Improved FbDataReader.GetSchemaTable method by adding support
for COMPUTED columns and fixing readonly columns detection.

- Improved batch command execution using regular expressions.

         ---------------------------------------------------


You can download binarys ( for Windows and .NET Framework 1.0 ) at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-Beta1.exe?download


You can download sources at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-Beta1-Src.zip?download


You can download documentation at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-Beta1-Doc.zip?download




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Insert text into blobs

[Carlos G. A. <car...@te...>]

Hello:

> Don't worry, I successfully applied the latest patch and I can confirm it is
> working correctly.

Thanks you very much :) there a new nunit test case for this but it's 
nice that you has confirmed it :)




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Insert text into blobs

[Alessandro P. <pet...@in...>]

"Carlos Guzman Alvarez" <car...@te...> wrote in message
news:3F6...@te......
> Hello:
>
> > Thank you very much... but the cvs is not updated again :-(
> > I rebuilt the changes using the checkins messages.
>
> If you want i can send the sources to you, i want to release beta 1
> today if possible but before i want to ensure this is solved ;)

Don't worry, I successfully applied the latest patch and I can confirm it is
working correctly.

Ciao,
Alessandro Petrelli.

Re: [Firebird-net-provider] Insert text into blobs

[Carlos G. A. <car...@te...>]

Hello:

> Thank you very much... but the cvs is not updated again :-(
> I rebuilt the changes using the checkins messages.

If you want i can send the sources to you, i want to release beta 1 
today if possible but before i want to ensure this is solved ;)



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Insert text into blobs

[Alessandro P. <pet...@in...>]

"Carlos Guzman Alvarez" <car...@te...> wrote in message
news:3F6...@te......
> Hello:
>
> If you are using implicit transactions i have committed now a patch for
> them when using blob/array fields.

Thank you very much... but the cvs is not updated again :-(
I rebuilt the changes using the checkins messages.

Ciao,
Alessandro Petrelli.

Re: [Firebird-net-provider] Insert text into blobs

[Carlos G. A. <car...@te...>]

Hello:

> I'm trying to insert some text into a blob field via a stored procedure.
> I declared a parameters like this:
> 
> cmd.Parameters.Add("@IN_DESCRIPTION", FbDbType.Text).Value = "some text
> here";
> 
> but I always get the exception:
> 
> "Object reference not set to an instance of an object."
> 
> in the ExecuteNonQuery() method.
> 
> What am I doing wrong?

If you are using implicit transactions i have committed now a patch for 
them when using blob/array fields.




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain