We help IT Professionals succeed at work.

Indexing Clipper DBF using VB 4.0

nangina
nangina asked
on
Medium Priority
355 Views
Last Modified: 2010-05-03
I want to re-index clipper dbfiles ( NTX ) using visual basic 4.0.  Can anyone provide a routine or source code to do this?
Comment
Watch Question

Author

Commented:
Edited text of question

Author

Commented:
Code necessary!

Commented:
It's a hairball for your own code, and you know, once you write your own routine, you will be held responsible for all those indexing problems that occur anyway, then blamed for failures in other programs that use 'em!  Here's the route to go.  Get the Codebase package from Sequiter Software.  It provides a library for using xbase/clipper files and indexes, as well as all uses of your database files, including packing.  I've used it for years in conjunction with Clipper itself, and it supports the .NTX as well as other index formats.  Your user won't know that you didn't write the routines yourself, and it will be a much superior soution to anything hacked together in basic code.

Author

Commented:
Are there other options that are possible if I avoid this method?
Shipping time, learning time, etc are a factor.
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
I would be interested in getting the code for QB 4.5. I guess I have no other option but to use the libraries.  Can I use Codebase to read a dbf file that contains the index strings, and then use these strings to re-index the database files? This is of utmost importance since, the index strings use clipper functions like DBLOWER, so the index is based on the result of this function e.g. "DBLOWER(Code+Company)".  Can codebase handle such an index?
It is possible to link (attach) Clipper .dbf files to a Microsoft Access
database. To do so, link it as a dBASE IV file. Note, however, the index
may or may not be updatable.
 
Clipper provides an alternative indexing method (.ntx) to the dBASE
standard (.ndx). The Clipper index format is not recognized by Microsoft
Access; therefore, Microsoft Access cannot update it correctly.
 
However, if the Clipper application was developed using the dBASE .ndx
format, Microsoft Access updates the index correctly.


Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.