I've been using the numeric data type (N,n,0) as a surrogate primary key in parent-child relationships with no problems. Yesterday, I tried using the 4 byte Integer Data type in the same roll and ran into a consistant show stopper. The TABLEUPDATE command always failed with a "Uniquness Violated" error on the parent table. However, after the refresh command was issued the new record would show in the grid, and child records could be added! However, attempts to move off of the row would trigger the RI code allowing on the REVERT option, which rolled back (?) the change. Cascade delete will then kill off the child record.
Anyone run into this?
Nebraska Dept of Revenue