Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Recreate Clipper Index on Win 10 1

Status
Not open for further replies.

TomDunne

Programmer
Jul 14, 2019
3
IE
Hi

I am supporting a multi user accounting package which runs on Win 10. The software has a reindex feature in the case of index corruption which brings down all stations for a couple of minutes when run. I have a requirement to update a couple of clipper index files (NTX) a couple of times a hour to accomplish a data update issue. I have written a small program in Clipper 5.2 to update these index files & can run the small update exe on a XP workstation & all is good. What is the easiest way to enable this exe to run in a Win 10 environment? - I am familiar with Clipper & FoxPro & Visual Fox Pro.

Tom
 
Are you running this from within VFP? If so, you should be able to run it under Windows 10 in exactly the same way as under XP. Just use either the VFP RUN command or the Windows ShellExecute() function to execute the Clipper executable.

If you don't know how to use ShellExecute(), see here.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads
 
Thanks for the reply Mike - I know I am missing something - when I try to run the clipper 5.2 exe in windows 10 I get the standard message "Unsupported 16 Bit application - cannot start or run due to incompatibility with 64 bit versions of windows" - When I run it from within a VFP 9 using the RUN command I get the same message -
 
Another possibility ....

A firm called Progress have an ODBC driver that claims to be able to create Clipper indexes. It's a 32-bit driver, so should run on Windows 10.

It should be easy to write a small VFP program that connects to the driver (using SQLCONNECT()) and sends a CREATE INDEX command (via SQLEXEC()).

The firm's website is here:
If you search their documentation for CREATE INDEX, you will see the syntax for the relevant command.

I have never used this product, so this is not a recommendation. But it would be worth taking a look.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads
 
Hi Guys - thanks for all the suggestions - I am under a lot of pressure on this one & don't have much time to sort it - I came across these guys - - they have a product called IndexMan - which is command line driven & can create NTX files on the fly - I can call it as required from VFP - it's fairly cheap & got me out of a hole on this occasion - it really is a one off problem so I'm happy enough to take the easy way out - When I get a bit of time I will start looking at more elegant / programmatic solutions - thanks again
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top