SQL Trigger

[samlou]

Got tables
Account (DeptNo, Date, StaffNo, CreditLimit)
Expense(ExpenseNo, DeptNo, Amount)

Bashing my head against a wall trying to phathom out how to create a trigger to ensure that total amount spent by a staff member doesn't exceed credit limit.

got as far as...

CREATE TRIGGER CreditLimitCheck
AFTER INSERT ON EXPENSE


End

 

[AlexCuse]

What DBMS are you using? You should ask in that forum (for Oracle, SQL Server, etc...) as different products may have slightly different implementations of triggers.

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom