Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 200
  • Last Modified:

can i create a ndx index in a vb application?

how can i create a .ndx index of a .dbf file (dbIII) in a vb5.0 application?
0
ninjanat
Asked:
ninjanat
1 Solution
 
cymbolicCommented:
Now, I haven't tried this, but I've read that under DAO if you define the database in an opendatabase function as "DBASEII", then when you append an index to the indexes connection, it is supposed to know enough to creat both the index and the .inf file that associates the index to the .dbf.  There is no comparable function available for a pack, however.  You still have to use an outside program module for that.  

One of the most efficient methods for working with these functions should you find that you need to use and outside program is the DBLIB library for quick basic.  Rather than requiring a meg or more of program code to perform simple functions to pack and index, this library combined with the QBasic compiler made small, fast program code that could easily and quickly be shelled out to from VB to perform necessary functions for you.
0
 
ninjanatAuthor Commented:
i've tried the sql statement create index.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now