Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2006
    Posts
    3

    VB code to update dbase foxpro dbf and Index idx file

    Hello Guys, I need Help I am making a program using VB code i will use a data base DBF i can edit the dbf but the index IDX can't be updated help me to update the idx file
    thanks!
    Last edited by ic3man; 10-18-06 at 01:19.

  2. #2
    Join Date
    Oct 2006
    Posts
    4

    Thumbs up Updating the respective index files

    While updating a .DBF file (adding/updating/deleting), all the indexes present for that .DBF file have to be opened with the .DBF file. So any changes to the .DBF file will update the indexes. Reindexing is another option, but this is a very costly affair.

  3. #3
    Join Date
    Oct 2006
    Posts
    3

    How can i update the idx file?

    How can i update the idx index of dbf without reindex the file is there anything i can do?

    please i really need the codes thanks

  4. #4
    Join Date
    Oct 2006
    Posts
    4

    Thumbs up

    As suggested in my previous post, indexes can be updated for a .DBF file, if those indexes are opened simultaneously with the .DBF file.
    Here it is :
    SELE 0
    USE ORDER INDEX ORDER1,ORDER2,ORDER3........
    APPE BLANK
    REPL ORDERNO WITH nOrderno
    REPL ORDERDT WITH dOrderdt
    REPL AMOUNT WITH nOrderamt
    .
    .
    .
    COMM
    UNLO
    The above statements will save a record in the .DBF file and also will update all the indexes opened. In this case, ORDER1.idx,ORDER2.idx and ORDER3.idx.

  5. #5
    Join Date
    Oct 2006
    Posts
    3
    how can i code that in visual basic?

Posting Permissions

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