So..... I got my DB2 project working to display and edit existing records.



When I try to add a record I always get a conversion error on the primekey field.



I know DB2 doesn't have auto increment fields (does it?) so I have to manually manage the primekeys but I don't even get a chance. I get this error as soon as I hit the add button, or programmatically call BO.add().



I have two projects referencing two different libraries/tables with primekeys of different data types exhibiting the same behavior.



Any ideas? Please see the attached error image, I cant seem to add images to posts anymore.

Keith Chisarik

OK I will look into that, any thoughts on my bigger problem, the use of auto-incrementing keys with a DB2 datasource?



Thanks.

Keith Chisarik

DB2 is not something I work in every day so before I can just throw an answer out there like I can for SQL Server or some of the other databases.  I will have to get it setup and play with it on my side.    I have not dug into the DB2 server to play with this...yet.  But we will look into it.  Sorry for the delay