Hi! Can anyone please provide me with a little bit of information regarding this subject? I think I've heard from a lecturer that there is a command to auto-update the entries of a table. For example, when a new record is inserted, the salary column would be auto-inserted with (rough_salary - tax_rate) without having the user to key in the salaries. In case, it is trigger you are thinking of, I don't think that is it. Anyone get me? Thanks.
red_evolve
1
Posting Whiz
Recommended Answers
Jump to PostWell to my knowledge of SQL or Access for that matter. It would be a trigger that does something like that. There is no other way to update a column automatically via a calculation without using a trigger.
So I would be extremely surprised that there is another way. …
All 4 Replies
Paladine
138
Master Poster
Team Colleague
red_evolve
1
Posting Whiz
Paladine
138
Master Poster
Team Colleague
himerus
0
Junior Poster in Training
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.