>>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?
If it's not broken, fix it until it is.
My Blog