>>>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.
>
>But he is issuing a SELECT ORDERS prior to the replace.
>Mark:
>If you issue a SET STEP ON, is the replace line the problem. I don't see the code that sets up and index that you can issue a SEEK against.

True enough. I was going by the error message and didn't even read the code. 8^P

Paul M.
MCSE/MCSA/MCT/MCP+I, A+, Network+, I-Net+
Nil carborundum illegitimi.