Insert Trigger, change values

[mcneija]

I need to add a trigger to a table so that if a user submits an isert and forgets a foreign key field, I will go out and find a vlaid value and add it to their insert statement. So I think this has to happen before the insert, but then what? How do I change the values in the insert stmt before they are inserted?

 

[onealm]

If you are using ASA, your trigger will look something like this:

create trigger tbi_DefaultMyTableFK
before insert on MyTable
referencing NEW as new_rows
for each row
begin
  if MyFKField is null then
    //logic to set FKField default value...
    select max(PKField) 
      into new_rows.FKField
    from MyParentTable;
  end if;
end;

ASE may support something similar, but the syntax will differ.