This is the first time I have attempted to expand beyond basic sql for
storing data in a table like structure. So my level of knowledge is
familiar with basic SQL, but lacking in expanded knowledge. I expect my
error is a newbie mistake.
I have attempted to create a trigger to update another
It appears to be a simple enough error message. Here is your trigger
you are reffering quite explicitly to credits.enabled:
select SUM(credits.amount) into total_credits from credits where
credits.enabled=1 and account=new.account;
and this table has no such column defined. debits does, but
Well that is embarasing, thank you, It always ends up being the simple
things that get you.
On Sat, Oct 17, 2009 at 1:25 PM, Michael Dykman mdyk...@gmail.com wrote:
It appears to be a simple enough error message. Here is your trigger
you are reffering quite explicitly to credits.enabled: