Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cannot update the cursor?
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Cannot update the cursor?
Divers
Thread ID:
00248570
Message ID:
00248570
Vues:
53
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform