>>>Hi all,
>>>I need to create an empty cursor from multiple table structures.
>>>I was about ready to create some code using afields, ascan and alter table
>>>But I sure this is simple a SQL ?
>>>
>>>Any help? thanks.
>>
>>

>>SELECT *;
>>FROM Table1;
>>INNER JOIN Table2 ON 1=1;
>>......
>>WHERE 1=0;
>>INTO CURSOR crsTest READWRITE
>>

>>But if you have fields with the same names across tables, you better use field list instead of [*] in SELECT.
>>Also I am not sure if READWRITE is available in VFP7.
>
>Funny, Boris, I think it's way long your bed time now... What time is it now in Bulgaria?


About 1 AM :-)