> Is it possible to do a before insert trigger in SapDB? I need > to assign > a value to a table column *before* inserting the row. > My SapDB version is 7.4.3.27.
There are no before trigegrs in SAP DB / MaxDB. You could write a stored procedure that takes the INSERT values as parameters. Do the 'before action' and the INSERT in that stored procedure. Remove the INSERT privilege for the table and grant execution privilege to that store procedure instead. This of course doesn't work very well if the table has a lot of optional columns (there are currently no optional parameters for stored procedures) or when the INSERT gets generated by some other layer. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
