General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>More anomalies?
>
>Is there any way to get the results of a SQL statment into an updatable cursor? We've noticed that if you use SELECT ..... INTO CURSOR, the resultant cursor is read only and can't be updated with INSERT or UPDATE statements.
>
>Cursors created with CREATE CURSOR behave just like tables and can be UPDATED, ALTERED, or INSERTED.
>
>The problem I'm trying to get beyond is the whole issue of temporary files when creating elaborate queries. Ideally, I'd like to use cursors instead of creating tables for queries requiring multiple intermediate steps.
>
>--- L
Assume the cursor that is the result of your query is named "query". You can write to this cursor by issuing the following command:
USE AGAIN DBF('query') ALIAS whatever
Previous
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