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

RE: [Firebird-net-provider] FbCommandBuilder - where's clause rule to generate control needed![Scanned]

[JS.staff <jsp...@ec...>]

Why is 3 'Pessimistic'?? Surely it has less concurrency checking, so =
should be called something like ReallyOptimistic??? Or =
GodIHopeNoOneElseHasChangedThis....

;)

John



-----Original Message-----
From: Carlos Guzm=E1n =C1lvarez [mailto:car...@te...]=20
Sent: 12 March 2004 12:02
To: fir...@li...
Subject: Re: [Firebird-net-provider] FbCommandBuilder - where's clause =
rule to generate control needed![Scanned]


Hello:

>    Yes, for this we can made third mode: what in where generate=20
> primary key and "TIMESTAMP" field for example...
>    I'm need in this may be too... anyway I this wants the breach of=20
> the parallelism for governing checking!

Well at the end seems to be that there are more people with similar need =
;)

I'm thinking on make a change to the 1.6 sources:

* Create a new enumeration: FbBuilderBehavior ( really it's needs to be=20
FbCommandBuilderBehavior but it's too long ;) )

it will have as values:

	1. Default
	2. Optimistic
	3. Pesimistic

1/2. Will do update and delete command generation as it's now.

3. Will do the update and delete command generation using only the pk=20
fields in the WHERE clausule.


Opinions ???



--
Best regards

Carlos Guzm=E1n =C1lvarez
Vigo-Spain


-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of =
GenToo technologies. Learn everything from fundamentals to system =
administration.http://ads.osdn.com/?ad_id=3D1470&alloc_id=3D3638&op=3Dcli=
ck
_______________________________________________
Firebird-net-provider mailing list =
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Re:'FbDbType' is not declared while running the Firebird.net data provider 1.5 sample??

[benny <be...@ch...>]

> Carlos Guzm=E1n =C1lvarez wrote:-

>No, if you want you can try to put the assembly in a bin directory ( in =

>the same directory where the sample is located ), and modify the=20
>web.config as:

     <add assembly=3D"FirebirdSql.Data.Firebird" />
>But as i tell i have done a test yesterday and both samples are working =

>ok for me using WebMatrix

Carlos Guzm=E1n =C1lvarez,

      I tried the following method:-
1.            <assemblies>
                <add assembly=3D"FirebirdSql.Data.Firebird,=20
            location=3DC:\Program =
Files\FirebirdNETProvider1.5\examples\ASP.NET\bin\FirebirdSql.Data.Firebi=
rd.dll" />
-work on CSharpexample.aspx not VBnetexample.aspx  [Err: Name 'FbDbType' =
is not declared.]
 where my sample are on C:\Program =
Files\FirebirdNETProvider1.5\examples\ASP.NET=20

2.            <assemblies>
                 <add assembly=3D"FirebirdSql.Data.Firebird,
                 version=3D1.5.1512.22880, Culture=3Dneutral, =
PublicKeyToken=3De1b4f92304d7b12f"/>
            </assemblies>
* the version and publickeytoken is according to C:\WINDOWS\assembly =
FirebirdSql.Data.Firebird=20
- work on CSharpexample.aspx not VBnetexample.aspx  [Err: Name =
'FbDbType' is not declared.]
  where my samples are on C:\Program =
Files\FirebirdNETProvider1.5\examples\ASP.NET
- not work on both example where my samples are on C:\Program =
Files\FirebirdNETProvider1.5\examples\ASP.NET\bin that bin have =
FirebirdSql.Data.Firebird.dll [Err: Server Error in '/' Application]
3.            <assemblies>
                 <add assembly=3D"FirebirdSql.Data.Firebird"/>
                </assemblies>
- not work on both example=20
  where my samples are on C:\Program =
Files\FirebirdNETProvider1.5\examples\ASP.NET\bin, that bin have file =
FirebirdSql.Data.Firebird.dll=20
 [Err: File or assembly name FirebirdSql.Data.Firebird, or one of its =
dependencies, was not found ]

On your looks fine, but unfortunately I still hadnt know what mistakes I =
had made on my Win Xp platform.....

TIA=20

regards,
benny ; )

Re: [Firebird-net-provider] FbCommandBuilder - where's clause rule

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

Hello:

>   All it is correct, but names "Optimistic/Pesimistic" I do not like,
> since this does not render on principle optimistic/pesimistic
> parallelism, either or both of them -- there is ways to realization
> optimistic parallelism, but with renovation strategy miscellaneous.
> Not certain, but can offer... mmm... Default, AllFields,
> PrimaryKeyFields but me such names too do not like :) So unless will be
> other offers -- consent to variant with Optimistic/Pessimistic names :)

Defult
AllFields
KeyFields
KeyAndTimeStampFields

As a reference Visual Foxpro allows:

1. Key Fields only

2. Key and updatable fields.

3. Key and modified fields

4. Key and timestamp ( That if i'm not worng works only for Sql Sever )


 > The fourth variant -- WHERE is generated on primary key fields > and 
field with fixed-name (for example "TIMESTAMP" or
 > "LAST_MODIFIED").

As i don't like fixed things ;) if i do this i will add a property for 
this ( aand provide a default value for it, of course )



Opinions ????




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FbCommandBuilder - where's clause rule

[Dmitry A. <fd...@do...>]

Carlos Guzmán Álvarez wrote:

> I'm thinking on make a change to the 1.6 sources:
> * Create a new enumeration: FbBuilderBehavior ( really it's needs to
> be FbCommandBuilderBehavior but it's too long ;) )
  My first thought was such :) Truth shortened name I as well as not
ïðèäóìàë, but FbBuilderBehavior I like! ;)

> it will have as values:
> 	1. Default
> 	2. Optimistic
> 	3. Pesimistic
  All it is correct, but names "Optimistic/Pesimistic" I do not like,
since this does not render on principle optimistic/pesimistic
parallelism, either or both of them -- there is ways to realization
optimistic parallelism, but with renovation strategy miscellaneous.
Not certain, but can offer... mmm... Default, AllFields,
PrimaryKeyFields but me such names too do not like :) So unless will be
other offers -- consent to variant with Optimistic/Pessimistic names :)

> Opinions ???
   The fourth variant -- WHERE is generated on primary key fields and
field with fixed-name (for example "TIMESTAMP" or "LAST_MODIFIED").
   

Re: [Firebird-net-provider] FbCommandBuilder - where's clause rule to generate control needed![Scanned]

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

Hello:

>    Yes, for this we can made third mode: what in where generate primary
> key and "TIMESTAMP" field for example...
>    I'm need in this may be too... anyway I this wants the breach of the
> parallelism for governing checking!

Well at the end seems to be that there are more people with similar need ;)

I'm thinking on make a change to the 1.6 sources:

* Create a new enumeration: FbBuilderBehavior ( really it's needs to be 
FbCommandBuilderBehavior but it's too long ;) )

it will have as values:

	1. Default
	2. Optimistic
	3. Pesimistic

1/2. Will do update and delete command generation as it's now.

3. Will do the update and delete command generation using only the pk 
fields in the WHERE clausule.


Opinions ???



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Re:'FbDbType' is not declared while running the Firebird.net data provider 1.5 sample??

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

Hello:

>     I made changes on the Version and PublicKeyToken according to the 
> info on the C:\WINDOWS\assembly where I have Global Assembly Name of
> FirebirdSql.Data.Firebird with the value of version and public key token 
> ... is tat the assembly u refer ? 

Yes.

> As I still have the same problem of  'FbDbType' is not declared on 
> sample of vbnetexample.aspx but I could still work on CSharpExample.aspx..
>     Basically, I just can declare the type e.g FbConnection, 
> FbTransaction ... but not 'FbDbType'.  I just install the 
> FirebirdNETProvider1.5-NET1.1.exe (binary) and try the sample straight 
> away... Is there any further configuration I might miss out before 
> trying my sample using web matrix0.5 ?

No, if you want you can try to put the assembly in a bin directory ( in 
the same directory where the sample is located ), and modify the 
web.config as:

     <add assembly="FirebirdSql.Data.Firebird" />

But as i tell i have done a test yesterday and both samples are working 
ok for me using WebMatrix



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Re:'FbDbType' is not declared while running the Firebird.net data provider 1.5 sample??

[benny <be...@ch...>]

>     Did I done anything wrong? or anyone could tell me the reason why =
I=20
> could try on connecting database but failed on making further select =
statement..... ? =20

Carlos Guzm=E1n =C1lvarez wrote
>Try witout the path and without the extension and modify the version =
and=20
> the PublicKeyToken to the values that the assembly have in the GAC

Carlos Guzm=E1n =C1lvarez,

  did u mean by making modification on the web.config file on part of =
following ?=20
<compilation>
  <assemblies>
    <add assembly=3D"FirebirdSql.Data.Firebird, =
Version=3D1.5.1512.22880, Culture=3Dneutral, =
PublicKeyToken=3De1b4f92304d7b12f" />
  </assemblies>
</compilation>

    I made changes on the Version and PublicKeyToken according to the =
info on the C:\WINDOWS\assembly where I have Global Assembly Name of=20
FirebirdSql.Data.Firebird with the value of version and public key token =
... is tat the assembly u refer ? or u refer to another another place?  =
As I still have the same problem of  'FbDbType' is not declared on =
sample of vbnetexample.aspx but I could still work on =
CSharpExample.aspx..
    Basically, I just can declare the type e.g FbConnection, =
FbTransaction ... but not 'FbDbType'.  I just install the =
FirebirdNETProvider1.5-NET1.1.exe (binary) and try the sample straight =
away... Is there any further configuration I might miss out before =
trying my sample using web matrix0.5 ?=20


TIA=20

benny ;)

Re: [Firebird-net-provider] FbCommandBuilder - where's clause rule to generate control needed![Scanned]

[Dmitry A. <fd...@do...>]

"JS.staff" wrote:

> That would be useful to me too - specially with the timestamp issue
> potentially causing problems with the concurrency checking for a 'all
> field' check.
   Yes, for this we can made third mode: what in where generate primary
key and "TIMESTAMP" field for example...
   I'm need in this may be too... anyway I this wants the breach of the
parallelism for governing checking!

RE: [Firebird-net-provider] FbCommandBuilder - where's clause rule to generate control needed![Scanned]

[JS.staff <jsp...@ec...>]

That would be useful to me too - specially with the timestamp issue
potentially causing problems with the concurrency checking for a 'all
field' check.

John

-----Original Message-----
From: Dmitry Azaraev [mailto:fd...@do...]=20
Sent: 12 March 2004 09:28
To: fir...@li...
Subject: [Firebird-net-provider] FbCommandBuilder - where's clause rule
to generate control needed![Scanned]


Hello, All!

   I'm needed what FbCommandBuilder can generate queries with where
clause, for example, only for primary key fields. Some time needed for
generate for specified fields...
   I suggest add to FbCommandBuilder property (what be visible in
design-mode), via which i can control this behaivor (rule to generate
where clause (all fields/PrimaryKeyOnly) :-)

   2Carlos: I can programm this. ;)


-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=3D1470&alloc_id=3D3638&op=3Dcli=
ck
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] FbCommandBuilder - where's clause rule to generate control needed!

[Dmitry A. <fd...@do...>]

Hello, All!

   I'm needed what FbCommandBuilder can generate queries with where
clause, for example, only for primary key fields. Some time needed for
generate for specified fields...
   I suggest add to FbCommandBuilder property (what be visible in
design-mode), via which i can control this behaivor (rule to generate
where clause (all fields/PrimaryKeyOnly) :-)

   2Carlos: I can programm this. ;)

Re: [Firebird-net-provider] Re:'FbDbType' is not declared while running the Firebird.net data provider 1.5 sample??

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

Hello:

>     Did I done anything wrong? or anyone could tell me the reason why I 
> could try on connecting database but failed on making further select 
> statement..... ?  

Try witout the path and without the extension and modify the version and 
the PublicKeyToken to the values that the assembly have in the GAC




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Re:'FbDbType' is not declared while running the Firebird.net data provider 1.5 sample??

[benny <be...@ch...>]

> Why? Anyone there know any configuration I missed out during=20
 > installation of FirebirdNETProvider1.5-NET1.1 or any mistake I might =
made?
=20
> It's working for me, are you sure you are working against 1.5 ?? ( 1.0 =

> has no FbDbType enumeration )
=20
Carlos Guzm=E1n =C1lvarez,

     I am using Firebird1.5RC7 and I download =
FirebirdNETProvider1.5-NET1.1.exe (binary) format from the site=20
http://sourceforge.net/mailarchive/forum.php?thread_id=3D3869373&forum_id=
=3D12591. At the same time I have Microsoft .Net framework 1.1=20
Microsoft . Net Framework SDK 1.1 that run on Win Xp.
     I still have the problem of 'FbDbType' is not declared while =
running the Firebird.net data provider 1.5 sample[VBNETExample.aspx] =
using Web Matrix 0.5 that I still haven't solved.=20
    the sample I could run successfully is CSharpExample.aspx where I =
made changes on Web.config :-
    <add assembly=3D"FirebirdSql.Data.Firebird,
                 location=3DC:\Program =
Files\FirebirdNETProvider1.5\FirebirdSQL.Data.Firebird.dll,  =20
                 Version=3D1.5.1334.34352, Culture=3Dneutral, =
PublicKeyToken=3De1b4f92304d7b12f" />
    Did I done anything wrong? or anyone could tell me the reason why I =
could try on connecting database but failed on making further select =
statement..... ? =20

TIA=20

regards,
benny ;)

    =20
       

Re: [Firebird-net-provider] Basic Question

[Inter-Biz, U. u i. <ne...@in...>]

I always use generators and triggers, of course.

But, here is better example. Test enviroment includes Firebird server and
some PocketPC. Application running on PocketPC allows me to connect to
server (let us suppose that!) in the morning. Using Fill I get all required
data on my PocketPC and I close the connection to database. With my PocketPC
I am working whole day somewhere in the woods, collecting new data about
something. I put these new data into localy stored tables and I want to
Update it using DataAdapter back to server in the evening.

Let's say there are two tables - first has an unique identifier and second
uses these ID as foreign key. All data are entered without connection to
server on field, and data should be updated to server in the evening (there
is no way to be connected to server during day).
Does DataAdapter localy make unique identifiers (on server defined with
triggers/generators)? If not, how can I make relation between two tables
described previously? It is important that when posting data to server all
these values are recalculated and changed using cascade updates..

Let us suppose, there are few users using their PocketPCs on the same way.
All of them make local copies of some tables in the morning, then they make
some field work collecting data, and finally they want to update data and
post it to server in the evening. In that case, all of them could have same
localy defined unique identifiers, and these should be changed when updating
data to server.

Is that possible using Firebird .NET provider? I am asking it because that's
one of examples I heard on Microsoft ADO.NET training session. That is a
kind of usage of their disconnected database access mode.So I was wondering
if it works like that with Firebird.

[Firebird-net-provider] Firebird in Delphi .NET

[<ja...@us...>]

I need register the components FB of yours assembly

FirebirdSql.Data.Firebird.UnitTest.dll. How I do this?

Re: [Firebird-net-provider] FbBatchExecution doesn't assign sqlTransaction to atomicCommand

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

Hello:

> Long time no speak! I've been working on a different project which 
> didn't require Firebird, but now we're back looking at Firebird again so 
> you'll probably see more messages from me in the future :-)

:)

> I don't know if you remember, but I was interested in getting a better 
> ISQL script parser. 

I remember :)


> I now see that you've implemented a parser class and 

It's implemented by Abel Eduardo Pereira but it's unfinished ( he was a 
little busy and having no time for finish it )

> I've been playing with FbBatchExecution. However, I get exceptions which 
> complain that the command has no transaction set. Having looked at the 
> code, I can see that you don't assign the sqlTransaction to the 
> atomicCommand in the loop in Execute(). So the commands don't have the 
> transaction assigned.

Tanks, i will forward the message to Abel Eduardo Pereira for see if he 
can fix it if no i will try to take a look at it




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] FbBatchExecution doesn't assign sqlTransaction to atomicCommand

[Mike S. <mik...@ex...>]

Hi Carlos

Long time no speak! I've been working on a different project which 
didn't require Firebird, but now we're back looking at Firebird again so 
you'll probably see more messages from me in the future :-)

I don't know if you remember, but I was interested in getting a better 
ISQL script parser. I now see that you've implemented a parser class and 
I've been playing with FbBatchExecution. However, I get exceptions which 
complain that the command has no transaction set. Having looked at the 
code, I can see that you don't assign the sqlTransaction to the 
atomicCommand in the loop in Execute(). So the commands don't have the 
transaction assigned.

Cheers,

Mike Scott.

RE: [Firebird-net-provider] Using FBCommandBuilder with a table that has a trigger to update a column

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

  How do you stop FBCommandBuilder from using "ID" in the insert command.
The ID will be created by a trigger in the database.





  the trigger should test for NULL so you can assign NULL to the ID
parameter

  Alan

Re: [Firebird-net-provider] Using FBCommandBuilder with a table that has a trigger to update a column

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

Hello:

> How do you stop FBCommandBuilder from using "ID" in the insert command. 
> The ID will be created by a trigger in the database.

I can't know that the field will be generated in the server side, but, 
in any case i think that the only problem here can be with inserts, the 
id will have a 0 as value ( unless you have filled it with other value 
), and if you assign a new value in the before insert trigger it needs 
to insert the record ok, with the correct value.

In the case of up`date and delete the field id needs to be filled ;)




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FbDataAdapter.FillSchema

[Oleg U. <ol...@ya...>]

you right! sorry! :))

we all make mistakes :))

Re: [Firebird-net-provider] 'FbDbType' is not declared while running the Firebird.net data provider 1.5 sample??

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

Hello:

> Why? Anyone there know any configuration I missed out during 
> installation of FirebirdNETProvider1.5-NET1.1 or any mistake I might made?

It's working for me, are you sure you are working against 1.5 ?? ( 1.0 
has no FbDbType enumeration )






--
Best regards

Carlos Guzmán Álvarez
vigo-Spain

[Firebird-net-provider] Using FBCommandBuilder with a table that has a trigger to update a column

[Tony R. <Ton...@jf...>]

How do you stop FBCommandBuilder from using "ID" in the insert command.
The ID will be created by a trigger in the database.

=20

Insert: INSERT INTO "JFMTEMP" ("ID", "TEST_STRING", "TEST_DATE",
"TEST_BOOLEAN", "TEST_NUMERIC", "TEST_TEXT", "TEST_INTEGER") VALUES (?,
?, ?, ?, ?, ?, ?)

=20

Update: UPDATE "JFMTEMP" SET "ID" =3D ?, "TEST_STRING" =3D ?, "TEST_DATE" =
=3D
?, "TEST_BOOLEAN" =3D ?, "TEST_NUMERIC" =3D ?, "TEST_TEXT" =3D ?,
"TEST_INTEGER" =3D ? WHERE ( ("ID" =3D ?) AND (("TEST_STRING" IS NULL) OR
("TEST_STRING" =3D ?)) AND (("TEST_DATE" IS NULL) OR ("TEST_DATE" =3D ?))
AND (("TEST_BOOLEAN" IS NULL) OR ("TEST_BOOLEAN" =3D ?)) AND
(("TEST_NUMERIC" IS NULL) OR ("TEST_NUMERIC" =3D ?)) AND (("TEST_INTEGER"
IS NULL) OR ("TEST_INTEGER" =3D ?)) )

=20

Delete: DELETE FROM "JFMTEMP" WHERE ( ("ID" =3D ?) AND (("TEST_STRING" IS
NULL) OR ("TEST_STRING" =3D ?)) AND (("TEST_DATE" IS NULL) OR ("TEST_DATE"
=3D ?)) AND (("TEST_BOOLEAN" IS NULL) OR ("TEST_BOOLEAN" =3D ?)) AND
(("TEST_NUMERIC" IS NULL) OR ("TEST_NUMERIC" =3D ?)) AND (("TEST_INTEGER"
IS NULL) OR ("TEST_INTEGER" =3D ?)) )

=20

=20



This message has been scanned for viruses by MailControl - www.mailcontrol.=
com

Re: [Firebird-net-provider] FbDataAdapter.FillSchema

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

HEllo:

> Can i use this method for recieve table schema of select stored procedure?

Seems to be working for me, are you sure the TEST_SELECT stored 
procedure exists in the target database ?? (Sorry for the basic question ;))




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FbDataAdapter.FillSchema

[Oleg U. <ol...@ya...>]

When i use:
FbCommand selectCommand = new FbCommand("EXECUTE PROCEDURE TEST_SELECT",
connection, transaction);

all works fine, thanks to Mike Nash for his feedback :)

But why firebird provider can do this transparent?

Re: [Firebird-net-provider] FBCommandBuilder - which fields?

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

Hello:

> Does the FbCommandBuilder compare all fields when doing update 
> & deletes, or just the primary key?

All (the sql command text generation is similar to the SqlClient)





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Using FBCommand and stored procedures

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

Hello:

Try:

ac := FbCommand.Create('EXECUTE PROCEDURE TEST(@ID_IN)', adm.Connection);
ac.CommandType := CommandType.StoredProcedure;

ac.Parameters.Add('@ID_IN', FbDBType.Integer,).Value := TObject(Int32(10));
ac.Parameters.Add('@ID_OUT', FbDBType.Integer).Direction := 
ParameterDirection.Output;

ac.ExecuteNonQuery;

Or:

ac := FbCommand.Create('TEST', adm.Connection);
ac.CommandType := CommandType.StoredProcedure;

ac.Parameters.Add('@ID_IN', FbDBType.Integer,).Value := TObject(Int32(10));
ac.Parameters.Add('@ID_OUT', FbDBType.Integer).Direction := 
ParameterDirection.Output;

ac.ExecuteNonQuery;




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain