Hello everyone.
I have successfully created a trigger for experimentation and I would like your
help for implementing the concept behind of it.
My table pollaplasiasmos (which stands for multiplication in Greek, even though
I used English characters to write it [Gree-glish]), takes 3 values:
* Quantity [int]
* amount [real(0,2)]
* VAT [real(0,2)]I have created the triggers to make the necessary
calculations for vat_value (per item), vat_included (item price), and
total_price (which includes vat).
Now what I want to do is to take two tables, (let's call them temp_01 and
temp_02) that would both have columns id and val, and I want with a trigger to
add temp_01.val with temp_02.val and put their result in a new table named
total.
I have tried something like this:
create trigger [after_insert_temp_01]
after insert on temp_01
begin
update total
set val = temp_01.val + temp_02.val
where rowid = old.rowid;
end;
I know that this is wrong of what I am doing, because there is no way to call
the temp_02 table using this method; this is not an inner join where I can
compare IDs and make the necessary adjustments on my code.
I am really out of ideas and if there's a link with more information that I
should know already about it, by all means let me know because I need to learn
these things.
Regards,
Stefanos
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
