Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Edit view
Message
De
21/04/1998 07:45:01
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00092871
Message ID:
00093609
Vues:
38
Thanks Barbara,

I was just giving Ed an example of when a filtered table is created instead of
an actual file presence.

-myron-
=========================================
>Myron, if you want to force VFP to create a cursor instead of a filtered version of the base table, just add an extra field
>
>SELECT *, .T. as NewField from Mytable into Mycursor
>
>If you need a read-write version of a cursor, then USE it again. The new copy will be read-write.
>
>use dbf('MyCursor') again in 0 alias NewCursor
>
>
>HTH
>
>
>>On a plain Select-SQL VFP does not alway create a new table, it sometimes (based on
>>how you structured your SQL) just does a filter over the source table.
>>
>>To test this do:
>> SELECT * FROM -tablename- INTO CURSOR fTest
>> SELECT fTest
>> ? DBF()
>>
>>-myron kirby-
>>===================================
>>>Hi Ed,
>>>
>>>I wandering why any cursor created by plain Select-SQL is not editable. What is behind the scene that prevents editing?
>>>
>>>Sincerely, Igor Gelin, System Developer.
>>>
----------------------------------
-myron kirby (mkirby2000@gmail.com)-
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform