Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement