You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
we have build a .NET 3.5 application upon the Firebird .NET Provider Version 2.6.5.
In our dataset we have designed a table and this table has columns of type "xs:short". The equivalent of "xs:short" in the firebird database is SMALLINT.
When we are updating rows in a .NET DataTable in one of these columns, the value is not correct transferred to the database.
For example we are putting a "108" into a "xs:short" column, the value will be written to the database as "10". We have no chance to fix this problem at the moment, because every values are fine until the FbDataAdapter receives the Table and Update Command. Update command is also fine.
I really hope, that someone has an idea, why this will happen or if someone could fix this issue soon, because we need to publish the next version of our product....
kind regards!
The text was updated successfully, but these errors were encountered:
summary: FbDataAdapter stripped down SMALLINT values while updating a DataTable ... => FbDataAdapter stripps down SMALLINT values while updating a DataTable ...
if we are changing the database column type to bigint, everything works fine, but the dataset could not be changed to xs:long or something else, because many customers are already using the current db and i think it could be not a solution making the column bigger as it should be ....
Submitted by: Sven Walter (architext_sw)
Hey,
we have build a .NET 3.5 application upon the Firebird .NET Provider Version 2.6.5.
In our dataset we have designed a table and this table has columns of type "xs:short". The equivalent of "xs:short" in the firebird database is SMALLINT.
When we are updating rows in a .NET DataTable in one of these columns, the value is not correct transferred to the database.
For example we are putting a "108" into a "xs:short" column, the value will be written to the database as "10". We have no chance to fix this problem at the moment, because every values are fine until the FbDataAdapter receives the Table and Update Command. Update command is also fine.
I really hope, that someone has an idea, why this will happen or if someone could fix this issue soon, because we need to publish the next version of our product....
kind regards!
The text was updated successfully, but these errors were encountered: