>Hi everybody,
>
>Say, I have a table with 60 or more fields. I want to create a cursor with the same structure. Is there a native VFP command, which would allow me to do that? I could not find it in Help. Of course, I have a workaround like building CREATE CURSOR statement on the fly using afields() and iterating through all fields, but it seems to be an overkill...
>
>Thanks a lot in advance.
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.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao