TechRepublic|Forums|Web Development

Web Development

General discussion

  • Creator
    Topic
  • December 6, 2001 at 10:15 pm #2130895

    Error Handling

    Locked

    by cosmic_chick20 · about 20 years, 5 months ago

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

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Comments

  • Author
    Replies
    • December 6, 2001 at 11:43 pm #3546421

      Error Handling

      by sl-campbell · about 20 years, 5 months ago

      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!

    • March 11, 2002 at 7:30 pm #3651398

      Error Handling

      by sl-campbell · about 20 years, 2 months ago

      In reply to Error Handling

      Is your problem solved?

    • March 12, 2002 at 2:55 pm #3651970

      Error Handling

      by cosmic_chick20 · about 20 years, 2 months ago

      In reply to Error Handling

      This question was auto closed due to inactivity

  • Author
    Replies
Viewing 2 reply threads