Web Development

General discussion

Gravatar
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

gravatar
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!

gravatar
Collapse -

Error Handling

by sl-campbell In reply to Error Handling

PS. You have posted this same question twice!

gravatar
Collapse -

Error Handling

by sl-campbell In reply to Error Handling

Is your problem solved?

gravatar
Collapse -

Error Handling

by cosmic_chick20 In reply to Error Handling

The question was auto-closed by TechRepublic

gravatar
Collapse -

Error Handling

by sl-campbell In reply to Error Handling

Is your problem solved?

gravatar
Collapse -

Error Handling

by cosmic_chick20 In reply to Error Handling

The question was auto-closed by TechRepublic

gravatar
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)  

Start or search

Related Discussions

Related Forums