Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Cannot update the cursor
I am using vfp 7.0. I am porting a fpw 2.6 app and trying to touch it as little as possible. The original app is using a dbf table called layoff.dbf and setting a relation into it so that navigating in a different work area moves the pointer in the layoff work area. That layoff.dbf table is obsolete and I have created a remove view called layoffs.
CREATE SQL VIEW "Layoffs" ;
REMOTE CONNECT "JobMachine" ;
AS SELECT * FROM hr_actions..Layoffs Layoffs
I have set the primary key, but I do not allow any updates. (It would be bad if the users of this app were to change the layoffs table.)
I USE the view and then create an idx file (or cdx doesn't matter) in the user's temp folder so the relation may be set.
indexFile = GETENV('temp') + '\Layoff_' + ID() +'.idx'
INDEX ON lname TO indexFile
...
When I run this app from the IDE, it works fine. When I compile it into a Win32 exe, I get the "Cannot update the cursor" error saying I am trying to write to a read-only file when it tries to create the index file.
How can I get this to work? What file is read only for the exe and not for the IDE? All other settings SEEM to be the same.
Thanks,
Cheryl
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement