General discussion

Locked

Error Handling

By cosmic_chick20 ·
How do I do an error handling message in a delete code, when all fields are deleted?

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Error Handling

by sl-campbell In reply to Error Handling

Sorry, I am not sure what you are asking for, or rather I do not know how you are doing the deletion and with what program?
What do you mean by error handling? System, DAO/ADO, or do you want to raise your own error and if so, then under what cercumstances?
Is this a bulk deletion? (DELETE * From Table). If so, then make sure you use the option: dbFailOnError.

Or are you are trying to say: When I delete records in a loop and there are no records to delete then an error occurs on the Delete command? If so, then always do a check on the BOF and EOF first to see if there are any(more) records to delete and after a delete move off the deleted record with MoveNext.

Other than that, just set an On Error Goto ... statement at the begining of the proceedure.

Please let me know!

Collapse -

Error Handling

by sl-campbell In reply to Error Handling

PS. You have posted this same question twice!

Collapse -

Error Handling

by sl-campbell In reply to Error Handling

Is your problem solved?

Collapse -

Error Handling

by cosmic_chick20 In reply to Error Handling

The question was auto-closed by TechRepublic

Collapse -

Error Handling

by sl-campbell In reply to Error Handling

Is your problem solved?

Collapse -

Error Handling

by cosmic_chick20 In reply to Error Handling

The question was auto-closed by TechRepublic

Collapse -

Error Handling

by cosmic_chick20 In reply to Error Handling

This question was auto closed due to inactivity

Back to Web Development Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums