General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Cannot update the cursor?
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only