We use a stored produre to generate a unique number for Id-fields. The 'default value' of those fields calls the procedure. This usely works fine.

Now we work with a view which update a certain table. When we perform an 'Insert' on the view a record is inserted in the table also. The table-record has a unique Id genated by the stored procedure but the record in the view is not updated and the Id is 0. I can not perform a 'Requery' because we are in the middle of a transaction.

Does anybody know a good solution for this problem.
Marco