I have a table that has 3 columns (ID, STOP_NUM, NUM_STOPS). Every time I insert a record for an ID that already exists, I need to update the NUM_STOPS field to the total number of records for the given ID. For example:
After inserting a new record, it should look like this:
I've tried to write this as a query but I keep getting the "query is not an updateable query" message.
Code:
ID STOP_NUM NUM_STOPS
1001 1 1
After inserting a new record, it should look like this:
Code:
ID STOP_NUM NUM_STOPS
1001 1 2
1001 2 2
I've tried to write this as a query but I keep getting the "query is not an updateable query" message.