Information générale
Catégorie:
Codage, syntaxe et commandes
Kevin,
>>I dont understand. The changes are in my local cursor.
When you're running ODBC to an external data source, the "local" cursor is actually a view that's connected to the backend db. For the most part it does look and act like a local cursor, but there are some actions that can't be performed on this cursor. To make a view a "real" local cursor you will have to alter the cursor with a SQL query:
SELECT *, .F. AS ForceLocal ;
FROM [view] ;
INTO CURSOR [local_cursor_name] READWRITE
ALTER TABLE [local_cursor_name] ;
DROP COLUMN ForceLocal
DROP TABLE [view]
At this point you now have a truly local cursor. Unfortunately it took three writes to make it happen and you will have to move the data back to the backend DB to apply any updates.
I usually reserve this for cursors where I will be making other changes to the local cursor on the workstation.
Regards,
Thom C.
Précédent
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