Update After A Row has been Deleted

[eveCalypso]

Hello All,

I need to run an 'update stock balance' stored procedure when a user deletes an invoice item.
For some strange reason the following events all fire BEFORE the actual delete takes place in the DB, namely:
BeforeDelConfirm
AfterDelConfirm
Delete

I need to know when the actual delete has been done, as the stored procedure will use database values only for its update. Am I missing something/an event? I am running Access 2000 with SQL Server 2000.

Any help would be appreciated.
Regards,
EvE

 

[KenReay]

Hi

I am not an expert on running stored procedures, but I would have expected that the SQL (server) update and the Access Application would run in parallel, ie the access app does not wait for the SQL to be processed, it just sends the command to the server, then proceeds with its own processing

I would think the way to achieve what you are doing is to include the recalculation in the stored procedure which does the delete (or call it from there) so that you can force the processing to be 'in line'



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[eveCalypso]

Good Day Mr Reay,

Thank you for your reply, however, I am not in charge if the delete ;-) I just let Access handle that through its default 'Delete toolbar'. That is why I need access to an event which can tell me when the delete has completed.

Options are to create a delete button on my form or creating my own toolbar(s) etc, but that would be inconsistent with the rest of the app.

Any other ideas?
Regards,
EvE

 

[KenReay]

Hi

I am not absolutley sure about this, but I would expect that deleting via teh tool bar would not cause from events related to Delete to fire, I see no alternative therefore but to do this via a form

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[eveCalypso]

I have added a button to my distress, but what can one do Thank you for your help and advice.

Regards,
EvE