Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select Into 'self' not possible after Use Again
Message
From
09/03/2000 08:11:37
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00343598
Message ID:
00343613
Views:
17
>>
Mark,
>>Other than some cleanup benefits cursors are "always" written to disk. IMHO take the easy way and select into table.
>>OTOH if you have a DBC open (or create a temp one) you could create-drop a temp view on the fly.
>>Cetin
>
>Cetin,
>I'm actually not looking for the 'easy way'; I want to know what happens and why it doesn't work.


W/o seeing some code my best guess is that you're not selecting into a true cursor. You could make a true cursor :
-Including a dummy nonexistant field in SQL
select *, 1 as myDummy ...
-Including a dummy .t. expression in where
select * rom myTable where .t. [ and ...] ...
Above are also FP2x compliant. In VFP you could also :
-Use "nofilter" clause
select ... nofilter

A sample readwrite cursor :
select * from myTable into cursor crsTemp nofilter
use (dbf("crsTemp")) in 0 again alias "myRW"
use in ("crsTemp")
select myRW
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform