General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>hi all:
>
>when i run the SQL statement -
>
>Select col1, col2, ... from TABLE INTO CURSOR XYZ FROM ABC
>
>the resultant columns of SQL statement are read-only.
>
>is there any way by which these values in the cursor can be modified ?
>
>sincere thanks in advance
If you are using VFP 7, look at the new READWRITE clause. If not, you can do this with the resulting cursor:
SELECT 0
USE DBF(ExistingCursorName) ALIAS (NewCursorName) AGAIN
NewCursorName should be updatable.
Steve
Previous
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