fill column bound item with a select?
245338Nov 24 2004 — edited Nov 26 2004Hi,
I can't figure out how to do this, although I guess it's simple:
I have a column bound item (source=db column), the item is hidden, but I want to fill it with a default value when a record is inserted. The default value must come from a select.
I have tried it with a default value type plsql body and the "select something into :P11_Item_name from table" but that doesn't insert a value.
Any idea how to do this, except from creating a trigger on the table itself?
Thanks
Guido