[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