Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexing SQL results
Message
De
10/09/1997 20:34:10
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00049056
Message ID:
00049445
Vues:
63
>>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.

This is kinda weird. I'd like to know why this works for you and not for all the others that tried it!

I'm using also 5.0a. What's the date of the product in the About window? What OS are you using?

Vlad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform