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.