database question


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: database question

  1. #1
    jarrett Guest

    database question


    I have an index created in a table called (agency; candidate key). In the
    program if I enter a agency which is numeric 6, Then delete. If I try to
    enter another agency with the previous number I get a unique index violation
    error. Even if I reindex and validate the database it won't go away. This
    is being stored in the DBC I assume. If I open the table the agency does
    not exist and the index does not find it. Anyone ever had this problem?

  2. #2
    Tamar E. Granor Guest

    Re: database question

    On 14 Jan 2002 19:13:38 GMT, "jarrett" <cooley222@excite.com> wrote:

    >
    > I have an index created in a table called (agency; candidate key). In the
    >program if I enter a agency which is numeric 6, Then delete. If I try to
    >enter another agency with the previous number I get a unique index violation
    >error. Even if I reindex and validate the database it won't go away. This
    >is being stored in the DBC I assume. If I open the table the agency does
    >not exist and the index does not find it. Anyone ever had this problem?


    Keep in mind that deletion in VFP is a two-step process. You mark the
    records as deleted, but they're still in the table until you pack.
    It's a lot like the Windows recycle bin, where the file is still on
    your computer until you empty the bin.

    The reason you're not seeing the record is that you must be operating
    with DELETED set ON, which hides deleted records.

    Tamar

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center