Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select into a table
Message
De
04/08/1999 15:59:43
Nancy Folsom
Pixel Dust Industries
Washington, États-Unis
 
 
À
04/08/1999 11:51:26
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00249767
Message ID:
00249943
Vues:
21
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform