Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing SQL results
Message
 
 
To
10/09/1997 18:59:01
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00049056
Message ID:
00049443
Views:
60
>To verify that:
>1. Take a small dbf, 2-3 records, 2-3 fields. (Small enough to fit into memory.)
>2. Run SELECT *, .t. AS Dummy FROM MyTable INTO CURSOR TempRes NOFILTER
>3. ? DBF() && returns a valid temp file name.
>4. ? FILE(DBF()) && returns .f.
>5. USE (DBF()) AGAIN && Gives an error because the temp file doesn't exist.

Vlad, I cannot duplicate the failure. For example, given a 10 record table with 2 columns, each of length 5 characters. I have 80 meg of memory on my machine, so I think the table is small enough to fit into memory:

select * from SmallTbl into cursor SmallCursor nofilter
use (dbf("SmallCursor")) again in 0 alias NewCursor
use in Select("SmallCursor")
sele NewCursor && This is a now read-write cursor with 10 records.

This works just fine. BTW, I'm using 5.0a.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform