Index tag is not found

[livezone]

Hi,

I have compiled code which appends the data from a csv file to foxpro table. After the append finish it gives an error message saying "Index tag is not found" Table Name is pcmaster.dbf and I have not found any cdx file there. I have used foxpro 10 years ago and have not much knowlege now. If I say ignore or cancel it triplicate the number of record too.

Any idea or suggesion. (Foxpro version is 3.0)
Shafiq

 

[crewchiefpro6]

Check the code after you open the table or append it. You probably have code like this:
set order to tag (lalala) where lalala is the name of your field that is indexed and it either does not exist, is corrupted or the cdx file is damaged.

Try this:
use pcmaster exclusive
delete tag all
index on (yourfieldname) tag yourfieldname additive

Then try the append.




Don Higgins

http://www.crewchiefpro.com

 

[livezone]

I don't know if we have the code or not as Append is doing from a menu option. Somehow I found an old CDX file and I throw this file in the directory and then it uploaded the record fine. There was no duplication but still I get the Index is not found error. But as the record loaded ok, I did not care for the error. When I try to load the next batch now it is saying "Unrecognized command or verb". I deleted the cdx file from this folder. What will be my option now.

If I want to look for the code, which will be the file extension? Can you suggest any workaround
Shafiq

 

[GriffMG]

You could email me the .exe and I'll have a look at it for you (if it is less than 5mb - and you zip it up first).

tektips (at) finedata.com

Martin

Regards

Griff
Keep [Smile]ing

 

[crewchiefpro6]

Surely you have the menu file, look for the the files that have MNX or MNT or MPR file extensions. That is where the code will be kept, unless it points to a procedure file.


Don Higgins

http://www.crewchiefpro.com

 

[Mike Lewis]

Livezone,

You're going to find it really tough to debug this without looking in the source code. If you don't have the source code, perhaps you should try to get it.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)

 

[livezone]

Hi,

I may not be able to send the exe file but however I find one piece of information.

The application directory contains a file name
pcmaster.inf

The contents of this file is

[FoxPro 2.0]
MDX1=L:\MyApplicationFolder\PCMASTER.CDX

Is this mean that the cdx file will be in a different folder than the application?