>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
The normal way is to insert record to view only (using id-generator here) and then then tableupdate() data to the underlying table.
Edward Pikman
Independent Consultant