Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

FbDataAdapter stripps down SMALLINT values while updating a DataTable ... [DNET484] #471

Closed
firebird-automations opened this issue Jan 30, 2013 · 4 comments

Comments

@firebird-automations
Copy link

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!

@firebird-automations
Copy link
Author

Modified by: Sven Walter (architext_sw)

summary: FbDataAdapter stripped down SMALLINT values while updating a DataTable ... => FbDataAdapter stripps down SMALLINT values while updating a DataTable ...

@firebird-automations
Copy link
Author

Commented by: Sven Walter (architext_sw)

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 ....

@firebird-automations
Copy link
Author

Commented by: @cincuranet

First update to latest version. And second provide a test case.

@firebird-automations
Copy link
Author

Modified by: @cincuranet

status: Open [ 1 ] => Closed [ 6 ]

resolution: Incomplete [ 4 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants