Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexing SQL results
Message
 
 
À
10/09/1997 18:59:01
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00049056
Message ID:
00049443
Vues:
55
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform