>>>I have a large application that runs fine when compiled into an .EXE. I can update tables with new/edited info. However, when I run a simple program to re-create my indexes I get the error message:
>>>"Cannot update the cursor" on each index command. The code looks like this:
>>>
>>>use \prg\data\mytable.dbf exclusive
>>>delete tag all
>>>index on lname tag lname
>>>index on cname tag cname
>>>
>>>I get the same message for each line of index code. I have tried including and excluding the DBC in the project. I have removed the "DELETE TAG ALL" line. The cursor buffering is set to 1. I checked it after the table was opened.
>>>I also made sure the tables are marked as excluded under the database.
>>>
>>>This operation works fine when run from the VFP 6.0 command prompt. It only give problems when compiled into the .EXE.
>>>
>>>As usual, many thanks in advance to all.
>>>
>>>John J. Henn
>>
>>Is the database opened exclusively? Usually, in an application, the database would be open shared. But for indexing, I believe you'll need to close it and open it exclusive. This does mean that only the person doing the indexing can be in the application.
>>
>>Steve
>
>Steve,
> Yes each dbf is opened exclusive. I have tried all the usual stuff. Does anyone else do this type of indexing from within an EXE?
>
>John

Yes, we had this problem. Finally we removed the table from the database,
rebuilt the project, then added it again to the database, rebuilt again and...
everything was OK. Also I found that occasionally packing you PJX does good. It seems that there are leftovers of objects (like this table) the VFP is compiling into the app.

Eylon