General information
Category:
Coding, syntax & commands
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only