Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updatable Cursors:
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Updatable Cursors:
Miscellaneous
Thread ID:
00508483
Message ID:
00508483
Views:
35
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
-- Larry Keyes
Remember only You can prevent Gray Goo. Never release nanobot assembers without replication limiting code.
Next
Reply
Map
View

Click here to load this message in the networking platform