Try creating a table with a numeric field, and a sequence, and then
creating a database trigger which attempts to assign a unique number
from the sequence to the numeric field on _delete_ of a row. Yes, I know
it makes no sense whatsoever, but if you check the wrong boxes in
Designer/2000 when defining your logic, you really can get SQL from the
generator that creates a trigger that tries to do this. On 7.3.3 on SCO
OpenServer, you get a pretty core dump when you actually try and delete
rows from the table.
Enjoy!
--
Tom Cooke
Received on Sat May 02 1998 - 11:34:50 CDT
