Hi Stephen,

You can only use the RetrieveAutoIncrementPK flag if the field is of type Integer and Identity is set to Yes. You can't set a default value for this kind of field.

>I found the answer to my question but I may have found a bug in the framework. The RetrieveAutoIncrementPK flag seems to be the answer to my question. However, when I set this flag to true, I am getting a NULL error.
>
>

>Cannot insert the value NULL into column 'irecversion',
>table 'aav3.dbo.AAName'; column does not allow nulls. INSERT fails.
>

>
>The field irecversion already have a default value of 0 set in the SQL Server. I should never get this particular error useless the INSERT command is actually sending NULL as the value of irecversion. BTW, when I set
>RetrieveAutoIncrementPK back to false, the insert works correctly.