>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.