View MyView has a MyId field for which I have set the Default value as the function MakeNewId.
This function does nothing more complex than look at a record in a table, increment the value of MyId and return the incremented value.
The function is placed in the Stored Procedures of the DB and does what it's supposed to do.
When I add a record to the view the expected values show up in the view.
If I the issue a Tableupdate() the first record is inserted into the base-table with no values, and as a result I get a primary key violation on the second record.
I can think of a few workarounds myself, so the question really is, is it possible to get the above scenario with SP functions and default values to work?
TIA
Peter Pirker
Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?
(Woody Allen)