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

Re: [Firebird-net-provider] Delphi and stored Proc

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

Hello:


I'm making test with C# without here is my test case:


	FbTransaction	myTransaction;
	FbConnection	myConnection = new FbConnection(connectionString);

	myConnection.Open();

	myTransaction = myConnection.BeginTransaction();

	FbCommand myCommand = new FbCommand("EXECUTE PROCEDURE 
GETVARCHARFIELD(?)", myConnection, myTransaction);

	myCommand.CommandType = CommandType.StoredProcedure;

	myCommand.Parameters.Add("@INT_FIELD", FbType.Integer).Direction = 
ParameterDirection.Input;	
	myCommand.Parameters[0].Value = 1;

	myCommand.Parameters.Add("@VARCHAR_FIELD", FbType.VarChar).Direction = 
ParameterDirection.Output;

	myCommand.ExecuteNonQuery();

	Console.WriteLine(myCommand.Parameters[1].Value);

	myTransaction.Commit();

	myConnection.Close();

	Console.ReadLine();


And this is my test SP:

CREATE PROCEDURE GETVARCHARFIELD (
     ID INTEGER)
RETURNS (
     VARCHAR_FIELD VARCHAR(100))
AS
begin
     for select varchar_field from test_table_01 where int_field = :id 
into :varchar_field
     do
         suspend;
end



-- 
Best regards

Carlos Guzma'n A'lvarez
Vigo-Spain

"No tengo dones especiales.So'lo soy apasionadamente curioso"
Albert Einstein, cienti'fico.

Re: [Firebird-net-provider] Delphi and stored Proc

[<car...@te...>]

Hello:


I can't test it now but try with this:

Command := FbCommand.Create('EXECUTE PROCEDURE CODE_SS(?)', Connection,
transaction);


-- 
Best regards

Carlos Guzma'n A'lvarez
Vigo-Spain

"No tengo dones especiales.So'lo soy apasionadamente curioso"
Albert Einstein, cienti'fico.

[Firebird-net-provider] Delphi and stored Proc

[John T. <jr...@gt...>]

Hi,
Seem to have a problem getting the value back from a stored proc. My example
passes a param and expects a return value.

var
             Adapter : FbDataAdapter ;
             command: FbCommand;
             connection: FBConnection;
             transaction: FBTransaction;
             ds: DataSet;
             builder:FbCommandBuilder;
             NEWROW:DATAROW;
parameterHits: FBParameter;
parameterHits2: FBParameter;


    procedure Page_Load2(Sender: System.Object; E: EventArgs);

begin

             connection:=FBConnection.create(MyConnectionString);
             connection.open;
             transaction:=Connection.BeginTransaction;


  Command := FbCommand.Create('EXECUTE PROCEDURE CODE_SS', Connection,
transaction);
  Command.CommandType := CommandType.StoredProcedure;

 parameterHits := FbParameter.Create('P1', FbType.Integer);
 parameterHits.VALUE:='22';
 parameterHits.Direction := ParameterDirection.Input;// output;
 Command.Parameters.Add(parameterHits);

 lblHits.Text:='Total: ' + parameterHits.Value.ToString;

// lets get the results
 parameterHits2 := FbParameter.Create('CTI', FbType.VARCHAR);

 parameterHits2.Direction := ParameterDirection.output;
Command.Parameters.Add(parameterHits2);

 lblHits2.Text:= string(parameterHits2.Value).ToString;

// this produces the following error:
Server Error in '/' Application.
----------------------------------------------------------------------------
----

Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set
to an instance of an object.

Source Error:


Line 149:     // Command.ExecuteNonQuery;
Line 150:
Line 151:     lblHits2.Text:= parameterHits2.Value.ToString;
Line 152:
Line 153:    {


Source File: D:\WINNT\Microsoft.NET\Framework\v1.0.3705\Temporary ASP.NET
Files\root\0950ba24\bc3a41b5\rb2ld54f.0.pas    Line: 151

Stack Trace:


[NullReferenceException: Object reference not set to an instance of an
object.]
   ASP.dategrid_fb_add4_SP_aspx.Page_Load2(Object Sender, EventArgs E) in
D:\WINNT\Microsoft.NET\Framework\v1.0.3705\Temporary ASP.NET
Files\root\0950ba24\bc3a41b5\rb2ld54f.0.pas:151
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +83

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePo
stBackEvent(String eventArgument) +57
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
   System.Web.UI.Page.ProcessRequestMain() +1263




----------------------------------------------------------------------------
----
Version Information: Microsoft .NET Framework Version:1.0.3705.288; ASP.NET
Version:1.0.3705.288

[Firebird-net-provider] Firebird ADO.Net Data Provider Beta 3 available for download.

[<car...@te...>]

Hello:

Firebird ADO.Net Data Provider Beta 3 available for download.


You can view the changelog at:

http://sourceforge.net/project/shownotes.php?release_id=144330


You can download binarys at:

http://prdownloads.sourceforge.net/firebird/FirebirdNetProvider-1.0-Beta3.exe?download


You can download sources at:

http://prdownloads.sourceforge.net/firebird/FirebirdNetProvider-1.0-Beta3-Src.zip?download


You can download documentation at:

http://prdownloads.sourceforge.net/firebird/FirebirdNetProvider-1.0-Beta3-Doc.zip?download



CVS Tag:

NP1_0_Beta3


-- 
Best regards
Carlos Guzmán Álvarez
Vigo-Spain



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Firebird-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-net-provider] A test, please disregard.

[aspxDelphi <web...@as...>]

A test, please disregard.

Re: [Firebird-net-provider] A problem with Firebird SP returning values

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

Hello:

Try with this:

**********************
procedure Page_Load;
var
 myConnection : FBConnection;
 myCommand : FBCommand;
 transaction: FBTransaction;
 parameterHits: FBParameter;
begin
 myConnection :=
FbConnection.Create(ConfigurationSettings.AppSettings.Get('ConnectionString'
));
 myConnection.Open;
 transaction:=myConnection.BeginTransaction;

 myCommand := FbCommand.Create('EXECUTE PROCEDURE HITSGETTOTAL', myConnection, transaction);		<---
 myCommand.CommandType := CommandType.StoredProcedure;

 parameterHits := FbParameter.Create('HITS', FbType.Integer);
 parameterHits.Direction := ParameterDirection.Output;
 myCommand.Parameters.Add(parameterHits);

 myCommand.ExecuteNonQuery;
 lblHits.Text:='Total: ' + parameterHits.Value.ToString;

 transaction.Commit;
 myConnection.Close;
 myCommand.Free;
end;
*************************


Best regards
Carlos Guzma'n A'lvarez
Vigo-Spain


P.S: Please send emails in plain text format.

[Firebird-net-provider] A problem with Firebird SP returning values

[aspxDelphi <web...@as...>]

Hi,all

I have some problems using Firebird stored procedures in an aspx page...

I have a simple SP returning an integer, here it goes:
***************
CREATE PROCEDURE HITSGETTOTAL
RETURNS (HITS INTEGER)
AS
begin
  Select Sum("hits") FROM "SiteHits" into :Hits;
  suspend;
end
*********************

Now the next Delphi code is used to get the returing value, and is NOT
working:

**********************
procedure Page_Load;
var
 myConnection : FBConnection;
 myCommand : FBCommand;
 transaction: FBTransaction;
 parameterHits: FBParameter;
begin
 myConnection :=
FbConnection.Create(ConfigurationSettings.AppSettings.Get('ConnectionString'
));
 myConnection.Open;
 transaction:=myConnection.BeginTransaction;

 myCommand := FbCommand.Create('HITSGETTOTAL', myConnection, transaction);
 myCommand.CommandType := CommandType.StoredProcedure;

 parameterHits := FbParameter.Create('HITS', FbType.Integer);
 parameterHits.Direction := ParameterDirection.Output;
 myCommand.Parameters.Add(parameterHits);

 myCommand.ExecuteNonQuery;
 lblHits.Text:='Total: ' + parameterHits.Value.ToString;

 transaction.Commit;
 myConnection.Close;
 myCommand.Free;
end;
*************************

The error is:
"Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 1
HITSGETTOTAL "
on the line:
" myCommand.ExecuteNonQuery; "


?

.............................................
Zarko Gajic, webmaster to
aspxDelphi.net - bringing the world of
ASP.NET to Delphi developers
http://www.aspxdelphi.net
email: web...@as...
.............................................

Re: [Firebird-net-provider] some suggestions and questions

[<car...@te...>]

Hello:

> as you wish, you are master... :)

Ok but i want to clarify a little why i don't like this:

1.- I think that use Dispose calls is the rigth way for free resources 
in .NET.

2.- Now with the Provider you use commands across transactions, an 
example ( for explain it better :P ):

FbTransaction	myTransaction;
FbConnection	myConnection = new FbConnection(connectionString);

myConnection.Open();

FbCommand myCommand = new FbCommand("UPDATE TEST_TABLE_01 SET CHAR_FIELD 
= ? WHERE INT_FIELD = 1", myConnection);

myCommand.Parameters.Add("@INT_FIELD", FbType.VarChar, "INT_FIELD");	

// Start a new transaction and execute the query
myCommand.Parameters[0].Value = "test";

myTransaction = myConnection.BeginTransaction();
myCommand.Transaction = myTransaction;
myCommand.ExecuteNonQuery();
myTransaction.Commit();

// Start a new transaction and execute the query
myCommand.Parameters[0].Value = "test__";

myTransaction = myConnection.BeginTransaction();
myCommand.Transaction = myTransaction;
myCommand.ExecuteNonQuery();
myTransaction.Commit();

myConnection.Close();



As you can see in this example i'm executing the same query using two 
different transactions :)




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] some suggestions and questions

[Pavol S. <pa...@st...>]

Carlos G.A. wrote:

> Hello:
>
>> if you want some inspiration you can check IBX sources or something=20
>> like=3D20
>> this... The main idea is, that each command have to track his=3D20
>> transaction and each transaction have to track all its commands (same=3D=
20
>> with reader and command)... transaction have list of all commands and=3D=
20
>> each command have its transaction... will tray make for you little=20
>> sample=3D
>
>
>
> I understand it thanks :), but hummm i'm not sure of make it, i don't=20
> like this for transaction and commands, and in each case i have in=20
> mind to close feature developement after beta 3 release :)
>
as you wish, you are master... :)

p.

>
>
>
>
> Best regards
> Carlos Guzm=E1n =C1lvarez
> Vigo-Spain
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Etnus, makers of TotalView, The=20
> debugger for complex code. Debugging C/C++ programs can leave you=20
> feeling lost and disoriented. TotalView can help you find your way.=20
> Available on major UNIX and Linux platforms. Try it free. www.etnus.com
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] some suggestions and questions

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

Hello:

> if you want some inspiration you can check IBX sources or something like=20
> this... The main idea is, that each command have to track his=20
> transaction and each transaction have to track all its commands (same=20
> with reader and command)... transaction have list of all commands and=20
> each command have its transaction... will tray make for you little sample=


I understand it thanks :), but hummm i'm not sure of make it, i don't 
like this for transaction and commands, and in each case i have in mind 
to close feature developement after beta 3 release :)





Best regards
Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] some suggestions and questions

[Pavol S. <pa...@st...>]

Carlos Guzm=E1n =C1lvarez wrote:

> Hello:
>
>>
>> This is already made, a connection can have only one active=20
>> transaction and this is rollbacked when you close or dipose=20
>> connection, but i think can be good to drop all active prepared=20
>> statements when you close connection, any thoughts??
>>
>
> I have added to the CVS some changes for allow this, and i have added=20
> the changes for the error that you report yesterday with named=20
> parameters.
>
>
>
Hi,

if you want some inspiration you can check IBX sources or something like=20
this... The main idea is, that each command have to track his=20
transaction and each transaction have to track all its commands (same=20
with reader and command)... transaction have list of all commands and=20
each command have its transaction... will tray make for you little sample=
...

p.

p.

Re: [Firebird-net-provider] some suggestions and questions

[<car...@te...>]

Hello:

> 
> This is already made, a connection can have only one active transaction 
> and this is rollbacked when you close or dipose connection, but i think 
> can be good to drop all active prepared statements when you close 
> connection, any thoughts??
> 

I have added to the CVS some changes for allow this, and i have added 
the changes for the error that you report yesterday with named parameters.



-- 
Un saludo

Carlos Guzmán Álvarez
Vigo-España

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] some suggestions and questions

[<car...@te...>]

Hello:

> there is no problem release it now as beta 3... you will have more time 
> to kill bugs :)

:)

> 
> in SDK 1.1 beta is not better documentation to permision classes and i 
> think that there is few important changes to SDK 1.0 (may be problems 
> with compatibility)... Anyway i dont understand this permisions yet. For 
> this im very curious how you will implement it...

I´m too :) i don't know how i will made :)

 > FbCommand close all assigned FbReaders
 > FbTransaction close all assigned FbCommands

I´m not sure about this ....


 > FbConnection.Close dispose all assigned transactions???

This is already made, a connection can have only one active transaction 
and this is rollbacked when you close or dipose connection, but i think 
can be good to drop all active prepared statements when you close 
connection, any thoughts??





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] some suggestions and questions

[Pavol S. <pa...@st...>]

hi,

there is no problem release it now as beta 3... you will have more time 
to kill bugs :)

in SDK 1.1 beta is not better documentation to permision classes and i 
think that there is few important changes to SDK 1.0 (may be problems 
with compatibility)... Anyway i dont understand this permisions yet. For 
this im very curious how you will implement it...

i have one feature request :)
there is still problem with that dispose... If you dispose all 
(FbCommand, FbReader, FbTransaction) its fine, but you have to call 
dispose manually... What about to make FbCommand close all assigned 
FbReaders and FbTransaction close all assigned FbCommands and finally 
FbConnection.Close dispose all assigned transactions???
Calling dispose manually is against .Net filozofy of garbage collecting...

p.

Re: [Firebird-net-provider] some suggestions and questions

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

Hello:

> I have planned to release a beta 3 tomorrow and rc1 in March 20


March 25, sorry ... :)





Best regards
Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] some suggestions and questions

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

Hello:

> sorry i was in that this is beta 3  :-) 

No problem :)

> Anyway you done lot of work form beta 2 release and i think its time 
> to release beta 3 or RC1... 

I have planned to release a beta 3 tomorrow and rc1 in March 20, do you 
mean that can be better to release the RC1 yet ??
I have no problem in release it as RC1 tomorrow but with this i will add 
a new rc version to the roadmap:

-Beta 3. 5/03/2003.

-Release Candidate 1. 25/03/2003.

-Release Candidate 2. 15/04/2003.

-Release Candidate 3. 5/05/2003.

-Release 1.0. 25/05/2003.

>
> im really interested, how you implement FbPermision and 
> FbPermisionAtribute :-) 


They are not implemented yet, i have not found good documentation and 
examples on how this needs to work, this will wait until version 1.0 was 
released, and i want to see if the version 1.1 of .NET Framework have 
better documentation for these classess.



Best regards
Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] some suggestions and questions

[Pavol S. <pa...@st...>]

Carlos G.A. wrote:

> Hello:
>
>> 1. why on firebird.sourceforge.net is not new version of Provider???=20
>> Same with go-mono.com and ibphoenix.com...=20
>
>
>
> I don't understand this :), in firebird.sourceforge.net it's beta 2=20
> version for download, or you mean to a web page with an explain about=20
> .net provider features, etc...??
>
>> 2. What features are missing in provider now??? Isnt there time to=20
>> release RC1 ?=20
>
sorry i was in that this is beta 3  :-) Anyway you done lot of work form=20
beta 2 release and i think its time to release beta 3 or RC1...
im really interested, how you implement FbPermision and=20
FbPermisionAtribute :-)

>
>
> Features missed are:
>
>    1. Array field support.
>
>    2. Implementation of FbPermission and FbPermissionAttribute
>      3. Connection and command timeouts.
>
>
> But all of them will wait until version 1.0 was released.
>
> I have in mind to relase a new beta tomorrow.
>
>
>
> Best regards
> Carlos Guzm=E1n =C1lvarez
> Vigo-Spain

Re: [Firebird-net-provider] A problem with C# sample code

[aspxDelphi <web...@as...>]

Thanks, works, and works with Delphi too.

.............................................
Zarko Gajic, webmaster to
aspxDelphi.net - bringing the world of
ASP.NET to Delphi developers
http://www.aspxdelphi.net
email: web...@as...
.............................................
----- Original Message -----
From: "Pavol STAREK" <pa...@st...>
To: "aspxDelphi" <web...@as...>; "FirebirdNetProvider"
<fir...@li...>
Sent: Tuesday, March 04, 2003 10:34 AM
Subject: Re: [Firebird-net-provider] A problem with C# sample code


> hi,
>
> yes that example is wrong;
>  using System;
>  using System.Data;
>  using FirebirdSql.Data.Firebird;
>
>  public class Test
>  {
>     public static void Main(string[] args)
>     {
>         string connectionString =
>        "Database=C:\\PROGRAM FILES\\FIREBIRD\\EXAMPLES\\EMPLOYEE.GDB;" +
>        "User=SYSDBA;" +
>        "Password=masterkey;" +
>        "Dialect=3;" +
>        "Server=localhost";
>        IDbConnection dbcon = new FbConnection(connectionString);
>        dbcon.Open();
> ->     IDbTransaction dbtran = dbcon.BeginTransaction();
>        IDbCommand dbcmd = dbcon.CreateCommand();
>        string sql = "SELECT * FROM employee";
>        dbcmd.CommandText = sql;
> ->     dbcmb.Transaction = dbtran;
>        IDataReader reader = dbcmd.ExecuteReader();
>        while(reader.Read()) {
>             object dataValue = myReader.GetValue(0);
>             string sValue = dataValue.ToString();
>             Console.WriteLine("Value: " + sValue);
>        }
>        // clean up
>        reader.Close();
>        reader = null;
>        dbcmd.Dispose();
>        dbcmd = null;
> ->     dbtran.Commit();
> ->     dbtran.Dispose();
>        dbcon.Close();
>        dbcon = null;
>     }
>
>
>  }
>
>
> aspxDelphi wrote:
>
> >Hi, all
> >
> >I'm trying to compile that C# sample code from
> >http://www.go-mono.com/firebird.html - an example of using
> >firebird-net-provider on Firebird/Interbase...
> >
> >While trying to build a sample aspx page using the code from the link
above,
> >the
> >"Command must have a valid Transaction"
> >comes on the line:
> >IDataReader reader = dbcmd.ExecuteReader();
> >
> >Anybody?
> >
> >.............................................
> >Zarko Gajic, webmaster to
> >aspxDelphi.net - bringing the world of
> >ASP.NET to Delphi developers
> >http://www.aspxdelphi.net
> >email: web...@as...
> >.............................................
> >
> >
> >
> >-------------------------------------------------------
> >This SF.net email is sponsored by: Etnus, makers of TotalView, The
debugger
> >for complex code. Debugging C/C++ programs can leave you feeling lost and
> >disoriented. TotalView can help you find your way. Available on major
UNIX
> >and Linux platforms. Try it free. www.etnus.com
> >_______________________________________________
> >Firebird-net-provider mailing list
> >Fir...@li...
> >https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> >
> >
>
>
>
>

Re: [Firebird-net-provider] some suggestions and questions

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

Hello:

> 1. why on firebird.sourceforge.net is not new version of Provider??? 
> Same with go-mono.com and ibphoenix.com... 


I don't understand this :), in firebird.sourceforge.net it's beta 2 
version for download, or you mean to a web page with an explain about 
.net provider features, etc...??

> 2. What features are missing in provider now??? Isnt there time to 
> release RC1 ? 


Features missed are:

    1. Array field support.

    2. Implementation of FbPermission and FbPermissionAttribute
   
    3. Connection and command timeouts.


But all of them will wait until version 1.0 was released.

I have in mind to relase a new beta tomorrow.



Best regards
Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] some suggestions and questions

[Pavol S. <pa...@st...>]

hi,

i wan to ask:
1. why on firebird.sourceforge.net is not new version of Provider??? 
Same with go-mono.com and ibphoenix.com...

2. What features are missing in provider now??? Isnt there time to 
release RC1 ?

p.

Re: [Firebird-net-provider] A problem with C# sample code

[Pavol S. <pa...@st...>]

hi,

yes that example is wrong;
 using System;
 using System.Data;
 using FirebirdSql.Data.Firebird;
 
 public class Test 
 {
    public static void Main(string[] args)
    {
        string connectionString = 
	       "Database=C:\\PROGRAM FILES\\FIREBIRD\\EXAMPLES\\EMPLOYEE.GDB;" +
	       "User=SYSDBA;" +
	       "Password=masterkey;" +
	       "Dialect=3;" +
	       "Server=localhost";
       IDbConnection dbcon = new FbConnection(connectionString);
       dbcon.Open();
->     IDbTransaction dbtran = dbcon.BeginTransaction();
       IDbCommand dbcmd = dbcon.CreateCommand();
       string sql = "SELECT * FROM employee";
       dbcmd.CommandText = sql;
->     dbcmb.Transaction = dbtran;
       IDataReader reader = dbcmd.ExecuteReader();
       while(reader.Read()) {
            object dataValue = myReader.GetValue(0);
            string sValue = dataValue.ToString();
            Console.WriteLine("Value: " + sValue);
       }
       // clean up
       reader.Close();
       reader = null;
       dbcmd.Dispose();
       dbcmd = null;
->     dbtran.Commit();
->     dbtran.Dispose();
       dbcon.Close();
       dbcon = null;
    }


 }


aspxDelphi wrote:

>Hi, all
>
>I'm trying to compile that C# sample code from
>http://www.go-mono.com/firebird.html - an example of using
>firebird-net-provider on Firebird/Interbase...
>
>While trying to build a sample aspx page using the code from the link above,
>the
>"Command must have a valid Transaction"
>comes on the line:
>IDataReader reader = dbcmd.ExecuteReader();
>
>Anybody?
>
>.............................................
>Zarko Gajic, webmaster to
>aspxDelphi.net - bringing the world of
>ASP.NET to Delphi developers
>http://www.aspxdelphi.net
>email: web...@as...
>.............................................
>
>
>
>-------------------------------------------------------
>This SF.net email is sponsored by: Etnus, makers of TotalView, The debugger 
>for complex code. Debugging C/C++ programs can leave you feeling lost and 
>disoriented. TotalView can help you find your way. Available on major UNIX 
>and Linux platforms. Try it free. www.etnus.com
>_______________________________________________
>Firebird-net-provider mailing list
>Fir...@li...
>https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>  
>

Re: [Firebird-net-provider] A problem with C# sample code

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

Hello:

Test with this:

 using System;
 using System.Data;
 using FirebirdSql.Data.Firebird;
 
 public class Test 
 {
    public static void Main(string[] args)
    {
	string connectionString = 
	       "Database=C:\\PROGRAM FILES\\FIREBIRD\\EXAMPLES\\EMPLOYEE.GDB;" +
	       "User=SYSDBA;" +
	       "Password=masterkey;" +
	       "Dialect=3;" +
	       "Server=localhost";
	IDbConnection dbcon = new FbConnection(connectionString);
	dbcon.Open();
	IDbTransaction dbtxn = dbcon.BeginTransction();
       	IDbCommand dbcmd = dbcon.CreateCommand();
       	string sql = "SELECT * FROM employee";
	dbcmd.CommandText = sql;
	dbcmd.Transction = dbtxn; 
       	IDataReader reader = dbcmd.ExecuteReader();
       	while(reader.Read()) {
            object dataValue = myReader.GetValue(0);
            string sValue = dataValue.ToString();
            Console.WriteLine("Value: " + sValue);
       	}
       	// clean up
       	reader.Close();
       	reader = null;
       	dbcmd.Dispose();
       	dbcmd = null;
       	dbcon.Close();
       	dbcon = null;
    }
}





Best regards
Carlos Guzmán Álvarez
Vigo-Spain


P.S: Please send message to the list in plain text format, thanks.

[Firebird-net-provider] A problem with C# sample code

[aspxDelphi <web...@as...>]

Hi, all

I'm trying to compile that C# sample code from
http://www.go-mono.com/firebird.html - an example of using
firebird-net-provider on Firebird/Interbase...

While trying to build a sample aspx page using the code from the link above,
the
"Command must have a valid Transaction"
comes on the line:
IDataReader reader = dbcmd.ExecuteReader();

Anybody?

.............................................
Zarko Gajic, webmaster to
aspxDelphi.net - bringing the world of
ASP.NET to Delphi developers
http://www.aspxdelphi.net
email: web...@as...
.............................................

Re: [Firebird-net-provider] may be bug

[<car...@te...>]

Hello:

> im using this
> myCommand.Parameters.Add("@p10", my_value);
> 
> and try put there 11 parameters named from @p0 to p@11...


It's a problem with named parameters replacement with ?, now it will be 
made using Regular Expressions, it´s fixed in CVS now, i think now will 
work as expected, thanks very much.





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] may be bug

[Pavol S. <pa...@st...>]

im using this
myCommand.Parameters.Add("@p10", my_value);

and try put there 11 parameters named from @p0 to p@11...

p