Information générale
Catégorie:
Codage, syntaxe et commandes
Larry,
[snip]
In VFP 7:
select * from mytable where 1 = 0 into cursor mycursor readwrite
IN VFP 6:
select * from mytable where 1 = 0 into cursor c_temp nofilter
use dbf('c_temp') again alias mycursor in 0
select mycursor
use in c_temp
This gives you the structure with indexes.
[end snip]
OK, I'll bite. The SQL SELECT statement with a simple WHERE filter creates a pointer into the source cursor. The "ReadWrite" VFP7 clause and the "USE... AGAIN... IN 0" VFP6 commands create a new file on disk with the same header.
How do the indexes get carried along?
Actually, I just gave this a shot and the index did NOT come along. Am I missing something?
Regards,
Thom C.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement