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

commit after each DDL (Re: [Firebird-net-provider] Bug with multiple commands in same transaction)

[David G. <li...@za...>]

(Cc-ing to the docs list).

Pierre Arnaud wrote:
> You mean that after every DDL statement, I have to do a commit also
> on my own. This seems pretty weird.

This is also one of my first traps in Firebird :) I hope this makes it 
to a prominent place in the FAQ.

-- 
dave

Re: [Firebird-net-provider] Odd namespace for Firebird

[Pierre A. <pie...@op...>]

Carlos Guzm=E1n =C1lvarez wrote:
>> Just to compare, in .NET 1.1, there are :
>>
>>     System.Data.Odbc
>>     System.Data.OleDb
>>     System.Data.OracleClient
>>     System.Data.SqlClient
>
> But all these providers are included in the .NET core.
>
> Microsoft recommentdation for namespace is :
>
> CompanyName.TechnologyName

Yes, you are right. Microsoft wants to avoid possible name
collisions with the namespaces. If only I could do some sort
of magic "typedef" on the namespaces and rename the FirebirdSql
base into System :-)

OK, so let's live with the current name !


    Pierre

Re: [Firebird-net-provider] Bug with multiple commands in same transaction

[Pierre A. <pie...@op...>]

Carlos Guzm=E1n =C1lvarez wrote:
> If you have firebird installed you have isql too, just see in the
> firebird bin directory ( isql.exe ).

Oh. Thanks ! I was not aware of that.

>> So how can I do what I want, namely create a table and fill it
>> in, then rollback the table creation ?
>
> But you don't want to mantain the table created after have it filled ??
> In that case, Why not ?? :)

Well, I wanted to create a few tables and fill them and make it look
like an atomic operation to other processes; either the tables would
be there with their content, or they would not. So in fact what was
of interest here was really the fact that the transaction was hiding
the tables until the COMMIT.

> If you want to mantain it created after have it filled, and drop it if
> you get an error, at this moment you can do:
>
> (1) Start transaction.
> (2) Create table.
> (3) Commit transaction (using Commit method)
> (4) Start transaction.
> (5) Fill the Table
> (6) Commit transaction (using Commit method)
>
> if you get an error when filling:
>
> (1) Rollback transaction.
> (2) Drop the table.
>
> or:
>
> (1) Start transaction.
> (2) Create table.
> (3) Commit transction (using CommitRetaining method.)
> (4) Fill the Table.
> (5) Commit transaction (using Commit method.)
>
> if you get an error when filling:
>
> (1) Rollback transaction.
> (2) Drop the table.

Yes, I guess that this is what I will do, and I will have to add
logic to handle the presence of empty tables, but this should
not be too complicated.

Thanks for your help.

    Pierre

Re: [Firebird-net-provider] Bug with multiple commands in same transaction

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

Hello:

> I don't have ISQL, but I believe what you tell me. It just seems
> really strange. Adding the "SET AUTODLL OFF;" line in IBExpert
> causes also IBExpert to generate an error on the INSERT statement.

If you have firebird installed you have isql too, just see in the 
firebird bin directory ( isql.exe ).

> So how can I do what I want, namely create a table and fill it
> in, then rollback the table creation ?

But you don't want to mantain the table created after have it filled ?? 
In that case, Why not ?? :)

If you want to mantain it created after have it filled, and drop it if 
you get an error, at this moment you can do:

(1) Start transaction.
(2) Create table.
(3) Commit transaction (using Commit method)
(4) Start transaction.
(5) Fill the Table
(6) Commit transaction (using Commit method)

if you get an error when filling:

(1) Rollback transaction.
(2) Drop the table.

or:

(1) Start transaction.
(2) Create table.
(3) Commit transction (using CommitRetaining method.)
(4) Fill the Table.
(5) Commit transaction (using Commit method.)

if you get an error when filling:

(1) Rollback transaction.
(2) Drop the table.


--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

P.S.: I'm thinking on add to the FbCommand a new property called 
FbCommandType for allow to know which type of command is being executed, 
it will be possible to know it after have the statement prepared 
(GdsStatement has yet this information in the StatementType property), 
comments are wellcome ;)

Re: [Firebird-net-provider] Bug with multiple commands in same transaction

[Pierre A. <pie...@op...>]

Carlos Guzm=E1n =C1lvarez wrote:
>> CREATE TABLE X(A INTEGER NOT NULL, B INTEGER);
>> INSERT INTO X(A, B) VALUES (1,1);
>> COMMIT WORK;
>
> I have tested it from the sql editor of ib expert, but just test this i=
n
> the script executive:
>
> CREATE TABLE X(A INTEGER NOT NULL, B INTEGER);
>
> You are not going to get a message telling that there are uncommited
> statements ( this message appears if you exec only the insert for
> example ), i think that they are making an autocommit for DDL
> statements, as ISQL makes by default.

You mean that after every DDL statement, I have to do a commit also
on my own. This seems pretty weird.

But I have to agree with you: IBExpert seems to be committing its
work automagically.

> Has you tested the sample i have sent for ISQL ??

I don't have ISQL, but I believe what you tell me. It just seems
really strange. Adding the "SET AUTODLL OFF;" line in IBExpert
causes also IBExpert to generate an error on the INSERT statement.


So how can I do what I want, namely create a table and fill it
in, then rollback the table creation ?

Thanks a lot.

    Pierre

Re: [Firebird-net-provider] Bug with multiple commands in same transaction

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

Hello:

> I just ran the following script in IBExpert's "Script Executive",
> and it works just fine :
> 
> CREATE TABLE X(A INTEGER NOT NULL, B INTEGER);
> INSERT INTO X(A, B) VALUES (1,1);
> COMMIT WORK;

I have tested it from the sql editor of ib expert, but just test this in 
the script executive:

CREATE TABLE X(A INTEGER NOT NULL, B INTEGER);

You are not going to get a message telling that there are uncommited 
statements ( this message appears if you exec only the insert for 
example ), i think that they are making an autocommit for DDL 
statements, as ISQL makes by default.

Has you tested the sample i have sent for ISQL ??



--
Best regards

Carlos Guzmán álvarez
Vigo-Spain

Re: [Firebird-net-provider] Bug with multiple commands in same transaction

[Pierre A. <pie...@op...>]

Carlos Guzm=E1n =C1lvarez wrote:
>> Certainly not, transactions are conceptualy for making a serie of SQL
>> command, and then commit (or rollback) all of them if ok (or not)
>>
>> (1) START TRANSACTION
>> (2) CREATE TABLE X(A INTEGER NOT NULL, B INTEGER);
>> (3)  INSERT INTO X(A, B) VALUES (1,1);
>> (4) COMMIT / END TRANSACTION
>
> I think it's working ok.
>
> The CREATE TABLE is a DDL command and i think that will be not possible
> to make anything with the table until the transaction is commited.

I just ran the following script in IBExpert's "Script Executive",
and it works just fine :

CREATE TABLE X(A INTEGER NOT NULL, B INTEGER);
INSERT INTO X(A, B) VALUES (1,1);
COMMIT WORK;

I don't see why the table creation should not be visible from within
the transaction. This would be really silly !?

> I have make the same test using IBExpert and raises the same error.

See my example; does it raise an error in your IBExpert ?

> If i'm wrong, please correct me :)

I am no SQL guru, but the fact that a table is not visible unless
the full transaction is commited does not make sense to me.

    Pierre

Re: [Firebird-net-provider] Bug with multiple commands in same transaction

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

Hello:

> Certainly not, transactions are conceptualy for making a serie of SQL
> command, and then commit (or rollback) all of them if ok (or not)
> 
> (1) START TRANSACTION
> (2) CREATE TABLE X(A INTEGER NOT NULL, B INTEGER);
> (3)  INSERT INTO X(A, B) VALUES (1,1);
> (4) COMMIT / END TRANSACTION

I think it's working ok.

The CREATE TABLE is a DDL command and i think that will be not possible 
to make anything with the table until the transaction is commited.

I have make the same test using IBExpert and raises the same error.

The same can be applied to isql, try this on it:

SET AUTODDL OFF;
CREATE TABLE X(A INTEGER NOT NULL, B INTEGER);
INSERT INTO X(A, B) VALUES (1,1);

I get the same error.


If i'm wrong, please correct me :)




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Bug with multiple commands in same transaction

[Denis D. <fir...@De...>]

Hi,
about your replay to:

> > - Created transaction with IsolationLevel.RepeatableRead.
> > - Executed two commands using FbCommand, while keeping the
> >   same transaction active :
> >
> >   (1)  CREATE TABLE X(A INTEGER NOT NULL, B INTEGER);
> >   (2)  INSERT INTO X(A, B) VALUES (1,1);
>
> I think it's working ok, as the first command is not committed yet.

Certainly not, transactions are conceptualy for making a serie of SQL
command, and then commit (or rollback) all of them if ok (or not)

(1) START TRANSACTION
(2) CREATE TABLE X(A INTEGER NOT NULL, B INTEGER);
(3)  INSERT INTO X(A, B) VALUES (1,1);
(4) COMMIT / END TRANSACTION

should work, without "commit" in the middle.
Is'nt that true ?

Best regard,
-- 
Denis Dumoulin

Re: [Firebird-net-provider] Bug with multiple commands in same transaction

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

Hello:

> I have done following:
> 
> - Created transaction with IsolationLevel.RepeatableRead.
> - Executed two commands using FbCommand, while keeping the
>   same transaction active :
> 
>   (1)  CREATE TABLE X(A INTEGER NOT NULL, B INTEGER);
>   (2)  INSERT INTO X(A, B) VALUES (1,1);

I think it's working ok, as the first command is not committed yet.





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Odd namespace for Firebird

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

Hello:

> I am using FirebirdSql.Data namespace since a few months now, and I
> still don't feel at ease with the choice of the namespace. I'd be
> glad to hear from others.
> 
> Why isn't all the Firebird stuff just in the System.Data.Firebird
> namespace ? It would make much more sense than having this separate
> FirebirdSql namespace, don't you agree ?
> 
> Just to compare, in .NET 1.1, there are :
> 
>     System.Data.Odbc
>     System.Data.OleDb
>     System.Data.OracleClient
>     System.Data.SqlClient

But all these providers are included in the .NET core.

Microsoft recommentdation for namespace is :

	CompanyName.TechnologyName


This makes that the actual namespace is ok, i'm thinking in call the 
provider FbClient or FirebirdClient, just for give a name to the 
project, and use as namespace:

	FirebirdSql.Data.FbClient
or
	FirebirdSql.Data.FirebirdClient

Comments are wellcome arround this :)


The Microsoft ODBC data provider for .NET 1.0 has as namespace :

	Microsoft.Data.Odbc

Which matches too with the microsoft namespace recommedation





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] msvcr70.dll

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

Hello:

> I just tried to install the .net provider (released 26 may 2003) onto my
> machine and got an error during the install process saying that
> msvcr70.dll could not be found in a big list of paths.


 From the KNOWN.TXT file:

Problem with MSVCR70.dll
------------------------

Solution from an answer of Andrew C. Goodall in the developement list:

Do a file search on the pc/server where you installed .net framework
The dll is there but it's in a temp folder and needs to be copied to the 
main .net folder.

my msvcr70.dll was in C:\WINNT\SYSTEM32\URTTemp
I copied it to C:\WINNT\Microsoft.NET\Framework\v1.0.3705

Then I re-installed Firebird .NET provider and all was well in the world.






--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Bug with multiple commands in same transaction

[Pierre A. <pie...@op...>]

Hello,

I have done following:

- Created transaction with IsolationLevel.RepeatableRead.
- Executed two commands using FbCommand, while keeping the
  same transaction active :

  (1)  CREATE TABLE X(A INTEGER NOT NULL, B INTEGER);
  (2)  INSERT INTO X(A, B) VALUES (1,1);

When executing command (2), I get an error stating that I
am referring to an unknown table named X (but it should
exist !?) with SQL error code -204.

I am using latest .NET provider 1.5 BETA (last update in
CHANGELOG is from 2003-11-10), .NET 1.1, Firebird 1.5 RC7.

Kind regards,

    Pierre

[Firebird-net-provider] Re: Firebird-net-provider digest, Vol 1 #261 - 1 msg

[Josauro S.J. <jo...@ca...>]

I had the same error, than I found msvcr71.dll  in windows directory, =
put into system32 and rename to msvcr70.dll , work fine....

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: fir...@li...=20
  To: fir...@li...=20
  Sent: Thursday, November 27, 2003 2:04 AM
  Subject: Firebird-net-provider digest, Vol 1 #261 - 1 msg


  Send Firebird-net-provider mailing list submissions to
  fir...@li...

  To subscribe or unsubscribe via the World Wide Web, visit
  https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
  or, via email, send a message with subject or body 'help' to
  fir...@li...

  You can reach the person managing the list at
  fir...@li...

  When replying, please edit your Subject line so it is more specific
  than "Re: Contents of Firebird-net-provider digest..."


  Today's Topics:

     1. msvcr70.dll (Martin Catherall)

  --__--__--

  Message: 1
  Date: Thu, 27 Nov 2003 15:54:52 +1300
  From: "Martin Catherall" <mc...@we...>
  To: <fir...@li...>
  Subject: [Firebird-net-provider] msvcr70.dll

  Hi,

  I just tried to install the .net provider (released 26 may 2003) onto =
my
  machine and got an error during the install process saying that
  msvcr70.dll could not be found in a big list of paths.

  I then tried to install the lastest version, data provider for .net
  framework 1.1 (released 12 nov 2003) and got exactly the same error.

  I would like to ask for advice on the following.

  1. What is the best course of action here in order to use the =
provider??
  Move msvcr70.dll into one of the dirs mentions in the error message =
and
  re-register it from that location.

  2 which version of the provider is the prefered version based on my
  curcumstances below

  Using firebird 1.0
  Using .net 1.1 --- I have only ever had vs 2003 installed on my =
machine.

  I appreciated any comments and help.

  Cheers

  Martin.



  Check out www.ubique.webscape.co.nz  Ubique --> "Drives Your Business"

  W  E  B  S  C  A  P  E
  PO Box 22571
  25 Carlyle Street
  Christchurch
  http://www.webscape.co.nz

  Phone 03 964 4020
  Fax     03 365 9115
  Email  mc...@we...

  =
=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D=
3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D
  =
=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D=
3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D
  =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D
  (This e-mail has been scanned with MailMarshal)



  --__--__--

  _______________________________________________
  Firebird-net-provider mailing list
  Fir...@li...
  https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


  End of Firebird-net-provider Digest

[Firebird-net-provider] Odd namespace for Firebird

[Pierre A. <pie...@op...>]

Hi all,

I am using FirebirdSql.Data namespace since a few months now, and I
still don't feel at ease with the choice of the namespace. I'd be
glad to hear from others.

Why isn't all the Firebird stuff just in the System.Data.Firebird
namespace ? It would make much more sense than having this separate
FirebirdSql namespace, don't you agree ?

Just to compare, in .NET 1.1, there are :

    System.Data.Odbc
    System.Data.OleDb
    System.Data.OracleClient
    System.Data.SqlClient

etc.

    Pierre

[Firebird-net-provider] msvcr70.dll

[Martin C. <mc...@we...>]

Hi,

I just tried to install the .net provider (released 26 may 2003) onto my
machine and got an error during the install process saying that
msvcr70.dll could not be found in a big list of paths.

I then tried to install the lastest version, data provider for .net
framework 1.1 (released 12 nov 2003) and got exactly the same error.

I would like to ask for advice on the following.

1. What is the best course of action here in order to use the provider??
Move msvcr70.dll into one of the dirs mentions in the error message and
re-register it from that location.

2 which version of the provider is the prefered version based on my
curcumstances below

Using firebird 1.0
Using .net 1.1 --- I have only ever had vs 2003 installed on my machine.

I appreciated any comments and help.

Cheers

Martin.



Check out www.ubique.webscape.co.nz  Ubique --> "Drives Your Business"

W  E  B  S  C  A  P  E
PO Box 22571
25 Carlyle Street
Christchurch
http://www.webscape.co.nz

Phone 03 964 4020
Fax     03 365 9115
Email  mc...@we...

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D
(This e-mail has been scanned with MailMarshal)

Re: [Firebird-net-provider] Getbytes don't return blob data

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

Hello:

>  Hi, 
> I am using Firebird .Net 1.4 beta4 net framework version 1.1.
> The  getbytes would not return a data for blob columns. 
> It look like have a bug in Getbytes procedure. 

Seems to be working for me, here is the source:

[Test]
public void ReaderGetBytes()
{
	int id_value = System.DateTime.Now.Millisecond + 20000;
	
	string selectText = "SELECT blob_field FROM TEST WHERE int_field = " + 
id_value.ToString();
	string insertText = "INSERT INTO TEST (int_field, blob_field) 
values(@int_field, @blob_field)";
	
	Console.WriteLine("\r\n\r\nFbDataReader.GetBytes with Binary Blob Test");
	
	Console.WriteLine("Generating an array of temp data");
	// Generate an array of temp data
	byte[] insert_values = new byte[100000*4];
	RNGCryptoServiceProvider rng = new RNGCryptoServiceProvider();
	rng.GetBytes(insert_values);
	
	Console.WriteLine("Executing insert command");

	// Execute insert command
	FbTransaction transaction = Connection.BeginTransaction();

	FbCommand insert = new FbCommand(insertText, Connection, transaction);
	insert.Parameters.Add("@int_field", FbDbType.Integer).Value = id_value;
	insert.Parameters.Add("@blob_field", FbDbType.Binary).Value = 
insert_values;
	insert.ExecuteNonQuery();

	transaction.Commit();

	Console.WriteLine("Checking inserted values");

	// Check that inserted values are correct
	FbCommand select = new FbCommand(selectText, Connection);

	FbDataReader reader = select.ExecuteReader();

	int		index		= 0;
	int		segmentSize	= 1000;
	byte[]	select_values = new byte[100000*4];
	while (reader.Read())
	{
		while (index < 400000)
		{
			reader.GetBytes(0, index, select_values, index, segmentSize);

			index += segmentSize;
		}
	}

	for (int i = 0; i < insert_values.Length; i++)
	{
		if (insert_values[i] != select_values[i])
		{
			throw new Exception("differences at index " + i.ToString());
		}
	}
}





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Getbytes don't return blob data

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

Hello:

>  Hi, 
> I am using Firebird .Net 1.4 beta4 net framework version 1.1.
> The  getbytes would not return a data for blob columns. 
> It look like have a bug in Getbytes procedure. 
> Below is the source.

I will try to review this later today, you can get blob value using 
GetValue too.






--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Getbytes don't return blob data

[bcteh_98 <bct...@ya...>]

 Hi, 
I am using Firebird .Net 1.4 beta4 net framework version 1.1.
The  getbytes would not return a data for blob columns. 
It look like have a bug in Getbytes procedure. 
Below is the source.

Pls Help ..
Regards
Teh

Dim sql As String
        sql = "SELECT Picture FROM Categories WHERE categoryid=11"
          Dim cmd As New FbCommand(sql)
        Dim conn As New FbConnection(ConnectionStr)
        conn.Open()
        Dim tx As FbTransaction
        tx = conn.BeginTransaction
        cmd.Connection = conn
        cmd.Transaction = tx
        Dim PictureCol As Integer = 0
        Dim dr As FbDataReader = cmd.ExecuteReader()
        Dim id As Integer
        dr.Read()
        ' id = dr.GetInt32(0)
        Dim b(dr.GetBytes(PictureCol, 0, Nothing, 0, 
Integer.MaxValue) - 1) As Byte
        '  Dim b(dr.GetValue(PictureCol))
        dr.GetBytes(PictureCol, 0, b, 0, b.Length)

        dr.Close()
        conn.Close()
          Dim destfilepath As String = "d:\test15beta.jpg"
        Dim fs As New System.IO.FileStream(DestFilePath, 
IO.FileMode.Create, IO.FileAccess.Write)
        fs.Write(b, 0, b.Length)
        fs.Close()

Re: [Firebird-net-provider] FirebirdSql.Data.INGDS.GDSException

[Josauro S.J. <jo...@ca...>]

Ok, I found the problem than I don't put REC_VALOR_TAXA in select ;) and =
than it return NULL .
Thanks for all help.

Josauro S.J.
Diretor
e-mail: jo...@ca...
   site: www.casasoft.inf.br

Portal de im=F3veis www.IndicadorDeIm=F3veis.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, November 25, 2003 9:23 AM
  Subject: Re: [Firebird-net-provider] =
FirebirdSql.Data.INGDS.GDSException


  Hello:

  > Ok, it's work fine.
  > But other question...
  > Variable  VR_VALOR_BRUTO   and VR_VALOR_LIQUDO return nothing =
values, do=20
  > you know why ?=20

  No, think in that i can't test it ;), just try to move the IF .. ENDIF =

  block:

  CREATE PROCEDURE GET_RECIBOS (
        CLI_REFERENCIA VARCHAR(12))
  RETURNS (
       REC_CODIGO DOUBLE PRECISION,
       REC_CLIENTE DOUBLE PRECISION,
       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);
  DECLARE VARIABLE VR_CLIENTE DOUBLE PRECISION;
  begin
     /* Procedure Text */
     SELECT CODIGO FROM get_codigo_cliente(:CLI_REFERENCIA)
     INTO :VR_CLIENTE;

     FOR SELECT REC_CODIGO,
            REC_CLIENTE,
            REC_DATA,
            REC_DATA_LIMITE,
            REC_VALOR_ALUGUEL,
            REC_MULTA_DESCONTO,
            REC_VALOR_MULTA_DESCONTO,
            REC_DESCRICAO_PERIODO,
            REC_NUMERO_RECIBO,
            REC_NUMERO_BANCARIO
     FROM RECIBO
     WHERE REC_CLIENTE =3D :VR_CLIENTE
     INTO :REC_CODIGO,
          :REC_CLIENTE,
          :REC_DATA,
          :REC_DATA_LIMITE,
          :REC_VALOR_ALUGUEL,
          :VR_MULTA_DESCONTO,
          :REC_VALOR_MULTA_DESCONTO,
          :REC_DESCRICAO_PERIODO,
          :REC_NUMERO_RECIBO,
          :REC_NUMERO_BANCARIO
     DO
     BEGIN   =20
  SUSPEND;
     END

     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
  END



  --
  Best regards

  Carlos Guzm=E1n =E1lvarez
  Vigo-Spain

Re: [Firebird-net-provider] FirebirdSql.Data.INGDS.GDSException

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

Hello:

> Ok, it's work fine.
> But other question...
> Variable  VR_VALOR_BRUTO   and VR_VALOR_LIQUDO return nothing values, do 
> you know why ? 

No, think in that i can't test it ;), just try to move the IF .. ENDIF 
block:

CREATE PROCEDURE GET_RECIBOS (
      CLI_REFERENCIA VARCHAR(12))
RETURNS (
     REC_CODIGO DOUBLE PRECISION,
     REC_CLIENTE DOUBLE PRECISION,
     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);
DECLARE VARIABLE VR_CLIENTE DOUBLE PRECISION;
begin
   /* Procedure Text */
   SELECT CODIGO FROM get_codigo_cliente(:CLI_REFERENCIA)
   INTO :VR_CLIENTE;

   FOR SELECT REC_CODIGO,
          REC_CLIENTE,
          REC_DATA,
          REC_DATA_LIMITE,
          REC_VALOR_ALUGUEL,
          REC_MULTA_DESCONTO,
          REC_VALOR_MULTA_DESCONTO,
          REC_DESCRICAO_PERIODO,
          REC_NUMERO_RECIBO,
          REC_NUMERO_BANCARIO
   FROM RECIBO
   WHERE REC_CLIENTE = :VR_CLIENTE
   INTO :REC_CODIGO,
        :REC_CLIENTE,
        :REC_DATA,
        :REC_DATA_LIMITE,
        :REC_VALOR_ALUGUEL,
        :VR_MULTA_DESCONTO,
        :REC_VALOR_MULTA_DESCONTO,
        :REC_DESCRICAO_PERIODO,
        :REC_NUMERO_RECIBO,
        :REC_NUMERO_BANCARIO
   DO
   BEGIN    	
	SUSPEND;
   END

   IF  (VR_MULTA_DESCONTO = 'D')
   THEN BEGIN
         VR_VALOR_BRUTO   = :REC_VALOR_ALUGUEL
             + :REC_VALOR_TAXA;
         VR_VALOR_LIQUIDO = VR_VALOR_BRUTO
             - :REC_VALOR_MULTA_DESCONTO;
   END
   ELSE BEGIN
         VR_VALOR_BRUTO   = :REC_VALOR_ALUGUEL
             + :REC_VALOR_TAXA
             + :REC_VALOR_MULTA_DESCONTO;
         VR_VALOR_LIQUIDO = VR_VALOR_BRUTO
             - :REC_VALOR_MULTA_DESCONTO;
   END
END



--
Best regards

Carlos Guzmán álvarez
Vigo-Spain

Re: [Firebird-net-provider] Transactions...

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

Hello:

> Can I change this behaviour and have the transaction not block ? Is
> this something on the ADO.NET side or on the IBExpert side ?

Review which Transaction Isolation are you using in the .NET Data 
provider ( and in IBExpert ) and see how it's configured.

In the .NET Data provider :

tpb.Append(GdsCodes.isc_tpb_version3);
tpb.Append(GdsCodes.isc_tpb_write);
tpb.Append(GdsCodes.isc_tpb_wait);

/* Isolation level */
switch(this.isolationLevel)
{
	case IsolationLevel.Serializable:
		tpb.Append(GdsCodes.isc_tpb_consistency);
		break;

	case IsolationLevel.RepeatableRead:			
		tpb.Append(GdsCodes.isc_tpb_concurrency);
		break;

	case IsolationLevel.ReadUncommitted:
		tpb.Append(GdsCodes.isc_tpb_read_committed);
		tpb.Append(GdsCodes.isc_tpb_rec_version);
		break;

	case IsolationLevel.ReadCommitted:
	default:					
		tpb.Append(GdsCodes.isc_tpb_read_committed);
		tpb.Append(GdsCodes.isc_tpb_no_rec_version);
		break;
}





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FirebirdSql.Data.INGDS.GDSException

[Josauro S.J. <jo...@ca...>]

Ok, it's work fine.
But other question...=20
Variable  VR_VALOR_BRUTO   and VR_VALOR_LIQUDO return nothing values, do =
you know why ?=20

Josauro S.J.
Diretor
e-mail: jo...@ca...
   site: www.casasoft.inf.br

Portal de im=F3veis www.IndicadorDeIm=F3veis.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, November 25, 2003 9:00 AM
  Subject: Re: [Firebird-net-provider] =
FirebirdSql.Data.INGDS.GDSException


  Hello:

  Try this:

  CREATE PROCEDURE GET_RECIBOS (
        CLI_REFERENCIA VARCHAR(12))
  RETURNS (
       REC_CODIGO DOUBLE PRECISION,
       REC_CLIENTE DOUBLE PRECISION,
       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);
  DECLARE VARIABLE VR_CLIENTE DOUBLE PRECISION;
  begin
     /* Procedure Text */
     SELECT CODIGO FROM get_codigo_cliente(:CLI_REFERENCIA)
     INTO :VR_CLIENTE;

     FOR SELECT REC_CODIGO,
            REC_CLIENTE,
            REC_DATA,
            REC_DATA_LIMITE,
            REC_VALOR_ALUGUEL,
            REC_MULTA_DESCONTO,
            REC_VALOR_MULTA_DESCONTO,
            REC_DESCRICAO_PERIODO,
            REC_NUMERO_RECIBO,
            REC_NUMERO_BANCARIO
     FROM RECIBO
     WHERE REC_CLIENTE =3D :VR_CLIENTE
     INTO :REC_CODIGO,
          :REC_CLIENTE,
          :REC_DATA,
          :REC_DATA_LIMITE,
          :REC_VALOR_ALUGUEL,
          :VR_MULTA_DESCONTO,
          :REC_VALOR_MULTA_DESCONTO,
          :REC_DESCRICAO_PERIODO,
          :REC_NUMERO_RECIBO,
          :REC_NUMERO_BANCARIO
     do
       begin
  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
  end





  --
  Best regards

  Carlos Guzm=E1n =C1lvarez
  Vigo-Spain

Re: [Firebird-net-provider] FirebirdSql.Data.INGDS.GDSException

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

Hello:

Try this:

CREATE PROCEDURE GET_RECIBOS (
      CLI_REFERENCIA VARCHAR(12))
RETURNS (
     REC_CODIGO DOUBLE PRECISION,
     REC_CLIENTE DOUBLE PRECISION,
     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);
DECLARE VARIABLE VR_CLIENTE DOUBLE PRECISION;
begin
   /* Procedure Text */
   SELECT CODIGO FROM get_codigo_cliente(:CLI_REFERENCIA)
   INTO :VR_CLIENTE;

   FOR SELECT REC_CODIGO,
          REC_CLIENTE,
          REC_DATA,
          REC_DATA_LIMITE,
          REC_VALOR_ALUGUEL,
          REC_MULTA_DESCONTO,
          REC_VALOR_MULTA_DESCONTO,
          REC_DESCRICAO_PERIODO,
          REC_NUMERO_RECIBO,
          REC_NUMERO_BANCARIO
   FROM RECIBO
   WHERE REC_CLIENTE = :VR_CLIENTE
   INTO :REC_CODIGO,
        :REC_CLIENTE,
        :REC_DATA,
        :REC_DATA_LIMITE,
        :REC_VALOR_ALUGUEL,
        :VR_MULTA_DESCONTO,
        :REC_VALOR_MULTA_DESCONTO,
        :REC_DESCRICAO_PERIODO,
        :REC_NUMERO_RECIBO,
        :REC_NUMERO_BANCARIO
   do
     begin
	IF  (VR_MULTA_DESCONTO = 'D')
	THEN BEGIN
		VR_VALOR_BRUTO   = :REC_VALOR_ALUGUEL
			+ :REC_VALOR_TAXA;
		VR_VALOR_LIQUIDO = VR_VALOR_BRUTO
			- :REC_VALOR_MULTA_DESCONTO;
	END
	ELSE BEGIN
		VR_VALOR_BRUTO   = :REC_VALOR_ALUGUEL
			+ :REC_VALOR_TAXA
			+ :REC_VALOR_MULTA_DESCONTO;
		VR_VALOR_LIQUIDO = VR_VALOR_BRUTO
			- :REC_VALOR_MULTA_DESCONTO;
	END

	suspend;
     end
end





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FirebirdSql.Data.INGDS.GDSException

[Josauro S.J. <jo...@ca...>]

This is de version of last Provider ?         1.1.1266.28704


Josauro S.J.
Diretor
e-mail: jo...@ca...
   site: www.casasoft.inf.br

Portal de im=F3veis www.IndicadorDeIm=F3veis.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, November 25, 2003 7:50 AM
  Subject: Re: [Firebird-net-provider] =
FirebirdSql.Data.INGDS.GDSException


  Hello:

  > Hello:
  > =20
  > I change my code to  ...("EXECUTE PROCEDURE=20
  > GET_RECIBOS(@CLI_REFERENCIA)" )...
  > And the error not ocurrs, but other error about cant return =
multiples=20
  > row in singleton select....

  SELECT * FROM GET_RECIBOS(@CLI_REFERENCIA)



  --
  Best regards

  Carlos Guzm=E1n =C1lvarez
  Vigo-Spain