dB09 0 Newbie Poster

hello.
i have a database with school names, their budgets and their expenses.
i have to write trigger not allowing to increase expenses, but only to lower their value. if someone wants to increase it, there should be message.

i know i have to remember somehow the old value and compare it to new, but i have no idea

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.