Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Edit view
Message
From
21/04/1998 07:45:01
 
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00092871
Message ID:
00093609
Views:
37
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)-
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform