IDX file problem in VFP6

[fkwong]

I got a "Record is out of range" error when I try to open a table with IDX file. I deleted the IDX file and rebuild the IDX and still have the same error.

Help.

Thanks

 

[ramani]

Hi,

May be you are having a CDX Index file ?

SO try reindex with the command.. REINDEX from the command window after you make the attempt to open the file.

ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[fkwong]

Yes, I do have a CDX file but with different tags. This particular IDX file is for other purpose. For this particular situation, this program opens the table with this command:

USE jkarofil INDEX jkarofil.idx SHARE

The same command works in the command window but does not work in the VFP6 app. It was still working this morning but I already verified all the things that I can think of. Very strange...

I have another similar issue with same table name in different directories. The above command open fine in the command windows and the data is in the corrent order, but in the application, it open with NO ORDER?? I am 100% sure that the code has not been change.

 

[ramani]

Hi

Make a wild search in your computer along the path for the jkarofil.idx file.
You must be having this index file somewhere else and not in the data directory. May be in your default directory or project directory.

So VFP uses that file when open from Command window.

Once you identify that, life will turn to normal.

ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[rgbean]

It seems to work for me, but remember that if any records were added, deleted or changed in a field that's part of the index expression when the file was opened without this clause, the .IDX file may be out of date, and you should either REINDEX or recreate it. This was always the biggest pain with .IDX files!

Rick

 

[fkwong]

Rick, you are absolute correct, it is pain in the butt with the IDX file, it will be gone after the conversion.

I will follow Ramani's advice to search the path.

You guys are GREAT! THANKS!