search

magnusandy / 355DatabaseSQL

0 stars 1 forks source link

Trigger: on insert into item locatons, update the previous end date for that item. *** #6

Closed RyanLaForge closed 9 years ago

RyanLaForge commented 9 years ago

if an item moves, change the previous null end date for that item. NOTE*\ What if we go over our planned dates? exp; item1 11:30 null item1 12:30 null item1 1:00 null (new record)

What do we do about the previous end dates?

RyanLaForge commented 9 years ago

currently I handled this by assuming the data was correct, and that the items were moved at the appropriate time; as a result, the current trigger will only update the latest record that is already in the table.

iainworkman commented 9 years ago

Done.