I have strange problem while filling dataset generetad by adapter.
When ID (biginteger unsigned) is like 130, 10, 50 in MySQL table during DataSet filling somewhere were lost
the "0" at the end, so for my suprise I have 13, 1, 5 inside the DataSet.
Where may be a problem?
strange problem with integer ID ending with ZERO
Excuse my my unprecision in topic header - I mean UNSIGNED BIGINTEGER.
It is really confusing me, especially when I try to imagine how many different possibilities for cross-updating appeares (and deleting).
For example a Customer with one CustomerID loaded by this query will be never updated
SELECT .... WHERE Customers.CustomerID=13560
in same time other customer with CustomerID=1356 will be updated instead in this case.
I saw in MySql that they have same problems with this Type, but in this case other clients (not MySQLDirect .NET) returns normal value for ID of this type.
It is really confusing me, especially when I try to imagine how many different possibilities for cross-updating appeares (and deleting).
For example a Customer with one CustomerID loaded by this query will be never updated
SELECT .... WHERE Customers.CustomerID=13560
in same time other customer with CustomerID=1356 will be updated instead in this case.
I saw in MySql that they have same problems with this Type, but in this case other clients (not MySQLDirect .NET) returns normal value for ID of this type.