RestonDeveloper
Programmer
i am creating a winform that reads in an access database and changes the data and puts it into a mediator table, then i call i have 3 sql procedures: sp_create, sp_update, sp_delete
procedures compare mediator and main table, for records in mediator that aren't in main, i update a [actiontaken]='added' and run insert into statement on that group. if records are in both [actiontaken]='updated' and run update main statement. but deleted i just run delete statement nothing in mediator table to flag.
how do i let user know which events were deleted, for simplicity i'll just let user know how many were deleted for now.
thanks any pointers.
procedures compare mediator and main table, for records in mediator that aren't in main, i update a [actiontaken]='added' and run insert into statement on that group. if records are in both [actiontaken]='updated' and run update main statement. but deleted i just run delete statement nothing in mediator table to flag.
how do i let user know which events were deleted, for simplicity i'll just let user know how many were deleted for now.
thanks any pointers.