Page 1 of 1

constantly updating field in dataset !?!

Posted: Sun Nov 13, 2005 7:38 pm
by joecrack
Hey
my problem is, i need to have one field in my database that is constantly updating.
This field has to be a sum from several fields in the same table.
I dont know if it ispossible, to have a field that includes an insert command and is constantly running this command.
If that is the way to solve the problem the insert has to be like this:

INSERT INTO sam_bestellung.contrvalue VALUES ('sam_date_val.cortval1'+'sam_date_val.cortval2'+'sam_date_val.cortval3') FROM sam_date_val,sam_bestellung WHERE customernr='02.01.' AND projnr='302

So in this example it means, when contrval1-3 chages contrvalue also changes.
I hope you understand my problem!?!
joe

Posted: Sun Nov 13, 2005 8:50 pm
by trukfixer

Posted: Sun Nov 13, 2005 8:54 pm
by joecrack
i just have no idea how to start ... i searched in the forum but i didnt find anything ...!!!!

2 trukfixer: posting nonsense doesnt help me !

Posted: Sun Nov 13, 2005 9:09 pm
by trukfixer
click the link. the people that provide the help are not here any more.. they are *there*