Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cannot update the cursor?
Message
De
31/07/1999 14:30:09
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00248570
Message ID:
00248571
Vues:
17
>I'm probably being dense, but I have a simple REPLACE command for a single field in a "free" table which is located on a Novell server. However, I always get "Cannot update the cursor" from the program, however if I open the table in the Command Window and do the same REPLACE command it works fine.
>
>Here is what I have checked already...
>
>1. SET EXCLUSIVE is OFF at the beginning of the program.
>2. The table is opened like this: USE orders SHARED IN 0
>3. The table is NOT part of a DBC.
>4. The table is NOT read-only based on network rights or OS.
>5. The table is SELECTed prior to the REPLACE.
>6. The variable containing the data for the update is of the correct type.
>
>Here's the code from the program...
>
>lcUpdtDate = DATE()
><snip>
>USE orders SHARED IN 0
><snip>
>SELECT ;
>INTO CURSOR cUpdtOrd
><snip>
>SELECT cUpdtOrd
>SCAN
>SELECT orders
>IF SEEK(cUpdtOrd.clientid)
>REPLACE orders.updtdate WITH lcUpdtDate
>ENDIF
>SELECT cUpdtOrd
>ENDSCAN
>
>So, I can't seem to figure out why it won't update the table??? Any ideas would be greatly appreciated!
>
>Thanks.

By default, cursors are read-only. You can USE...AGAIN the cursor to make it read-write.
Paul M.
MCSE/MCSA/MCT/MCP+I, A+, Network+, I-Net+
Nil carborundum illegitimi.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform