Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot update the cursor?
Message
From
31/07/1999 14:26:42
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Cannot update the cursor?
Miscellaneous
Thread ID:
00248570
Message ID:
00248570
Views:
51
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.
Next
Reply
Map
View

Click here to load this message in the networking platform