Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2004
    Posts
    3

    Unanswered: can't use delete query

    When I try to use the delete feature in a query, I get an error message that states "INSERT, DELETE, CHANGE TO and SET rows may not be checked". Can anyone tell me why?
    Thanks!
    Gary

  2. #2
    Join Date
    Jul 2004
    Posts
    3

    Additional Comments

    I'm using Paradox 7. I tried this on another computer with Paradox 10 and didn't get the error message.

  3. #3
    Join Date
    Oct 2003
    Posts
    107
    There is no reason to check fields in these types of queries because you are always dealing with whole records for those functions. You can still set delimeters in the fields, just don't check them.

    On edit: I don't know why you do not get the error in Pdox 10, perhaps a change was made and the checks in fields are simply ignored.
    Last edited by lmckelvy; 07-14-04 at 10:24.

  4. #4
    Join Date
    Mar 2004
    Location
    California
    Posts
    502

    Delete Queries . . .

    What I do is first select a new query and place my "selection info" in the fields that I want to flag for deletion. Run the query.

    Then I look at the answer.db table to see if it is correct.

    Then I select "Delete" from the far left section of the query, UnCheck ALL fields but leave my "selection info" and run the Delete Query.

    Then, before I do anything else I look in the :PRIV: folder for the Deleted.db and see if it is correct. If it is not then I use "Tools" "Copy" "Deleted" and point to the original table and replace the deleted data back to it's original table and start over again.

    Otherwise if it's correct you have succeeded!

    Hope this helps. Rick

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •