Foxpro indexing tool

Visual FoxPro and earlier versions of FoxPro This software offers a solution to users who want to make changes to data in FoxPro tables. This software offers a solution to users who want to vertically merge one FoxPro table into another in the same or another database.

This software offers a solution to users who want to use MS Excel as a front-end interface to a FoxPro database. SQL to FoxPro database conversion There are at least four computers that uses this files thru the program, all this clients have to turn off there program. It is a lot of hassle. When I add an entry to the database, from the program, it automaticly indexes it, just like my script is suppose to do. But no. Here is my script, this script works fine, no errors and the data is entered in the database correctly.

Maybe it has to do with that it is a different server? Maybe the computer that is running this script has access to the dbf files and in some cases, the fpt files but not the cdx? It doesn't make sense though. Tamar E. Then I stand corrected. Always dread the visit from the German doctor. I was thinking maybe it is something with the program that blocks it. I tried with the program completely shut, it's still the same.

Do you know of any program that can debug and look for a connection to the cdx file, I will try to play with the permissions in the mean time. Also, when I opened Index Manager in the same program, it says that there are no index files connected to that database, even though there is one. There is an option where you can browse for your own index file, so I tried the CDX file, It responded with an error.

I think that this program is using a special kind of index, maybe it's own kind of index? That would explain why it doesn't insert it to the index file, it would also explain why DBF Manager acted so strange. There are 4 databases in total that I am using with this script, the other three has properly working indexes but they don't get updated , I can see what fields that are indexed. Funny, the most important database is the one that I can't see. Maybe I can force a reindex now that I know how the index is built, or maybe usa a "drop index" command and then rebuild it.

I am sure that this are the indexes because they all had the same pattern surounding them and most of all, this are the only thing that could be read from the file, everything else were jibberish. I don't know which tag, order or if they are unique. But the three files had all ASC and no one was unique, and the tags I will give them that order that I found them in. Alex Feldstein wrote:. Connection" Conn. I got the same error as the first time:.

Line 7 is on the second row, that means that the first one worked, but not the second one. No, I opened it with FoxPro wierd that I never thought about that before , and it said the same thing almost : File if.

Anyway, I read about it on the internet and I think a MVP said that it might be a security feature from the program that blocks the index from being opened from any other program.

Either way, if one database doesn't index out of three then that is okay But the other three databases are not working either I can't get the entrys to register in the CDX file Could it be that the program that created and uses this files have its own special-made cdxs? When it's indexing, it says "indexing pro.. Granor wrote: If you're using non-structural CDXs or the old IDXs which your message implies isn't the case , you have to be sure that the index file is open before updating the table.

One doesn't have the same name, and it seems as if this case is very special and unusual and that the ordinary rules doesn't apply to it. The content you requested has been removed. Ask a question. Quick access. Search related threads. How can I take a look at gendbc. Do a just do a modi comm to view the gendbc. I have FoxPro 8. You can upsize an entire database, or just individual tables during the wizard process.

DRapp DRapp Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Thanks, I know, I don't really need it so much. For newer applications, I just open a new instance of VFP and set strictdate right from the start either in startup or in main program.

Even then, I don't use strictdate so often - even though it was the recommended way from the moment when it first appeared.

Habits are a strong force. Maybe closer to the year problem, I think. A matter of taste then. VFP doesn't seem to reject it, too. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. The Tek-Tips staff will check this out and take appropriate action. Click Here to join Tek-Tips and talk with other members!

Already a Member? Join your peers on the Internet's largest technical computer professional community. It's easy to join and it's free. Register now while it's still free! Already a member?