Thread: Store Procedures
Hello. I been having "problems" with and application, and i want to store in the data base the changes(update) made to a specific table. what i need is to see how 2 fields specific change there values, to do that i plan to make a temporal table with the fields before and after plus the time the changes where made... can i do this with store procedures?? here are the 2 fields are: "cajas" INTEGER, "unidades" INTEGER, in the temporal table will be "before_cajas" INTEGER, "before_unidades" INTEGER, "after_cajas" INTEGER, "after_unidades" INTEGER, Regards Cesar Alvarez.
> what i need is to see how 2 fields specific change there values, to do > that i plan to make a temporal table with the fields before and after > plus the time the changes where made... can i do this with store > procedures?? http://www.varlena.com/varlena/GeneralBits/104.php Check out this discussion on this link. It is very similar to what you want to do. If fact, my experience is that "generalbits" is an excellent cookbook for and learning Postgresql developer. Regards, Richard Broersma Jr.
Richard Broersma Jr wrote:
i think this helps me a lot, im gona play with the triggers and all that.
Cesar Alvarez
Web Development Asesor and Software Enginner.
thankswhat i need is to see how 2 fields specific change there values, to do that i plan to make a temporal table with the fields before and after plus the time the changes where made... can i do this with store procedures??http://www.varlena.com/varlena/GeneralBits/104.php Check out this discussion on this link. It is very similar to what you want to do. If fact, my experience is that "generalbits" is an excellent cookbook for and learning Postgresql developer. Regards, Richard Broersma Jr.
i think this helps me a lot, im gona play with the triggers and all that.
Cesar Alvarez
Web Development Asesor and Software Enginner.