Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select into a table
Message
From
04/08/1999 15:59:43
 
 
To
04/08/1999 11:51:26
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00249767
Message ID:
00249943
Views:
20
Sam-

>I can't use a cursor since I need to edit a column from the select statement table.

You can do that. This technique works for creating a modifiable cursor.
SELECT * FROM someTable INTO CURSOR tempCursor NOFILTER  && make sure to use NOFILTER clause
BROWSE && You won't be able to edit data.
USE DBF( 'tempCursor' ) AGAIN IN 0 ALIAS myCursor 
USE IN tempCursor
SELECT myCursor
BROWSE && you'll be able to change data
This is actually not as complicated as managing the use of physical tables. Well, of course the cursor is real, too, just temporary and you don't have to worry about naming and conflicts.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform