firebird-net-provider

[Firebird-net-provider] autonumber and readonly problems

[Christoph D. <cd...@ar...>]

I have a table.  I have included the sql file to create it and the xml file
that gets created by the provider.

There are two problems.

1. SDESCRIPTION and STERMSCODE are both coming across into the dataset as
read only.

2. ATERMSCODE_KEY is setup as an autonumber field using a before insert
trigger.  I have set this as not null because I don't want it deleted after
it is set.  I want to not worry about it and let firebird set the value.
Problem is that .net won't allow it to be null in the dataset because that's
what the metadata says.  I could take away the not null, or I could select
all fields except it instead of *.  Is there a better solution?  I suppose
there is no way of knowing it's an auto increment field so that
IsAutoIncrement could be set in the GetSchema function?

I am also getting the following errors when adding or deleting.  Not sure
why, I will invistigate further.

Additional information: This Transaction has completed; it is no longer
usable.
Additional information: Deleted row information cannot be accessed through
the row.

If you need more information let me know.


Christoph

Re: [Firebird-net-provider] autonumber and readonly problems

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

Christoph Donges wrote:
> I have a table.  I have included the sql file to create it and the xml file
> that gets created by the provider.
> 
> There are two problems.
> 
> 1. SDESCRIPTION and STERMSCODE are both coming across into the dataset as
> read only.
> 
> 2. ATERMSCODE_KEY is setup as an autonumber field using a before insert
> trigger.  I have set this as not null because I don't want it deleted after
> it is set.  I want to not worry about it and let firebird set the value.
> Problem is that .net won't allow it to be null in the dataset because that's
> what the metadata says.  I could take away the not null, or I could select
> all fields except it instead of *.  Is there a better solution?  I suppose
> there is no way of knowing it's an auto increment field so that
> IsAutoIncrement could be set in the GetSchema function?
> 

You can try to assign to it a random value and this value will be 
replaced with Generator value when trigger fires (i know that this is 
not the best solution but as i know i can´t know if a field is used in a 
generator ).

> I am also getting the following errors when adding or deleting.  Not sure
> why, I will invistigate further.
> 
> Additional information: This Transaction has completed; it is no longer
> usable.
> Additional information: Deleted row information cannot be accessed through
> the row.
> 

If you can, please, try with latest CVS sources, i have updated some 
changes on FbCommandBuilder class.




-- 
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] autonumber and readonly problems

[Christoph D. <cd...@ar...>]

What about point 1 with the two fields coming across as read only?

I tried latest cvs sources and I am getting the following error when I do an
adapter.update:

Command Connection is not equal to Transaction Connection

I believe that it is the same connection.  I will see if I can make a small
program that demonstates the problem and send it later today.

Thanks for all your effort so far.


Christoph

----- Original Message -----
From: "Carlos Guzmán Álvarez" <car...@te...>
To: "Christoph Donges" <cd...@ar...>
Cc: <fir...@li...>
Sent: Wednesday, December 25, 2002 2:44 AM
Subject: Re: [Firebird-net-provider] autonumber and readonly problems


> Christoph Donges wrote:
> > I have a table.  I have included the sql file to create it and the xml
file
> > that gets created by the provider.
> >
> > There are two problems.
> >
> > 1. SDESCRIPTION and STERMSCODE are both coming across into the dataset
as
> > read only.
> >
> > 2. ATERMSCODE_KEY is setup as an autonumber field using a before insert
> > trigger.  I have set this as not null because I don't want it deleted
after
> > it is set.  I want to not worry about it and let firebird set the value.
> > Problem is that .net won't allow it to be null in the dataset because
that's
> > what the metadata says.  I could take away the not null, or I could
select
> > all fields except it instead of *.  Is there a better solution?  I
suppose
> > there is no way of knowing it's an auto increment field so that
> > IsAutoIncrement could be set in the GetSchema function?
> >
>
> You can try to assign to it a random value and this value will be
> replaced with Generator value when trigger fires (i know that this is
> not the best solution but as i know i can´t know if a field is used in a
> generator ).
>
> > I am also getting the following errors when adding or deleting.  Not
sure
> > why, I will invistigate further.
> >
> > Additional information: This Transaction has completed; it is no longer
> > usable.
> > Additional information: Deleted row information cannot be accessed
through
> > the row.
> >
>
> If you can, please, try with latest CVS sources, i have updated some
> changes on FbCommandBuilder class.
>
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
> "No tengo dones especiales.Sólo soy apasionadamente curioso"
> Albert Einstein, científico.
>
>
>
> -------------------------------------------------------
> 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] autonumber and readonly problems

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

Hello:


> What about point 1 with the two fields coming across as read only?

I made some new little changes on FbCommandBuilder i think that now can 
work well.

> I tried latest cvs sources and I am getting the following error when I do an
> adapter.update:
> 
> Command Connection is not equal to Transaction Connection
> 
> I believe that it is the same connection.  I will see if I can make a small
> program that demonstates the problem and send it later today.

OK, i´m testing update and gives no problem to me, but if you continue 
to experience problems please tell to me.


> Thanks for all your effort so far.

Thnaks to you too.




-- 
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] autonumber and readonly problems

[Christoph D. <cd...@ar...>]

I am still having the same problems.  I will send you a program that
demonstrates them soon.


Christoph

----- Original Message -----
From: "Carlos Guzmán Álvarez" <car...@te...>
To: "Christoph Donges" <cd...@ar...>; "Firebird .Net Provider"
<fir...@li...>
Sent: Wednesday, December 25, 2002 9:20 AM
Subject: Re: [Firebird-net-provider] autonumber and readonly problems


> Hello:
>
>
> > What about point 1 with the two fields coming across as read only?
>
> I made some new little changes on FbCommandBuilder i think that now can
> work well.
>
> > I tried latest cvs sources and I am getting the following error when I
do an
> > adapter.update:
> >
> > Command Connection is not equal to Transaction Connection
> >
> > I believe that it is the same connection.  I will see if I can make a
small
> > program that demonstates the problem and send it later today.
>
> OK, i´m testing update and gives no problem to me, but if you continue
> to experience problems please tell to me.
>
>
> > Thanks for all your effort so far.
>
> Thnaks to you too.
>
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
> "No tengo dones especiales.Sólo soy apasionadamente curioso"
> Albert Einstein, científico.
>
>
>
> -------------------------------------------------------
> 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